SETC Training844-434-7382
 Find a Course: 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

Oracle Training

I very much enjoyed the quality and expertise of the instructor.
Comment from HRSDC

1. Title

  • The Complete Database Administrator Course Part 1 : Mastering the SQL Language (DBCOMP1, 4 days)
    View PDF

2. Course Pre-requisites

  • Previous Experience in/ Exposure to a Database Server Administrator Role

3. Target Audience

  • IT Professionals who want to learn how to effectively administer a multi-platform production database environment.

4. Dates and Pricing

Oct 10 to Oct 13, 2017$2,775.00/person

5. Outline

Module 1: Relational Database Concepts

Topic 1: Exploring the Structure of a Relational Database

Topic 2: About Data and Metadata

Topic 3: The Principle of Integrity: Entity, Domain and Referential

Topic 4: Understanding Primary and Foreign Keys

Topic 5: About Keys and Indexes

Topic 6: SQL Architecture: How MySQL Interprets SQL Commands

Topic 7: SQL Architecture: How Oracle Interprets SQL Commands

Topic 8: SQL Architecture : How SQL Server Interprets SQL Commands

Topic 9: SQL Architecture : How PostgreSQL Interprets SQL Commands

Topic 10: The ANSI Standard and its Implementation in MySQL, Oracle, SQL Server and PostgSQL

Module 2: Creating Tables

Topic 1: The Need for Primary and Foreign Keys

Topic 2: Creating Tables for MySQL and Oracle

Topic 3: Adding Constraints to a Table

Topic 4: Inserting Data - Fundamentals

Topic 5: Retrieving Data - Fundamentals

Topic 6: Deleting Data - Fundamentals

Topic 7: Understanding Space Allocation

Module 3: Retrieving Data

Topic 1: Retrieving Data from a Table

Topic 2: Sorting Data

Topic 3: Filtering Data : Using Simple Clauses

Topic 4: Filtering Data : Using Date and Time

Topic 5: Filtering Data : Working with Strings

Topic 6: Filtering Data : Using Logical Operators

Topic 7: The INSERT Statement

Topic 8: The UPDATE Statement

Topic 9: The DELETE Statement

Module 4: Retrieving Metadata

Topic 1: The Importance of Metadata

Topic 2: Retrieving Metadata in MySQL

Topic 3: Retrieving Metadata in Oracle

Topic 4: Retrieving Metadata in SQL Server

Topic 5: Retrieving Metadata in PostgreSQL

Module 5: Advanced Data Operations

Topic 1: Working with Aggregate Values

Topic 2: Retrieving from Multiple Tables - Inner Join

Topic 3: Retrieving from Multiple Tables - Outer Joins

Topic 4: About Sub-Queries

Topic 5: Correlated Sub-Queries

Module 6: Indexing

Topic 1: Index Overview

Topic 2: SQL Server Index Architecture

Topic 3: Oracle Index Architecture

Topic 4: MySQL Index Architecture

Topic 5: PostgreSQL Index Architecture

Topic 6: About Indexes and Keys

Topic 7: Understanding Ordered and UnOrdered Indexes

Module 7: Stored Procedures

Topic 1: Architectural Overview

Topic 2: Benefits of Stored Procedures

Topic 3: Creating Stored Procedures

Topic 4: Using Input and Output Parameters

Topic 5: Stored Procedures Optimization

Module 8: Stored Procedures - Built-In Specifics

Topic 1: Using Oracle Built-in Stored Procedures for Administration Tasks

Topic 2: Using MySQL Server Built-in Stored Procedures for Administration Tasks

Topic 3: A Practical Administration Lab

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette