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

(042) 35831312

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

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

Oracle Certified Database Administrator (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).

Feb
10

Free Seminar At 06:00 PM
Lahore Branch

  Classes start from Feb 12, 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