Oracle

This Oracle Grid Infrastructure 11g: Manage Clusterware and ASMOracle Grid Infrastructure training helps you develop a deeper understanding of Oracle Grid Infrastructure components. Expert Oracle University instructors will help you explore the Oracle Automatic Storage Manager (ASM), ASM Cluster File System and Oracle Clusterware. Learn To: Describe the Oracle Database 11g grid infrastructure. Administer ASM and ACFS using both command line and graphical user interface clients. Configure and manage ASM and ACFS. Install and configure grid infrastructure. Use Oracle Clusterware to make applications highly available. Describe grid plug and play. Troubleshoot grid infrastructure. Add and remove nodes. Upgrade or patch the grid infrastructure environment.

In this course, you’ll learn how to use Oracle Database features to meet the security, privacy and compliance requirements of their organization. The current regulatory environment of the Sarbanes-Oxley Act, HIPAA, the UK Data Protection Act and others requires better security at the database level. Learn To: Implement Oracle Database security features to ensure the data is secure Implement Oracle Database security features to ensure compliance with regulations

The course extensively covers the concepts and usage of the native data types, functions and operators available in Oracle Spatial for implementing geospatial applications and location-based services. Using the Oracle Application Server MapViewer, students learn how to render maps and view geospatial data managed by Oracle Spatial or Locator. Students also get introduced to basics of geocoding and routing concepts. Demonstrations and hands-on practice reinforce the fundamental concepts. The Oracle Spatial: Essentials course is applicable to both 10g and 11g audiences. Learn to: Load geometries into spatial layers Create spatial layers by using the SDO_GEOMETRY data type Employ spatial operators and functions to generate and access 2D geometries Setup and demonstrate Oracle Maps Run spatial queries to perform spatial analysis Use MapViewer and the Map Builder tool to render maps

This Oracle Database 11g: Data Guard Administration Release 2 training helps you develop the skills to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtimes. Explore how Data Guard standby databases can be used to support production functions such as reporting, querying and testing, while in a standby role. Learn To: Offload business processing needs to another system Offload backup needs to another system Build highly available systems Offload business processing needs to another system

This Oracle Database 11g: New Features for Administrators Accelerated course teaches you about change management features and other key enhancements in Oracle Database 11g Release 1 and Release 2. You’ll explore managing change, diagnosing and recovering from problems, ensuring high availability, while improving scalability and performance. Learn To: Implement manageability features to simplify database management. Use change management features to master database changes. Use database advisors to provide proactive database monitoring. Increase data availability by using ASM, RMAN and Flashback feature enhancements. Describe the key new capabilities in Oracle Database 11g (11.2.0.2). Identify how these new features can be applied in your own environments. Identify technical advantages and business benefits associated with these technologies. Proceed towards the adoption and implementation of Oracle Database 11g Patch Set 1 with greater confidence.

This Oracle Database 11g: RAC Administration Release 2 NEW training explores RAC database administration in the Oracle Grid Infrastructure environment. Expert Oracle University instructors will help you develop the skills to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL and SQL*Plus. Learn To: Install Oracle Clusterware and Real Application Clusters. Administer a RAC Database. Administer database services in an RAC environment. Administer Oracle Clusterware. Add/Remove a node to/from a cluster. Patch Oracle Clusterware and RAC software. Upgrade and path Oracle RAC databases. Study the new connection architecture and how to make those connections highly available.

In this course, students learn how to use Oracle Secure Backup, which supplies reliable tape backup of the database through direct integration with RMAN and it also provides general file system backup to tape. Students install Oracle Secure Backup and use it to back up and restore Oracle Database files, as well as file-system data. Students also learn how to perform advanced management tasks, such as, tape vaulting. Learn to: Manage Oracle Secure Backup Install Oracle Secure Backup Backup/Restore databases to/from tapes Backup/Restore file-system data to/from tapes

In this seminar, students will learn about Oracle Real Application Clusters installation and administration concepts in a Solaris environment. Students will learn how to prepare Solaris cluster nodes in preparation to accept an Oracle Grid Infrastructure installation using Oracle ASM for cluster storage needs. In addition students will learn how to create a Real Applications Cluster database using Oracle ASM for the database shared storage. Finally, Students will learn to administer Oracle Clusterware, Oracle ASM, and the Oracle RAC database in a Solaris environment. The seminar content is intended to aid current Solaris system administrators successfully install, configure, and administer Oracle RAC database environments. This seminar provides no hands-on lessons for any of the topics covered.

In this course, you are introduced to the key new capabilities of Oracle Database 11g Release 1 and gain an understanding of how to take advantage of them. This course also focuses on Oracle Database 11g Release 1 innovations that enable you to mitigate the chaos that database and application upgrades can cause. You learn about features you can use to record production workloads and then play them back in a test environment so that you can determine and eliminate potential issues before deploying changes to your production environment. The instructor lecture is supported by recorded product demonstrations. By attending this course, you can more effectively realize the positive benefits of database and application upgrades while minimizing the negative side effects. Learn To: Take advantage of the planned key new capabilities of Oracle Database 11g Release 1 Realize the positive benefits of database and application upgrades

