Oracle Database 11g: DBA Oracle Certified Professional Track - Self-Study Course

The SQL SSCD courses teach you how to use the powerful Structured Query Language (SQL). Students learn how to retrieved, managed, and manipulated the data contained within relational databases. This course is designed to teach you the fundamentals of SQL using Oracle Database 11g database technology. This course is also designed to teach you about advanced SQL features, querying techniques, and reporting.

The Oracle Database 11g: Administration Workshop I SSCD course covers the fundamental and also some of the advanced topics in database administration. Oracle Database 11g allows users to innovate faster, manage more data with advanced table partitioning and compression, protect data, and integrate 3D spatial and rich media content into business processes. This course is designed to teach you about the Oracle Database 11g architecture. It demonstrates how to prepare the database environment and create an Oracle database. In this course you will learn how to manage the Oracle instance, configure the Oracle network environment, and manage database storage structures. You will also learn how to manage user security, schema objects, data and concurrency, and undo data. Implementing Oracle database security, database maintenance, performance management, backup and recovery, moving data, and enhancing database capabilities also covered.

The Oracle Database 11g: 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 backup and recovery functionality, as well as how to prepare a database for backup, perform various types of backup, and monitor backup performance. This course also demonstrates using RMAN to maintain data integrity, using Automatic Diagnostic Recovery, Support Workbench, and health checks to diagnose and repair database problems, and optimizing a database. The Database Resource Manager, Scheduler, and globalization support are also covered.

The topics covered in these SSCDs will help the students’ gain good understanding of these new capabilities in Oracle Database 11g Release 1.

This SSCD course is designed to provide material for you to prepare for Oracle Certified Associate and Oracle Certified Professional exams.

For detailed discussion and in-depth coverage of Database and SQL tuning topics please refer the courses listed under the Next Courses section.

Audience

• Database Administrators
• Database Designers
• Support Engineer
• Developer
• Technical Administrator

Course Topics Oracle Database 11g: SQL Fundamentals I - Self-Study CD Course Oracle Database 11g: SQL Fundamentals II Self-Study CD Course Oracle Database 11g: Administration Workshop I - Self-Study CD Course Oracle Database 11g: Administration Workshop II - Self-Study CD Course
Course Objectives

• Database Administration
• SQL Fundamentals