Advanced SQL Database Management - Oracle 11g/12c

SQL (Structured Query Language) is a popular programming language used for relational databases.

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.

Demand for Oracle Certifications is increasing at an incredible pace. Professionals are required to know the skills that make them attractive to hiring managers. These hiring managers often look for various ways to differentiate employees and prospective employees with solid skills needed for a job role for better performance.

The Oracle programs assist IT industry to make distinctions by developing a standard of competence in key entry levels. Oracle certified Professionals increases visibility in their organization which is the basis of career advancement in any organization, owing to the recognition of their skills.

Oracle qualifications, without doubt, offers an added advantage, especially when several candidates are competing for a single position. It shows the potential employer that you, as a candidate, are committed to learn and upgrade your skills in your trade and claims to make you productive as soon as you hit the floor.

RELATED COURSES - ARTICLES

Ethics for IT Professionals

Embarking on a cybersecurity career requires structured learning and certifications. At INFOCLUB Training Centre, we have a plan to make you become a top-level professional in Cybersecurity. Read below a detailed 18-24 month roadmap, highlighting certifications, skills acquired, exam structures, and potential job roles at each stage.

February 21, 2025

Building a Career in Cybersecurity

January 9, 2025

Why IT Kids?

Unleash Your Child’s Digital Potential This Summer with Fun, Hands-On IT Courses! As the summer holidays roll around, it’s time to think beyond the textbooks

October 25, 2024

THE BELBIN MODEL

The Belbin Model, also known as Belbin Team Roles, is a framework for understanding the roles individuals naturally adopt in a team setting. Developed in

July 19, 2024

Writing a Critical Appraisal

INTRODUCTION How do you write a critical appraisal? Many people find difficulties doing this at the end of their project or dissertation. A critical appraisal

July 18, 2024

PRIVACY IN THE MODERN WORLD

What is Privacy? It is the right of an individual to keep their personal information and activities from being disclosed to others without their consent. In our article, we shall review the following: What are the top risks to privacy today, What are the technical solutions to protect privacy, The legal aspect and what is GDPR, How privacy varies across cultures, How new technologies could challenge privacy in the future

July 5, 2024

INTERESTED IN THIS COURSE?

SEND US A MESSAGE