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

Oracle Training

Course has been tailored to our needs. We are learning what we need for everyday work.
Comment from Giant Tiger

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

Jul 18 to Jul 21, 2017$2,775.00/person
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