Oracle Database 11g: Complete - Self-Study Course

The SQL SSCD course teaches you how to use the powerful Structured Query Language (SQL). Learn how to retrieve, manage and manipulate the data contained within relational databases.

Learn To:

• Understand the fundamentals of SQL using Oracle Database 11g database technology.
• Understand advanced SQL features, querying techniques, and reporting.
• Use PL/SQL to seamlessly integrate procedural constructs with SQL.
• Use the basics of PL/SQL, like syntax, blocks and programming constructs.
• Identify the programming extensions that PL/SQL provides to SQL.
• Write PL/SQL code to interface with the database.
• Create modularized applications using PL/SQL.
• Develop, execute and manage PL/SQL stored program units, like procedures, functions, packages and database triggers.
• Manage the Oracle instance, configure the Oracle network environment and manage database storage structures.

Advanced Topics in Database Administration

The Oracle Database 11g: Develop PL/SQL Program Units SSCD course deals with topics that will interest developers. It also dives into some of the advanced topics in database administration. You'll learn about the Procedural Language extension to SQL (PL/SQL), which is Oracle Corporation's standard data access language for relational databases.

Oracle Database 11g Architecture

Oracle Database 11g allows users to innovate faster. You can manage more data with advanced table partitioning and compression. It also protects data and integrates 3D spatial and rich media content into business processes. This course is designed to teach you about the Oracle Database 11g architecture.

Prepare the Database Environment

Expert Oracle instructors will teach you how to prepare the database environment and create an Oracle database through demonstrations. You will also learn how to manage user security, schema objects, data and concurrency and undo data.

Backup & Recovery

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.

Monitor Backup Performance

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. You'll also learn to use Automatic Diagnostic Recovery, Support Workbench and health checks to diagnose and repair database problems, as well as optimize a database. The Database Resource Manager, Scheduler and globalization support are also covered.

The topics covered will help you gain a good understanding of these new capabilities in Oracle Database 11g Release 1.

Oracle Certification Exams

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 to the courses listed under the Next Courses section.

Audience

• Database Administrators
• Data Warehouse Administrator
• Support Engineer
• Technical Consultant

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
Course Objectives

• SQL and PL/SQL Fundamentals
• Database Administration