Oracle DBAs manage the industry's most advanced information systems and command some of the highest salaries. This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration, SQL and PL/SQL database reporting and programming. In this class, you'll learn how to install and maintain an Oracle instance, access data, and write procedures, functions, and database triggers to access information and automate functions within the database.
Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. This self-study CD (SSCD) course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Students will also practice various methods of recovering the database, using RMAN, SQL, and Flashback technology, use RMAN and explain the various RMAN commands. Diagnostic sources, non-critical recovery, and incomplete recovery concepts are also covered in this course. Learners will also learn how to perform incomplete recovery. In addition, this course covers various functions of the Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption. Finally, learners will learn how to use various database technologies, such as Resource Manager, the Scheduler, and materialized views. 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. |