In this course you will learn to configure an Oracle Database Firewall and an Oracle Database Firewall Management Server. You will learn to use enforcement points to deploy Database Firewall policies. You will use the Oracle Database Firewall Administration Console, a Web browser-based application for configuring, managing, and monitoring the system. You will configure stored procedure auditing and user role auditing. The configuration and use of local and remote monitoring is discussed in this course. Additional topics include reporting, archiving data, and email alerts. You will use the Oracle Database Firewall Analyzer to create policies that the Oracle Database Firewall uses to block, alert, log or permit SQL statements. Learn To: Use Oracle Database Firewall to monitor and block unauthorized SQL traffic before it reaches the database Create a defensive perimeter that helps prevent SQL injection, application bypass, and other malicious activity from reaching the database Create white-list, black-list, and exception-list based policies to protect databases Generate customized reports to comply with regulations

This Database 11g: Managing Oracle on Linux course is designed to give the Database Administrator a firm understanding of the components required to successfully deploy an Oracle 11g database on Oracle Enterprise Linux. Learn To: Configure and verify the Linux operating system for optimal performance with an Oracle Database. Tune the database to take advantage of the Linux operating system. Learn administrative tasks related to the database like file system choices, kernel and memory model selection, automated startup and shutdown scripts, and customizing the database for Linux. Optimize the Linux environment for Oracle Database. Discover Linux tips and tricks. Prepare and update a Linux 64-bit system for an Oracle Database silent installation.

The Oracle Database 11g: Implement Streams course is a hands-on introduction for Streams Administrators, DBAs and others who need to know how to share data and messages between schemas, applications, and Oracle databases which can be continents apart. This course begins with “Guided Configurations”, both in Oracle Enterprise Manager and via command line (using PL/SQL packages). The second unit addresses “Manual Configurations”, which is followed by “Customizing your Configurations” with transformations and apply handlers. The unit on “Extending Streams” includes topics such as Configuring Downstream Capture, Synchronous Captures, XStream and extending the Streams configuration automatically, with a single MAINTAIN procedure or wizard, or by adding components individually in multiple steps. The last unit on “Managing and Monitoring Streams” includes the split-and-merge functionality, analyzing and avoiding data conflicts, comparing data, best practices and troubleshooting guidelines. The appendices can be used to address additional customer needs, such as Advanced Queueing (AQ). This course is based on Oracle Database 11g Release 2. Learn To: Setup and configure a Streams environment Administer and customize a Streams environment Manage data conflicts Monitor and troubleshoot a Streams environment

This Oracle Database 11g: Data Warehousing Fundamentals training will teach you about the basic concepts of a data warehouse. Explore the issues involved in planning, designing, building, populating and maintaining a successful data warehouse. Learn To: Define the terminology and explain basic concepts of data warehousing. Identify the technology and some of the tools from Oracle to implement a successful data warehouse. Describe methods and tools for extracting, transforming and loading data. Identify some of the tools for accessing and analyzing warehouse data. Describe the benefits of partitioning, parallel operations, materialized views and query rewrite in a data warehouse. Explain the implementation and organizational issues surrounding a data warehouse project. Improve performance or manageability in a data warehouse using various Oracle Database features.

This Oracle Database 11g: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You’ll learn to develop an appropriate strategy for backup and recovery procedures; please note that this course is based on Oracle Database 11g Release 2 Patch Set 1. Learn To: Develop appropriate backup and recovery procedures to address your business needs. Employ Oracle Database recovery procedures to recover from media failure. Use Flashback Technologies to complement backup and recovery procedures.

This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam. Learn To: Install Oracle Grid Infrastructure. Create and manage users. Install and configure an Oracle Database. Create and manage storage structures. Administer the Oracle Database. Understand the Oracle database architecture and how its components work and interact with one another. Perform backup and recovery.

This Oracle Database 11g: New Features for Administrators DBA Release 2 training explores new change management features and other key enhancements in Oracle Database 11g Release 1 and Release 2. Participating in hands-on practice sessions help reinforce your understanding of the new capabilities. Learn To: Implement manageability features to simplify database management. Use change management features to master database changes. Use database advisors to provide proactive database monitoring. Increase data availability by using ASM, RMAN and Flashback feature enhancements.

In this course, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations.   The student begins by gaining a deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication. Extensive hands-on practices and workshop scenarios provide the student with experience in a realistic technical environment. This course includes an interactive workshop that provide participants with opportunities to diagnose and recover from several failure scenarios, based on backup and recovery case studies. After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. Versions Supported: 19c, 18c, 12c Learn To: Develop appropriate backup and recovery procedures to address your business needs. Implement backup and recovery settings and perform backup operations to disk and tape. Employ Oracle Database recovery procedures to recover from media and other failures. Diagnose and repair data failures. Use flashback technologies and data duplication to complement backup and recovery procedures. Secure the availability of your database by appropriate backup and recovery strategies.

This Oracle Database: Deploy, Patch and Upgrade Workshop gives you detailed information to help you install Oracle Database software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases. In this course, you will be introduced to Oracle Database Cloud Service. Learn To: Install Oracle Grid Infrastructure for a Standalone Server. Use Oracle Restart to manage components. Upgrade an existing Oracle Database. Create a container database and provision pluggable databases. Gain an understanding of the Oracle Database Cloud Service. Benefits to You Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds. Gain Hands-On Experience Get practical experience installing the Oracle Grid Infrastructure software and Oracle Database software by using Oracle Universal Installer. Expert Oracle instructors will teach you how to stop and start Oracle Restart using SRVCTL to manage components.