Introduction to SQL trains you on the basic concepts of relational databases â€“ how to write sub queries, combine multiple queries into a single query using SET operators, report aggregated data using group functions, and control privileges at the object and system level. You will learn to create indexes and constraints, and alter existing schema objects. This course is a combination of Oracle Database: SQL Fundamentals I and Oracle Database: SQL Fundamentals II courses.
Administration Workshop I is designed to provide you a firm foundation in basic administration of Oracle Database 11g, specifically installing and maintaining an operational database. You learn how to properly manage the various structures effectively and efficiently including performance monitoring, database security, user management, and backup/recovery techniques.
Administration Workshop II takes the database administrator beyond the basic tasks covered in Workshop I. You will gain a much deeper understanding of possibly the most important job of a DBA â€“ backup and recovery. You will learn how to define and test your own backup and recovery scenarios, how to manage memory effectively, and how to perform performance evaluation and tuning tasks.
RAC and Grid Infrastructure Administration Accelerated It is an intensive course that focuses on Oracle Grid Infrastructure products, including: Oracle Automatic Storage Manager (ASM), ASM Cluster File System (ACFS), and Oracle Clusterware. You will learn to administer ASM, ACFS, the Oracle Clusterware and storage products using both command line utilities and graphical tools. Plus, youâ€™ll learn about RAC database administration in the Oracle Grid Infrastructure environment, and how to administer cluster databases using Enterprise Manager and command-line utilities. This is an accelerated course, covering seven daysâ€™ of content in only five days.