Transact-SQL Programming Fast Track – Video Course

Home/Video Course/Transact-SQL Programming Fast Track – Video Course

Transact-SQL Programming Fast Track – Video Course

$149.00

Note: Yearly Subscription

Programming with Transact-SQL is an essential skill if you are developing applications for SQL Server, or even if you are just querying data from SQL Server. Irrespective of your role – Developer, Database Administrator, Data Architect, Data Analyst, Business Intelligence, Data Scientist, or just a power user – T-SQL programming skills are critical for you to be successful. This 15-hour video course gives you a strong foundational skill with T-SQL programming and loads of practical examples. You will learn about T-SQL language elements, logical flow, Query Optimizer, Execution Plans, Table Variables, Temporary Tables, Views, Stored Procedures, User Defined Functions, Triggers, Dynamic SQL, Transactions & Concurrency & Error Handling. Yes, very comprehensive coverage in a fast-track mode, packed with loads of real-world demos. Along the way, you will learn about a few T-SQL enhancements in different versions of SQL Server. Wherever relevant, query tuning is discussed with examples. At the end of the course, you will be able to program with T-SQL.

Category:

Description

Programming with Transact-SQL is an essential skill if you are developing applications for SQL Server, or even if you are just querying data from SQL Server. Irrespective of your role – Developer, Database Administrator, Data Architect, Data Analyst, Business Intelligence, Data Scientist, or just a power user – T-SQL programming skills are critical for you to be successful. This 15-hour video course gives you a strong foundational skill with T-SQL programming and loads of practical examples. You will learn about T-SQL language elements, logical flow, Query Optimizer, Execution Plans, Table Variables, Temporary Tables, Views, Stored Procedures, User Defined Functions, Triggers, Dynamic SQL, Transactions & Concurrency & Error Handling. Yes, very comprehensive coverage in a fast-track mode, packed with loads of real-world demos. Along the way, you will learn about a few T-SQL enhancements in different versions of SQL Server. Wherever relevant, query tuning is discussed with examples. At the end of the course, you will be able to program with T-SQL.

Instructor: Amit R S Bansal

Total Duration: 7 hours 20 Mins

Total Lecture Time: 2 hrs 45 mins

Total Demo Time: 4 hrs 35 mins (Yeah, demos are the real value)

Level: Intermediate to Advanced (Level 200 to 300)

Delivery Format: Video Course. Stream anywhere, anytime, any device, as many times.

Pre-Requisite: Just basic experience with SQL Server.

Course Outline

Module 0: Introduction

  • Before You Begin
  • Modules
  • Demo Setup
  • What Not To Expect
  • What To Expect
  • How To Get The Best Out Of This Course


Module 1: Introduction To T-SQL Programming

  • Historical Information
  • Logical Flow of a SELECT Statement
  • T-SQL Language Elements
  • T-SQL Programmable Techniques/Objects
  • Query Optimizer Basics
  • Understanding Execution Plans
  • TRUE, FALSE & UNKNOWN
  • Demos

Module 2: Table Variables & Temporary Tables

  • Introduction
  • Temporary Tables
  • Table Variables
  • Temporary Tables vs Table Variables
  • Tempdb Considerations
  • Demos

Module 3: Views

  • Introduction
  • Limitations
  • Modifying Data Through Views
  • View Options
  • Indexed Views
  • Demos

Module 4: Stored Procedures

  • Introduction
  • Types of SPs
  • Advantages
  • Best Practices
  • Demos

Module 5: User Defined Functions (UDF)

  • Introduction
  • Uses & Benefits
  • Types
  • Limitations/Characteristics
  • Stored Procedures vs UDFs
  • Demos

Module 6: Triggers

  • Introduction
  • FOR or AFTER Triggers
  • INSTEAD OF Triggers
  • Special Tables
  • Demos

Module 7: Dynamic SQL

  • Introduction
  • Use Cases
  • Best Practices
  • Demos

Module 8: Transactions & Concurrency

  • Data Modification
  • Concurrency Architecture
  • Isolation Levels
  • Concurrency Problems vs Isolation Levels
  • Deadlocks
  • Transactions
  • Best Practices
  • Demos

Module 9: Error Handling

  • TRY/CATCH Blocks
  • XACT_ABORT
  • Useful Techniques
  • Demos

Module 10: Wrap Up

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Content missing