ORACLE CERTIFIED DATABASE ADMINISTRATOR (OCP: ORACLE 12C DBA) IN LAHORE

Free Seminar on Feb 10, 2020 at 06:00 PM
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).