
COURSE OVERVIEW
This course is aimed at individuals who wish to become database administrators for Oracle 11g or 12c.
This syllabus is oriented towards the ORACLE CERTIFIED ADMINISTRATOR (OCA) and ORACLE CERTIFIED PROFESSIONAL (OCP) Examination.

ADVANCED SQL COURSE MODULES
ORACLE COMPONENTS AND ARCHITECTURE
• Oracle Developer Suite, Oracle Applications 11i
• Oracle Collaboration Suite, Oracle Services
• Relational Database Concepts
• The Oracle Architecture, The Oracle Instance
• The Oracle Database
• Installing Oracle
CREATING AND CONTROLLING A DATABASE
• Accessing a Database Using the Database Control
• Using ISQL*Plus
• Using the Oracle Database Configuration Assistant
• Starting Up and Shutting Down an Oracle Database
• Monitoring the Database Alert Log
DATABASE STORAGE AND SCHEMA OBJECTS
• Managing Datafiles
• Creating Tables, Working with Constraints
• Working with Indexes, Views, Sequences
ORACLE NET SERVICES
• Interfacing Existing System with New Systems
• Network Responsibilities for the DBA
• Single-Tier Architecture, Two-Tier Architecture
• Configuring Oracle Net on the Server
• The Oracle Listener
• Troubleshooting Server-Side Connection Problems
ORACLE SHARED SERVER
• Oracle Shared Server Infrastructure
• Managing Shared Server
• Using Dynamic Performance Views for Shared Server
• Tuning the Shared Server Option
• Sizing the Large Pool
USER ADMINISTRATION AND SECURITY
• Assigning a Default Tablespace
• Assigning a Profile to a User
• Granting and Revoking Privileges
• Role Privileges
• Assigning Tablespace Quotas
• Managing Default User Accounts
• Auditing Database Activity
MANAGING DATA WITH SQL, PL/SQL, AND UTILITIES
• Using INSERT, UPDATE, DELETE
• Programming with PL/SQL
• Identifying PL/SQL Objects
• Configuring PL/SQL for Better Performance
• Loading Data with SQL*Loader
MANAGING CONSISTENCY AND CONCURRENCY
• Monitoring, Configuring, and Administering
• Maximizing Data Concurrency
PROACTIVE DATABASE MAINTENANCE
• Automatic Workload Repository
• Automatic Database Diagnostic Monitoring
• Storing Database Statistics in the Data Dictionary
IMPLEMENTING DATABASE BACKUPS
• Control Files
• Understanding Checkpoints
• Redo Log Files
• Archived Redo Log Files
• The Flash Recovery Areas
• Performing Backups
IMPLEMENTING DATABASE RECOVERY
• Performing Recovery Operations
• Tuning Instance Recovery

COURSE ORGANISATION & TIMING
We have created a schedule for this course to match with most availabilities.
The course is modular. Courses are hands-on(25% theory, 75% practice)
- Monday - Friday (Between 10am - 5pm)
- Course Materials and Online Content Provided
- Duration is indicative and may include off-campus assignments and exams questions
- Flexible Timetable
- Special Packages + Payment Facilities
BENEFITS OF THIS COURSE
There are many benefits in becoming Oracle Certified.

RELATED COURSES - ARTICLES

SportsTech – New Technologies at FIFA 2022
A smart home is a residence that uses internet-connected devices to enable the remote monitoring and management of appliances and systems, such as lighting and heating.

IOT Application – Smart Home
A smart home is a residence that uses internet-connected devices to enable the remote monitoring and management of appliances and systems, such as lighting and heating.

Vacation Courses
Sharpen Your IT Skills and make your holidays more productive Summer Vacation Courses Table of Contents LEVEL 1 LEVEL 2 Course Organisation Level 1 This set of topics is best
INTERESTED IN THIS COURSE?
Infoclub Ltd has proudly served IT Professionals seeking to enhace their skillsets with the latest certification in IT with precision and excellence for over 30 years.
You can contact us through the following:
Email: Infoclubltd@yahoo.com
Phone: +230 2411533
Or fill in the form on the right.