Course content

Overview:

SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems and a relational database management Platform. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). Its primary query languages are T-SQL and ANSI SQL.

Training Objectives of SQLServer:

The Main Objective of this course covers all of the SQL Server Database performance tuning topics including global tuning with SQL Server parameters, SQL tuning, file and table space management, user administration and security and table and index management.

Target Students and Prerequisites:

Students must be familiar with the Concepts in Database.

  • Brief History of SQL
  • What is New in SQL Server 2008
  • SQL Server Editions
  • Relational Databases
    • Creating Database
    • Tables
    • Rows
    • Columns
    • Relationships
    • Data types
    • Primary Keys
    • Foreign Keys
    • Relational Database Management System
  • SQL Server Objects
    • Valid Object References
  • SQL Statements
    • Database Manipulation Language (DML)
    • Database Definition Language (DDL)
  •  
  • Introduction to the “Adventure Works DW” Database
  • Some Basics
    • Comments
    • Case Sensitivity
  • SELECTING All Columns in All Rows
  • Union Queries
  • Exploring the Tables
  • Using Group and Having
  • SELECTING Specific Columns
  • Sorting Records
    • Sorting By a Single Column
    • Sorting By Multiple Columns
    • Sorting By Column Position
    • Ascending and Descending Sorts
  • The WHERE Clause and Operator Symbols
    • Checking for Equality
    • Checking for Inequality
    • Checking for Greater or Less Than
    • Checking for NULL
    • WHERE and ORDER BY
  • The WHERE Clause and Operator Words
    • The BETWEEN Operator
    • The IN Operator
    • The LIKE Operator
    • The NOT Operator
  • Checking Multiple Conditions
    • AND
    • OR
    • Order of Evaluation
  • Writing SELECTs with Multiple Conditions
  • Calculated Fields
    • Concatenation
    • Mathematical Calculations
    • Aliases
  • Aggregate Functions and Grouping
    • Aggregate Functions
    • Grouping Data
    • Where Clause
    • Order By Clause
    • Using Group by and Having
  • Built-in Data Manipulation Functions
    • Common Math Functions
    • Common String Functions
    • Common Date Functions
  • Sub queries
  • Joins
    • Table Aliases
    • Multi-table Joins
  • Outer Joins
  • Unions
    • UNION ALL
    • UNION Rules
  • Creating Tables
  • Data types
  • Altering Tables
    • Adding a Column
    • Dropping a Column
  • Renaming Tables
  • Dropping Tables
  • Creating Views
  • Dropping Views
  • Creating Stored Procedures
    • Designing a stored procedure
    • Specifying input parameters
    • Returning a recorded
    • Returning output parameters
  • Testing stored procedures
  • Creating DML Triggers
  • Altering DML Triggers
  • Using the Inserted and Deleted Tables
  • Creating DDL Triggers

Mode of Training

Online

Total duration of the course

5 to 7 weeks

Training duration per day

50 mins - 90 mins

Communication Mode

Go to meeting, WEB-EX

Software access:

Software will be installed/Server access will be provided, whichever is possible

Material

Soft copy of the material will be provided during the training.

Training

Both weekdays and weekends

Training Fee

 $500

  • Brief History of SQL
  • What is New in SQL Server 2008
  • SQL Server Editions
  • Relational Databases
    • Creating Database
    • Tables
    • Rows
    • Columns
    • Relationships
    • Data types
    • Primary Keys
    • Foreign Keys
    • Relational Database Management System
  • SQL Server Objects
    • Valid Object References
  • SQL Statements
    • Database Manipulation Language (DML)
    • Database Definition Language (DDL)
  •  
  • Introduction to the “Adventure Works DW” Database
  • Some Basics
    • Comments
    • Case Sensitivity
  • SELECTING All Columns in All Rows
  • Union Queries
  • Exploring the Tables
  • Using Group and Having
  • SELECTING Specific Columns
  • Sorting Records
    • Sorting By a Single Column
    • Sorting By Multiple Columns
    • Sorting By Column Position
    • Ascending and Descending Sorts
  • The WHERE Clause and Operator Symbols
    • Checking for Equality
    • Checking for Inequality
    • Checking for Greater or Less Than
    • Checking for NULL
    • WHERE and ORDER BY
  • The WHERE Clause and Operator Words
    • The BETWEEN Operator
    • The IN Operator
    • The LIKE Operator
    • The NOT Operator
  • Checking Multiple Conditions
    • AND
    • OR
    • Order of Evaluation
  • Writing SELECTs with Multiple Conditions
  • Calculated Fields
    • Concatenation
    • Mathematical Calculations
    • Aliases
  • Aggregate Functions and Grouping
    • Aggregate Functions
    • Grouping Data
    • Where Clause
    • Order By Clause
    • Using Group by and Having
  • Built-in Data Manipulation Functions
    • Common Math Functions
    • Common String Functions
    • Common Date Functions
  • Sub queries
  • Joins
    • Table Aliases
    • Multi-table Joins
  • Outer Joins
  • Unions
    • UNION ALL
    • UNION Rules
  • Creating Tables
  • Data types
  • Altering Tables
    • Adding a Column
    • Dropping a Column
  • Renaming Tables
  • Dropping Tables
  • Creating Views
  • Dropping Views
  • Creating Stored Procedures
    • Designing a stored procedure
    • Specifying input parameters
    • Returning a recorded
    • Returning output parameters
  • Testing stored procedures
  • Creating DML Triggers
  • Altering DML Triggers
  • Using the Inserted and Deleted Tables
  • Creating DDL Triggers

Mode of Training

Online

Total duration of the course

5 to 7 weeks

Training duration per day

50 mins - 90 mins

Communication Mode

Go to meeting, WEB-EX

Software access:

Software will be installed/Server access will be provided, whichever is possible

Material

Soft copy of the material will be provided during the training.

Training

Both weekdays and weekends

Training Fee

 $500