Course Code: sqlmgmtdeout
Duration: 14 hours
Prerequisites:
  • An understanding of ___.
  • Experience with ___.
  • ___ programming experience.

Audience

  • ___
  • ___
  • ___
Overview:

NOTE:

  • There will be hands on exercises for every module that will be completed to test the understanding of the proponents on the topics.
  • Power Point Slides will be given after the end of the Training
  • SQL Queries from the lesson will be given after the end of the Training
Course Outline:
  • Module 1: Introduction
    • SQL Definition
    • SQL Capabilities
    • Standards of SQL
    • SQL uses
  • Module 2: SQL Query Commands
    • Table Create [ Data Type, Table Format, Key Format]
    • Insert Data [ Single record to multiple records]
    • Insert Into [ Single record to multiple records]
    • Select Statement
    • Select Statements with Conditions
    • Select Statements with Sub Query
    • Update Statement [ Single record to multiple records]
    • Delete Statement [ Single record to multiple records]
  • Module 3: Manipulating tables
    • Modifying Tables [Adding and removing column]
    • Deleting Tables
  • Module 4 - Querying with Unions
    • Rule and application of Union
    • Rule and application of Union all
  • Module 5 – Calculate and compute
    • Using special query such as:
      • SUM
      • AVE
      • MIN
      • MAX
      • Other computation procedures to extract data
  • Module 6 – Entity Relationship diagram
    • Table Relationship
    • Create tables with relationship
    • Updating table to create relationship
  • Module 7 - Table Joins with 2 or more tables
    • Full Join Tables
    • Inner Join Tables
    • Left Join Tables
    • Right Join Tables
  • Module 8 - SQL Transactions
    • What is an SQL Transaction?
    • Uses of SQL Transaction
    • SQL Transaction ACID property
  • Module 9 - Manipulating Index 
    • What is an index?
    • Clustered index
    • Non clustered index
    • Unique index
    • Adding and removing index