This course offers an introduction to Oracle Database 12c technology. You will learn the concepts of relational databases and powerful SQL (structured query language) programming. Discover essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Requires familiarity with data processing concepts and techniques.

Designed to provide a firm foundation in administration of an Oracle Database. Gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. Covers both Database as a Cloud Service and the on-premises Oracle Database. Learn how to create database storage structures appropriate for the business applications supported by a database. Learn how to create users and administer database security to meet business requirements. Basic information on backup and recovery techniques is presented in this course. Prerequisite: Oracle Database 12c: SQL Workshop I or equivalent experience.

Covers the fundamentals of SQL using Oracle Database 11g database technology. Explains concepts of relational databases and the powerful SQL programming language. Provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Teaches single row functions to customize output, conversion functions and conditional expressions and group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts. Utilizes Oracle SQL Developer as the main tool and SQL *Plus is introduced as an optional tool. Requires familiarity with data processing concepts and techniques.

Demonstrates the installation and maintenance of Oracle Database 11g. Provides a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Teaches how to create an operational database and properly manage the various structures in an effective and efficient manner. Includes performance monitoring, database security, user management and backup/recovery techniques. Reinforces topics with structured hands-on practices. Prerequisite: LOR 8601 or consent of instructor or program coordinator.

Explores concepts and architecture that support backup and recovery, along with varied situational implementation. Includes how to define and test your own backup and recovery scenarios. Teaches effective memory management, performance evaluation and tuning tasks, and the use of advisors. Includes flashback technologies, scheduling jobs inside and outside of the database, controlling system resource usage, and hands-on practices. Prerequisite: LOR 8602 or consent of instructor or program coordinator.

Teaches new change management features and other key enhancements in Oracle Database 11g. Emphasizes the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security and several other areas that concern database administrators. Prepares for the Oracle 11g DBA certification upgrade exam. Requires strong Oracle Database 10g concepts, consent of instructor of program coordinator.