This SSCD bundle is designed to help students’ gain good understanding of Oracle Database 11g Release 1 and provide material to prepare for Oracle Certified Associate and Oracle Certified Professional exams.
The SQL SSCD course teaches 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, 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, such as syntax, blocks, and programming constructs. It demonstrates how to identify the programming extensions that PL/SQL provides to SQL and 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, such as procedures, functions, packages, and database triggers.
Administration Workshop I SSCD course covers the fundamental and also some of the advanced topics in database administration. This course is designed to teach you about the Oracle Database 11g architecture and learn how to manage the Oracle instance, configure the Oracle network environment, manage database storage structures, learn how to manage user security, schema objects, data and concurrency, etc.
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.
RAC Administration SSCD Course offers students an introduction to the general features and capabilities of 11g R1 for Oracle Real Application Clusters (RAC). Students learn how to install and administer Oracle Clusterware, Real Application Clusters, and Automatic Storage Management. Students also learn how to administer their Database in a Real Application Clusters environment using Enterprise Manager Grid Control. Oracle Secure Backup - SSCD Course teaches students 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. Oracle Database 11g: Security SSCD shows students how they can use Oracle Database 11g features to meet the security, privacy and compliance requirements of their organization. SQL Tuning Workshop SSCD Course covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. Students learn the different ways in which data can be accessed, which ones are most efficient under specific circumstances, and how to ensure that the best method is used. In Performance Tuning - SSCD Course, students learn how to use Oracle Database 11g automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods.
|
