Course Outline


Installing and Configuring Microsoft SQL Server

Overview of Microsoft SQL Server Features

Overview of Transact-SQL Concepts

Querying a Database using SELECT

Filtering the Data with WHERE

Sorting the Data with ORDER BY

Querying Multiple Tables with Joins

Grouping Data with GROUP BY

Using Aggregate Functions to Perform Calculations on Resulting Data

Filtering Groups with HAVING

Creating a New Database

Understanding the Database Model

Optimizing the Database through Normalization

Enhancing your Queries with Procedures

Writing Functions and Sub-routines

Using Conditions to Control the Flow

Connecting to Microsoft SQL Server through Excel


Summary and Conclusion


  • NO previous SQL or database experience is required.
  21 Hours


Related Courses

Administering in Microsoft SQL Server

  21 hours

Microsoft SQL Server 2008/2012 (MSSQL)

  14 hours

Business Intelligence in MS SQL Server 2008

  14 hours

Developing in SQL Server Business Intelligence

  35 hours

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

  14 hours

T-SQL Fundamentals with SQL Server Training Course

  14 hours

SQL language in MSSQL

  14 hours

SQL in SQL Server

  14 hours

Transact SQL Advanced

  7 hours

Transact SQL Basic

  14 hours

Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012

  21 hours

Administration with Powershell

  35 hours

Business Intelligence with SSAS

  14 hours