CLS Learn Oracle Database Administrator CLS Learn
Price: AED 1,231

Course details

Diploma tracks :

Oracle Database 11g: Introduction to SQL  40 hrs
Oracle Database 11g: Administration Workshop I 40 hrs
Oracle Database 11g: Administration Workshop II 40 hrs

Oracle Database 11g: Introduction to SQL

Course Topics :
Introducing Oracle Database 11g
Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data From Multiple Tables
Using Sub-queries to Solve Queries
Using the SET Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects
Controlling User Access
Managing Schema Objects
Managing Objects with Data Dictionary Views
Manipulating Large Data Sets
Managing Data in Different Time Zones
Retrieving Data Using Sub-queries
Regular Expression Support

Oracle Database 11g: Administration Workshop I 
Course Topics :
Exploring the Oracle Database Architecture
Installing your Oracle Software
Creating an Oracle Database
Managing the Oracle Database Instance
Manage the ASM Instance
Configuring the Oracle Network Environment
Managing Database Storage Structures
Administering User Security
Managing Data Concurrency
Managing Undo Data
Implementing Oracle Database Auditing
Database Maintenance
Performance Management
Backup and Recovery Concepts
Performing Database Backups
Performing Database Recovery
Moving Data
Working with Support

Oracle Database 11g: Administration Workshop II
Course Topics :
Core Concepts and Tools of the Oracle Database
Configuring for Recoverability
Using the RMAN Recovery Catalog
Configuring Backup Settings
Creating Backups with RMAN
Restore and Recovery Task
Using RMAN to Perform Recovery
Monitoring and Tuning RMAN
Diagnosing the Database
Using Flashback Technology I
Using Flashback Technology II
Performing Flashback Database
Managing Memory
Managing Database Performance
Managing Performance by SQL Tuning
Managing Resources
Automating Tasks with the Scheduler
Managing Space in Blocks
Managing Space in Segments
Managing Space for the Database
Duplicating a Database Updated on 08 April, 2019

Eligibility / Requirements

Tackle performance, availability, security & compliance.

About CLS Learn

CLS help and support the Egyptian market , cooperate, individuals and universities to Learn various technology products and acquire new potentials and advance in their career.
CLS is an Authorized training center of :
• Microsoft Certified Gold Learning Solution GOLD CPLS
• Oracle Training Partner WDP
• EC Council Accredited Training Center
• Cisco Certified learning Partner
• Adobe Authorized Training Center
• Autodesk Authorized Training Center and Certification center
• Exin ITIL Authorized training Provider and certification provider
• Authorized Pearson VUE testing centers
• Authorized Prometric testing centers

CLS is a Microsoft Gold Learning Solutions Learning Solution.
CL is An award winning Training center from EC-Council : Circle of Excellence award.
CLS is an Accredited Learning Solution from Microsoft , Oracle , Cisco , EC-Council , Adobe , Autodesk , Pearson VUE and Prometric.
CLS Founders and Managers Team has over 21 Years of Experiencein the Training industry since 1995.
CLS Team has trained over 1,000,000 trainess and 1500 Company.
CLS instructors are the best certified professional instructors in Egypt with reliable working experience.

See all CLS Learn courses

Enquire about this course

You may add more courses here,
your list will be saved.

Rate this page