Advanced SQL Database Management - Oracle 11g/12c
SQL (Structured Query Language) is a popular programming language used for relational databases.
Talk to us

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 Application Server
• 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

• The Oracle Enterprise Management Framework
• 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

• Identifying Segments, Extents and Data Blocks
• Managing Datafiles
• Creating Tables, Working with Constraints
• Working with Indexes, Views, Sequences

ORACLE NET SERVICES

• Network Design Considerations
• 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

• Dedicated Server versus 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

• Creating and Managing User Accounts
• 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

• Manipulating Data through SQL
• 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

• Undo Management
• Monitoring, Configuring, and Administering
• Maximizing Data Concurrency

PROACTIVE DATABASE MAINTENANCE

• Performance Monitoring
• Automatic Workload Repository
• Automatic Database Diagnostic Monitoring
• Storing Database Statistics in the Data Dictionary

IMPLEMENTING DATABASE BACKUPS

• Understanding and Configuring Recovery Components
• Control Files
• Understanding Checkpoints
• Redo Log Files
• Archived Redo Log Files
• The Flash Recovery Areas
• Performing Backups

IMPLEMENTING DATABASE RECOVERY

• Understanding Database Failure Types
• 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)

BENEFITS OF THIS COURSE

There are many benefits in becoming Oracle Certified.

RELATED COURSES - ARTICLES

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

Read More »

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.

SEND US A MESSAGE