Oracle Database 11g: Ultimate - Self-Study Course

This SSCD bundle is designed to help you develop a solid understanding of Oracle Database 11g Release 1. It provides material to prepare for the Oracle Certified Associate and Oracle Certified Professional exams.

The SQL SSCD course teaches you how to use the powerful Structured Query Language (SQL). You'll learn how to retrieve, manage and manipulate the data contained within relational databases. You'll also explore the fundamentals of SQL, advanced SQL features, querying techniques and reporting using Oracle Database 11g database technology.

The PL/SQL SSCD course is designed to teach you the basics of PL/SQL, like syntax, blocks and programming constructs. It demonstrates how to identify the programming extensions that PL/SQL provides to SQL. You'll also learn how to write PL/SQL code to interface with the database.

Develop PL/SQL Program Units SSCD course is designed to teach you how to create modularized applications using PL/SQL. It demonstrates how to develop, execute and manage PL/SQL stored program units, like procedures, functions, packages and database triggers.

Administration Workshop I SSCD course covers the fundamental and advanced topics in database administration. This course is designed to teach you about the Oracle Database 11g architecture. You'll learn how to manage the Oracle instance, configure the Oracle network environment, manage database storage structures and user security, schema objects, data, concurrency and more.

The Administration Workshop II SSCD course is designed to teach you about the concepts and architecture that support backup and recovery of Oracle Database 11g. It explores the structural elements and demonstrates how to manage storage using disk groups. You will also learn how to configure all aspects of the backup and recovery functionality. Finally, you'll learn how to prepare a database for backup, perform various types of backup and monitor backup performance.

The RAC Administration SSCD course introduces you to the general features and capabilities of 11g R1 for Oracle Real Application Clusters (RAC). You'll learn how to install and administer Oracle Clusterware, Real Application Clusters and Automatic Storage Management. You'll also learn how to administer your database in a Real Application Clusters environment using Enterprise Manager Grid Control.

Oracle Secure Backup - SSCD course teaches you how to use Oracle Secure Backup, which supplies reliable tape backup of the database through direct integration with RMAN. It also provides general file system backup to tape.

Oracle Database 11g: Security SSCD shows you how to use Oracle Database 11g features to meet the security, privacy and compliance requirements of your organization.

SQL Tuning Workshop SSCD course covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. You'll learn the different ways in which data can be accessed, which data is most efficient under specific circumstances and how to ensure that the best method is used.

In Performance Tuning - SSCD course,, you'll learn how to use Oracle Database 11g automatic tuning features. These features include SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor. You'll also practice these tuning methods.

Audience

• Database Administrators
• Data Warehouse Administrator
• Support Engineer
• Security Compliance Professionals
• Security Administrators
• Security Compliance Auditors

Course Topics Topics from Oracle Database 11g: SQL Fundamentals I - Self-Study CD Course Topics from Oracle Database 11g: SQL Fundamentals II Self-Study CD Course Topics from Oracle Database 11g: PL/SQL Fundamentals - Self-Study CD Course Topics from Oracle Database 11g: Develop PL/SQL Program Units Self-Study CD Course Topics from Oracle Database 11g: Administration Workshop I - Self-Study CD Course Topics from Oracle Database 11g: Administration Workshop II - Self-Study CD Course Topics from Oracle Database 11g: SQL and PL/SQL New Features Topics from Oracle Database 11g: New Features for Administrators Topics from Oracle Database 11g: Oracle Secure Backup - Self-Study CD Course Topics from Oracle Database 11g: Performance Tuning - Self-Study CD Course Topics from Oracle Database 11g: RAC Administration - Self-Study CD Course Oracle Database 11g: SQL Tuning Workshop - Self-Study CD Course Oracle Database 11g: Security Self-Study CD Course
Course Objectives

• SQL and PL/SQL Fundamentals
• Database Administration
• SQL and Performance Tuning
• Secure Backup
• RAC Administration
• Security