T-SQL using Microsoft SQL Server

Schedule for this Course

There are no dates scheduled for this course.
If you would like to be added to the wait list for this class Click Here

Course Description:

This 3-day, instructor-led course provides students with a solid understanding of T-SQL. This training is for individuals who are new to writing SQL queries. This course concentrates Transact-SQL syntax such as Select, Insert, Update and Delete statements. This course also discusses real-world subjects like Stored Procedures, User-defined Functions and more. It is designed as a hands-on, lab intensive course.

At the end of this course, students will be able to write SQL queries including, Select statements, Insert, Update and Delete statements.

This course covers syntax applicable to Microsoft SQL Server 2008, 2008R2, 2012, 2014, 2016

Prerequisites

There are no prerequisites for this class.

Course Outline:

Part 1: What we need to know before learning to write queries

• Module 1: Introduction to Microsoft SQL Server
  • Overview of items we will need for this course:
    • Microsoft SQL Server Management Studio (SSMS)
    • Connecting to a server
    • The Object Explorer
    • The Query Window

• Module 2: Writing Scripts
  • Creating a Project / Solution
  • What is a Script?
  • What is a Batch
  • The Use statement
  • The Go command
  • Declaring a variable
  • Begin End
  • While Loop
  • If Statement
  • The Return, Break, Continue keywords

Part 2: Retrieving and Manipulating Data

• Module 3: Select Statements
  • SELECT List
    • Using an Alias for column names
  • FROM Clause
  • WHERE Clause
    • IN operator
    • BETWEEN operator
    • LIKE operator
    • AND / OR / NOT operators
  • ORDER BY Clause
  • TOP keyword

• Module 4: Useful T-SQL Functions

• Module 5: Joining Multiple Tables
  • JOIN Operator
  • LEFT / RIGHT / OUTER JOIN
  • UNION

• Module 6: Grouping and Summarizing Data
  • Working with Aggregate Functions
  • GROUP BY Clause
  • HAVING Clause
  • COMPUTE and COMPUTE BY

• Module 7: Using Subqueries
  • Subqueries as expressions
  • Subqueries as Tables
  • Correlated Queries
  • EXIST Clause

Part 3: Inserting, Updating and Deleting Data

• Module 8: Modifying Data
  • INSERT statements
  • UPDATE statements
  • DELETE statements
  • Output clause
  • Transactions
  • Error Handling
  • Try/Catch

Part 4: Advanced T-SQL Topics

• Module 9: Advanced T-SQL Topics
  • Stored Procedures
  • Views
  • User Defined Functions Overview
  • Triggers Overview
  • For XML
  • CTE
  • Merge
  • Temporary Tables

Part 5: Overview of Microsoft SQL Server 2012 (If Time Permits)

• Appendix 1: Misc Optional Instructor Lead Overviews
  • Query Performance Overview
  • Query Execution Plans
  • Administration Overview
  • Implementing Overview
  • SSRS Described
  • SSIS Described
  • SSAS Described

• Appendix 2: Overview of Relational Data
  • Tables
  • Data types overview
  • Relationships overview
  • Database Diagrams
  • Schemas