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 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.
|
