Oracle Database 11g: PL/SQL Oracle Certified Associate Track - Self-Study Course

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 using Oracle Database 11g database technology. This course is also designed to teach you about advanced SQL features, querying techniques, and reporting.

The PL/SQL SSCD course teaches you about the Procedural Language extension to SQL (PL/SQL), which is Oracle Corporation's standard data access language for relational databases. PL/SQL is used to seamlessly integrate procedural constructs with SQL. This 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.

The Oracle Database 11g: Develop PL/SQL Program Units SSCD course deals with topics that will interest Developers. This 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.

The topics covered in these SSCDs will help the students’ gain good understanding of these new capabilities in Oracle Database 11g SQL and PL/SQL.

This SSCD course is designed to provide material for you to prepare for Oracle Certified Associate exams. For detailed discussion and in-depth coverage of Database and SQL tuning topics please refer the courses listed under the Next Courses section.