Course Introduction

Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

Oracle Certification course Syllabus:

Oracle Database 10g Administrator Certified Associate

 

Oracle Database 10g Administration

 

 

Oracle Database 11g OCA

 

 

  • Overview

 

  • Training Prerequisites

 

  • Describing the Oracle Architecture

 

  • Creating an Oracle Database

 

  • Managing an Oracle Instance

 

  • Database Storage Structures

 

  • Database Security

 

  • Schema Objects

 

  • Data Manipulation Language

 

  • Undo Data

 

  • Database Maintenance

 

  • Database Performance

 

  • Database Backup

Course Outline

  • SELECT Statements

 

  • Restricting and Sorting Data
  • Single-Row Functions
  • Aggregate Functions
  • Joining Tables
  • Using Sub queries
  • Manipulating Data
  • Creating Tables
  • Creating Objects
  • Security
  • Advanced DML Operations
  • Time Zone Changes
  • Advanced Sub queries

Oracle 11g Certified Professional

  • Database Architecture and ASM
  • Purpose of Backup and Recovery Functionality
  • RMAN Repository Data Storage: Comparison of Options
  • Creating an Oracle-Suggested Backup
  • Using RMAN RESTORE and RECOVER Commands
  • Tablespace Point-in-Time Recovery (TSPITR) Concepts
  • Parallelization of Backup Sets
  • Flashback Technology
  • Diagnostic Workflow & Repository
  • Oracle Memory Structures

ORACLE DATABASE 12c ADMINISTRATOR CERTIFIED ASSOCIATE

  • INTRODUCTION TO ORACLE DATABASE 12c:
  • ORACLE DATABASE 12c ARCHITECTURE:
  • ADMINISTER A DATABASE INSTANCE:
  • CONFIGURE THE ORACLE NETWORK ENVIRONMENT:
  • MANAGE USERS:
  • MANAGE PROFILES AND RESOURCES:
  • DATABASE AUDITING:
  • CONCURRENCY AND LOCK CONFLICTS
  • TUNING:
  • DATA:

 

 

 

 

 

Leave A Message

There are no any courses offered by this institute...!