Certificate in Oracle – DBA

Learning Materials: Janaki Ram | Instructor: Days or Evenings – 9:00 am -1:00 pm or 5:30 pm-9:30 pm

Download Brochure

Program Objective

A Practical Training on Oracle DBA.

ORACLE DBA and SQL Course

PART – 1:  SQL & PL/SQL Course

 

Overview
Using the powerful Structured Query Language (SQL), the data contained within relational databases can be retrieved, managed and manipulated.

  • Develop essential SQL skills that enable developers to write queries against single and multiple tables.
  • Manipulate data in tables.
  • Create database objects.
  • Use single row functions to customize output.
  • Work with group functions to report aggregated data.
  • Use conversion functions and conditional expressions.
  • Manipulate queries to return required data.
  • Perform calculations on data.
  • Administer database objects.
  • PL/SQL designing best practices.
  • Create PL/SQL applications that use collections.
  • Write and tune PL/SQL code effectively to maximize performance.

 

Audience
Database Administrators, Database Designers, Developer.

 

Benefits

Extend the functionality of the SQL language with PL/SQL language to write application code. This will help your organization realize the full benefit of utilizing Oracle best practices.

 

Certification

Oracle Database: Introduction to SQL – 1Z0-061

 

Software Requirement

Installation of Oracle Expression Edition 11g

 

Time Required: 56 hours

  • SQL – 20 hours
  • PL/SQL – 20 hours

 

Course Outline

SrNo. Title Time
Chapter 1 Oracle Database 11g: Using SQL to Query Your Database 5 Hours
Chapter 2 Oracle Database 11g: Conversion Functions, Group Functions, and Joins 5 hours
Chapter 3 Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation 5 hours
Chapter 4 Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms 5 Hours

 

PL/SQL

SrNo. Title Time
Chapter 1 Introduction 2 Hours
Chapter 2 PL/SQL Programming Concepts Review 2 Hours
Chapter 3 Designing PL/SQL Code 2 Hours
Chapter 4 Using Collections 2 Hours
Chapter 5 Manipulating Large Objects 2 Hours
Chapter 6 Using Advanced Interface Methods 2 Hours
Chapter 7 Performance and Tuning 2 Hours
Chapter 8 Improving Performance with Caching 2 Hours
Chapter 9 Analyzing PL/SQL Code 2 Hours
Chapter 10 Profiling and Tracing PL/SQL Code 2 Hours

 

PART – 2: Oracle Administration (DBA) Course

 

Overview
You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

  • Install Oracle Grid Infrastructure.
  • Create and manage users.
  • Install and configure an Oracle Database.
  • Create and manage storage structures.
  • Administer the Oracle Database.
  • Understand the Oracle database architecture and how its components work and interact with one another.
  • Perform backup and recovery.
  • Configure the Oracle Database for optimal recovery
  • Configure the database instance such that resources are appropriately allocated among sessions and tasks
  • Schedule jobs to run inside or outside of the database
  • Use compression to optimize database storage and duplicate a database
  • Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
  • Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
  • Use an appropriate and flexible memory configuration for your database
  • Identify burdensome database sessions and poorly performing SQL

Audience

Database Administrators, Database Designers, Developer.

 

Benefits

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

 

Certification

Oracle Database 11g: Administration 1 – 1Z0-052

 

Software Requirement

Installation of Oracle Enterprise Edition 11g

 

Time Required: 48 hours

  • DBA – 48 hours

Course Outline

SrNo. Title Time
Chapter 1 Exploring the Oracle Database Architecture 2 Hours
Chapter 2 Installing your Oracle Software 2 Hours
Chapter 3 Creating an Oracle Database 2 Hours
Chapter 4 Managing the Oracle Database Instance 2 Hours
Chapter 5 Manage the ASM Instance 2 Hours
Chapter 6 Configuring the Oracle Network Environment 2 Hours
Chapter 7 Managing Database Storage Structures 2 Hours
Chapter 8 Administering User Security 2 Hours
Chapter 9 Managing Data Concurrency 2 Hours
Chapter 10 Managing Undo Data 2 Hours
Chapter 11 Implementing Oracle Database Auditing 2 Hours
Chapter 12 Database Maintenance 2 Hours
Chapter 13 Performance Management 2 Hours
Chapter 14 Backup and Recovery Concepts 2 Hours
Chapter 15 Performing Database Backups 2 Hours
Chapter 16 Performing Database Recovery 2 Hours
Chapter 17 Moving Data 2 Hours
Chapter 18 Working with Support 10 Hours
Chapter 19 Examination Preparation 16 Hours

Points/Total Points: 104/100

Sessions: 20-30

Hours per session: 3-8

Duration:  6-12 weeks

Weekly Hours: 10-20

Grading Scale: Class attendance and exercises (75%), exams, questions and answers (25%) Certificate Obtained: 1Z0-052 Oracle Database 11g: Administration I (90 Minute Test, 66% Passing Score)

Cost: Tution Fee $4400

Books, Videos and Software: $150

Examination Fee: $125

TOTAL COST: $4675