Oracle Database: Administrator

Course details

This course introduces participants to the fundamentals of SQL using Oracle Database technology. The participants learn the concepts of relational databases and the powerful SQL programming language. In addition, this course teaches the participants to use single row functions to customize output, use conversion functions and conditional expressions. Also, the usage of group functions to report aggregated data is dealt with in this course.

Learning Outcomes

1. Display data from multiple tables using the ANSI SQL 99 JOIN syntax.
2. Employ SQL functions to generate customized data.
3. Create reports of aggregated data.
4. Use the SET operators to create subsets of data.
5. Run data manipulation statements (DML) in Oracle Database 11g.
6. Run data definition language (DDL) statements to create schema objects.
7. Identify the major structural components of Oracle Database 11g.
8. Retrieve data from tables. 9. Create reports of sorted and restricted data.

Administration 1:

The Administration 1 course is designed to give the participants a firm foundation in basic database administration. Lesson topics are reinforced with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam. 

Learning Outcomes

1. Install Oracle Grid Infrastructure.
2. Install and configure Oracle Database 11g.
3. Configure Oracle Net services.
4. Monitor and administer undo data.
5. Manage the database storage structures.
6. Create and administer user accounts.
7. Perform basic backup and recovery of a database.
8. Manage data concurrency.
9. Monitor performance.
10. Describe Oracle Database Architecture.

Administration 2:

The Database Administrator is taken beyond the basic tasks covered in Administration 1 here in this course (Administration 2). In this course a deep understanding is gained of the most important responsibilities a BDA has: performing backup and recovery.

Learning Objectives

1. Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager).
2. Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state.
3. Use an appropriate and flexible memory configuration for your database.
4. Identify burdensome database sessions and poorly performing SQL.
5. Configure the Oracle Database for optimal recovery.
6. Configure the database instance such that resources are appropriately allocated among sessions and tasks.
7. Schedule jobs to run inside or outside of the database.
8. Use compression to optimize database storage and duplicate a database. 

Exams:

Orcale Certified Associate Exam

Certificate:

Awarded to learners who get minimum 70 marks out of 100