Querying SQL Server using Transact – SQL


This course is designed for individuals with beginner or intermediate skills in SQL Programming. In this course, you will learn the technical skills required to write basic and advanced Transact-SQL (T-SQL) queries for Microsoft SQL Server. This is the foundational course for all SQL server related disciplines: database administration, database development and business intelligence. Tools and skills you will learn include: SQL Server Management Studio, T-SQL , SELECT statements in querying multiple tables, data types, data sorting and filtering, data manipulation language (DML) , grouping and aggregating data, table expressions, set operators, window functions and T-SQL programming


Target Audience
  • Beginners (Completely new to the world of T SQL)
  • Experienced developers willing to enhance their T-SQL Skills
Course format
  • Beginners (Completely new to the world of T SQL)
  • Weekly homework assignment
  • Students are assigned projects to work on and present at the end of the course
  • 12 months contnuous support after completion of course
Cost & Payment Terms

The cost of this 8 week course is $1,500.


There are 2 payment options:
  • Option 1: Full payment due at the beginning of the course. (10 % Discount)
  • Option 2: Half due at the beginning of the course and remaining half due by the beginning of week 4.

Discounts are available to those who qualify

Course Dates & Duration

The normal course duration is 60 hours, spread over 8 weeks. Classes will be held on Tuesdays and Thursdays between the hours of 6 PM and PM
Optional weekend classes (Tech Series) are available for interested students

Prerequisites

knowledge of Microsoft Windows operating systems.
Basic understanding of database design and concepts



Course Outline

Part I: Database and T – SQL Fundamentals (24 hours)
Querying SQL Server: T-SQL
  • What is Structured Query Language?
  • Logical Processing of Queries
  • Selecting, Filtering, Aggregating and Sorting Data
  • Understanding system functions
  • Operators and expressions
  • Understanding Joins
  • Sub Queries
  • Table Expressions
  • Set Theory
  • Introduction to windows functions
  • Pivoting data using T-SQL
Part II: Understanding Data manipulation Language (6 hours)
Inserting Data
  • INSERT ….VALUES
  • INSERT…..SELECT
  • INSERT…..EXEC
  • SELECT….INTO
Modifying Data
  • UPDATE....SET
  • Update data via joins, CTE and views
Deleting Data
  • DELETE....FROM
  • Delete data via joins, CTE and Views
  • TRUNCATE vs DELETE
  • Understanding OUTPUT Clause
Part III: Programming with T SQL (30 hours)
  • Temporary Tables
  • Variables
  • User defined functions - Overview
  • Scalar functions
  • Table Valued Functions
  • Stored Procedures - Overview
  • Parameterized Stored procedures
  • Using Dynamic SQL in stored procedures
  • Using IF ELSE constructs in Stored Procedures
  • Error handling in Stored Procedures
  • Understanding Triggers