Oracle Database Administrator Course (OCP: Oracle 12c DBA) - EVS Institute

(042) 35831312

Everyday (9AM to 10PM)
Post Inquiry
We'll get back to you

Oracle Database Administrator Course (OCP: Oracle 12c DBA)

Oracle Database Administrator Course (OCP: Oracle 12c DBA)

It is one of the best Oracle Database Development / Oracle Database Administration courses in Lahore, Rawalpindi & Islamabad. It covers database development and administration using Oracle 12c. It includes understanding database concept; creating databases using Oracle 12c ; querying and manipulating data using PL / SQL and taking advantage of Oracle’s Multitenant-Architecture for cloud computing. The course not only teaches the skills required to Oracle DBA for performing his routine operations but also teaches him the skills required to become a top-performing Oracle DBA. It includes deployment of backup and recovery and its cloud computing strategies.
Brief Contents

What is Database, Type of Databases, Data Types

Difference between Liner & Non Liner Databases

What is No SQL Database, What is ATL32-U Database, Object Oriented Database

How to Setup Virtual Machine, How to Install Database on Windows Environment

How to Install Database on Linux Environment, How to Test Database after installation

Trouble Shooting of Database During Installation

Introduction of Data Structure, Introduction of Table Structure

Select Statement, Database Keys, Distinct Statement, Joining of Tables

Null Values, NVL Values, Table Alias

Identification of Data, Identification of Primary & Foreign Key

Arithmetic Expressions, Add Running Total, Add Union Intersections

Null If Function, Data Sorting, To Date & Automatic Date Calculations Formulas

Introduction of Sub Query, Return Single Row from Sub Query,

Return Multiple Row from Sub Query, Where Claus in Sub Query ,

Inner Joins, Outer Joins,

Conversion of Data, Conversion of Data Num To Char, Conversion of Dates

What is Aggregation Rule, What is Group by & Having Functions

Applying Aggregation Rules, Applying Group by Functions, Apply Having Function

Use Multiple Tables in Group By Function, Conversion of Data,

Conversion of Data Num To Char, Sorting of Data, Order By of Data

Introduction of Tables, Creation of Tables, Update Table Columns, Drop Table Columns

How to Define Primary Key, How to Define Foreign Key

What is Star Schema, How to Build Star Schema, How to Drop Table,

Update of Data in Tables, Insert of Data in Tables, Introduction of Sequences

How to Build Auto Incremental Columns, How to Build Sequence in Table Columns

What is Loop Functionality, How to Insert Data in Tables through Loop Functionality

How to Update Data in Tables Through Loop, How to Delete Data from Tables

How to Clone Tables, How to Fetch Query from Multiple Databases Tables

How to Display all Tables in User, How to Check Table Space,

How Count Rows of Tables, Rownum Function in Tables, Introduction of Functions

Type of Functions, How to Build Function in Database, How to Run Function in Database

How to use Data Types in Functions, Method to Create Function, Method to Alter Functions

Purpose of Functions, Method to Call Function in Database Query

How to Optimize Query Through Functions

Introduction of Data Views, De-Normalize Table Data in Views, Hierarchy of Views

Method to Create Data Views, Method to Alter Data Views,

What is Procedure, Why we use Procedures, How to Build Procedure

Insert, Update & Delete Data Through Procedure

Alteration of Procedure, Drop Procedures

What is Package, How to Build Package, Purpose to Build Package

How to Send E-Mail Through Database Package

List of Major Architecture Components of Database, Explain the Memory Structures

Describe the Background Process, Correlate the Logical and Physical Storage Structures

What are Database Management Tools, How to Use Database Management Tools

How to Install Database Management Tools, Start & Shut Down Database Services

Difference Between Immediate Start/Shutdown & Immediate Start/Shutdown Services

View Database Logs, What is Network Environment,

How to Configure Network Environment

What is TNS Listener, How to Configure TNS Listener,

Trouble Shooting of TNS Listener Services

How to Configure Network Side Configurations

What is Table Space, What is Table Partition, How to Manage Table Spaces

What is Undo Data, How to Apply Patches on Database,

Difference Between Undo & Redo Data, Space Management of Databases

Managing Database Roles, Changing Database Privilege

Database Compressions, Describing the Locking Mode, Unlocking of Data

Release of Expired Users, Database Backup Description, How to Backup Database

How to Restore Database Through Dumps, Backup Database without shutting it down

Generate Database Alerts, Small Briefing of Database Auditing

What is Database Patch, How to Download & Apply Database Patches

What is Database Scheduler, Create Schedule of Database Jobs,

Use Task Manager for Database Scheduler, Cloning of Database, Duplication of Database

Move Database From One Server to Another Server

Introduction of RMAN, How to Use RMAN from SQL Plus,

How to Connect Database with RMAN, Use SQL in RMAN

What is Recovery Catalog, How to Configure Recovery Catalog in RMAN

How to Generate Scripts for Recovery Catalog in RMAN, Export & Import Recovery Catalog

What is Data backup Through RMAN,

Create Backup Plan Strategy using RMAN Database Backup

Configuring Fast Recovery Data, How to Use Incremental Backup

Manage Backups, Backup Database on No Archive & Archive Mode

How to Backup Non-Database Files, Secure Backup

Cloning of Database Using RMAN, Duplication Database using RMAN,

CDB & PDB Database Management, What is Flash Recovery of Database

Use Flashback Query, Use Flashback Table Operations,

Recover Table Data From Flashback Recovery,

Recover Columns Data from Flashback Recovery

Restore Table from Recycle Bin, Manage Pluggable & Container Database

Manage Security of Database Through RMAN

Database Audit Concepts, Database Security Auditing

Generate Database Documentation From Database Tools

Auditing of User Privileges, Checking of Login Audits, Checking of Unused Spaces

Audit of Unused Memory , Query Optimization & runtime

Training Methodology

Lectures & Demos by industry experts

Project Driven Hands-On approach

Focus on latest tools, technologies & industry practices

Projects, assignments & quizzes for participant’s evaluation

Audience

Programmers, Software Developer, Web Developers

Software Analysts, Software Designers and Software Architects

Graduates & Students of Computer Science, Software Engineering etc.

Course Project

Participants of the course will develop a commercial level database during the course Oracle Database 12c. They will also demonstrate their proficiency in common DBA tasks by performing them under the supervision of the course trainers.

Certificate

On successful completion of the course participants will be awarded participation certificate from EVS.

Exam-1: Oracle Database SQL: 1Z0-071

Exam-2: Oracle Database 12c Administration: 1Z0-062

Exam-3: Oracle Database 12c: Advanced Administration: 1Z0-063

Duration & Frequency

Total Duration of the course is 3 months (12 Weeks, with 3 classes of 1.5 hours in a week).

Sep
25

Free Seminar At 06:00 PM
Lahore Branch

  Classes start from Sep 28, 2020
  • Monday (Lab) :
    07:30 PM To 09:00 PM
  • Wednesday :
    07:30 PM To 09:00 PM
  • Friday :
    07:30 PM To 09:00 PM

Online registeration will soon be available !!

Post Inquiry