How You Can Master the Fundamentals of TransactSQL

A Real World Introduction to Transact-SQL
How You Can Master the Fundamentals of TransactSQL
File Size :
874.74 MB
Total length :
2h 4m



Mike West


Last update




How You Can Master the Fundamentals of TransactSQL

What you’ll learn

At the conclusion of this course you’ll have a fundamental understanding of Transact-SQL.
You’ll learn the 4 components of every query.
You’ll also learn the difference between DML and DDL and when to use each.

How You Can Master the Fundamentals of TransactSQL


You’ll need to download a copy of SQL Server Express. However, don’t do it now. We will do this early in the course.
You’ll need a copy of the SQL Server *play* database. Again, don’t worry about that now. We will do that before we really dig into the course.


COURSE REVIEWS: “This is a great course- I would fully recommend completing it. Course highlights: Great tip on using design view when using joins as this can help define which column you should be joining on. End of module summary/terminology which you can print out for future reference and use End of module quiz Thank you very much!” — Benjamin “Finest experience with Udemy they explain each and everything so clearly.” — Manu”I needed a quick introduction into T-SQL, and that’s exactly what I got. A lot of useful information in a short period of time. Great course!” — Olga”Great Instructor” — Kolawole”An amazing course!” –Alfred “The course is great for beginners.” –Shelli “Amazing experience. got clear idea about how db works and store procedure. Thank you very much, Mike.” — Ujjawal”A great introduction to T-SQL. It’s amazing that instruction of this quality is available for free. Many thanks.” — IP”Short but covers a lot.” — Tamuka”Great.” — Ketan”It was a quick course, but a lot was covered.” — Brandon”Thank you Mike! I love the course, it is good for beginners. please go ahead and enroll for the course.” — Anuja “For understanding the basics of T-SQL this course is good.” — Matti”I have done three of Mike’s SQL courses and learned a lot. I think these courses would be great for anyone new to SQL Server. I imagine this would be great preparation for those thinking about getting an MS SQL Server certification too.” — Keith B”The explanation was very simple and easy to understand.” — MansoorCOURSE OVERVIEWSQL Server is a combination of two core items The first is the administration side of the house. Creating databases, managing logins and users, backups,… etc.The second part of the equation is that of developing code in a language called Structured Query Language. Microsoft’s flavor of SQL is called Transact-SQL. Transact was designed primarily to work with relational databases. Transact is the language used to talk to SQL Server. When we want to create a database a database we use DDL or Data Definition Language. I’m defining an object when I use the statement with the code. When we want to see data inside a table we use DML or Data Manipulation Language. I’m not creating an object I’m manipulating the data inside that object. In this course we are going to learn the basics of Transact-SQL or T-SQL. We will cover the fundamentals of Transact using real world examples. Additionally, we will discuss some of the best practices associated with crafting clean, high performance code. You’ll learn why stored procedures are so important to well-designed applications and why ad hoc queries aren’t. The knowledge you gain from the course will not only help you learn to develop but will also give you a great first step to learning how to pinpoint performance issues due to poorly written code. Thanks for your interest in “Real World Transact-SQL from the Ground Up.”See you in the course.


Section 1: Introduction

Lecture 1 Welcome To The Course

Lecture 2 Is this Course Right For You?

Lecture 3 A Quick Look at Objects

Lecture 4 Installing SQL Server Express Edition

Lecture 5 Installing Adventureworks Training Database

Lecture 6 Working With SQL Server Management Studio

Lecture 7 The Query Editor

Lecture 8 Terminology

Lecture 9 Summary

Section 2: Writing Transact-SQL Overview

Lecture 10 A Query is Like a Sentence

Lecture 11 DML VS DDL

Lecture 12 Use Statement

Lecture 13 The Table Object

Lecture 14 Inserting Data Into a Table

Lecture 15 Important Summary

Lecture 16 How do Tables Relate?

Lecture 17 Formatting and Commenting

Lecture 18 Data Definition Language

Lecture 19 Creating Our First Stored Procedure

Lecture 20 Input Parameters

Lecture 21 Create Stored Procedure for Inserts

Lecture 22 Terminology

Lecture 23 Summary

Section 3: Data Manipulation Language

Lecture 24 Anatomy of a SELECT Statement

Lecture 25 Schemas

Lecture 26 Column Aliasing

Lecture 27 Derived Column

Lecture 28 Using the DATEDIFF function

Lecture 29 Creating a View

Lecture 30 Basic Comparison Operators

Lecture 31 The Like Clause

Lecture 32 Logical Comparisons

Lecture 33 The NULL

Lecture 34 Extended Filtering

Lecture 35 Filtering With Parenthesis

Lecture 36 Summary

Section 4: Functions

Lecture 37 Anatomy of a Function

Lecture 38 User Defined Function

Lecture 39 Inline Table-Valued Function

Lecture 40 Multi-Statement Table Valued User Defined Functions

Lecture 41 Aggregate Functions

Lecture 42 Count(ALL) Versus Count(Distinct)

Lecture 43 Conversion Functions

Lecture 44 Summary

Section 5: More Advanced Transact-SQL

Lecture 45 Subqueries in the SELECT Statement

Lecture 46 Having Clause

Lecture 47 Common Table Expressions

Lecture 48 Summary

Section 6: Conclusion

Lecture 49 Final Thoughts and Thank You!!!!

This course is for anyone interested in learning the basics of Transact-SQL.,This IS an entry level course. ,Everything you need for the course will be included in the course.

Course Information:

Udemy | English | 2h 4m | 874.74 MB
Created by: Mike West

You Can See More Courses in the IT & Software >> Greetings from

New Courses

Scroll to Top