SQL Training

The objective of this course is to provide a comprehensive understanding of the structured query language (SQL) for Microsoft SQL Server users.
The course will provide delegates with the ability to use the Data Manipulation Statements (SQL) to query on, and change the contents of a relational database, using Microsoft SQL Server utilities.

Introduction:-
  • Review of Relational Database Structure
  • Introduction to Microsoft SQL Server and Utilities
  • Introduction To Case Study Database
  • The INSERT, UPDATE and DELETE Statements

    • Thec:-
  • The FROM Clause
  • The WHERE Clause
  • The ORDER BY CLAUSE
  • Arithmetic and String Expressions
  • Column Aliases
  • Aggregate Functions
  • Date and Time Functions
  • Miscellaneous Functions

    • Multiple Table Select Statements:-
  • Simple Joins
  • Table Aliases

    • Advanced Select Statements:-
  • The GROUP BY Clause
  • The HAVING Clause
  • The UNION Operator
  • Simple Sub-queries

    • Advanced Multiple Table Select Statements:-
  • Outer Joins
  • Self Joins

    • Advanced Select Statements:-
  • Sub-queries
  • Correlated Sub-queries

    • Advanced Update & Delete Statements:-
  • Sub-queries
  • Correlated Sub-queries
    • s