Skip to content
Write a review
UdemySQLPaid courseBeginner levelCertificate

How You Can Master the Fundamentals of Transact-SQL (Udemy.com)

A Real World Introduction to Transact-SQL

4.2
756 reviews

Created by: Mike West

Last updated April 2025

icon
What you will 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 it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.2 out of 5higher than 13% of them
  • Reviews756#171 of 389 by number of reviews
  • Length2.1 hoursshorter than 84% of them
  • Last updatedApril 2025more recently than 66% of them

icon
Course Description

COURSEREVIEWS:"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." -- MansoorCOURSEOVERVIEWSQL 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. Microsofts 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. Im 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. Im not creating an object Im 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. Youll learn why stored procedures are so important to well-designed applications and why ad hoc queries arent. 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. Who this course is for:
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.
Read More Beginner Beginner Level product length iconTime: 2.1h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Mike West

I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.
Over the last five years I've transitioned to the exciting world of applied machine learning. I'm excited to show you what I've learned and help you move into one of the single most important fields in this space.
Experience, education and passion
I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.
Certifications
Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).
Personal
Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.


Read More

icon
More courses by Mike West

$14.99

Free

$13.99

$69.99

$54.99

$54.99

All courses by Mike West

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

All SQL courses

icon
Reviews

4.2

756 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Michael S. Armentrout on 10/25/2020

Great overall coverage of TSQL. Good refresher for me. If you want to get started with TSQL, buy this course.

By Laura Herrera on 9/17/2020

The course was very vague and didn't get into examples to much. It felt rushed and not what i was expecting based on the description. Its very much an overview of the basics.

By Mosim Patel on 8/24/2020

okkk

By Brendan Couch on 8/8/2020

very helpful, clear and precise

By Raul on 7/27/2020

It's a good basic overview of T-SQL and SSMS.

By NCVI Core Systems on 7/4/2020

Pacing is just moderate enough to understand. Thanks!

By Frank Zhao on 5/12/2020

The voice is so low that I can't hear what the instructor said somtimes.

By Innocent Vilakazi on 5/6/2020

It is a good match though the video keeps on buffering which makes it difficult for me to pay attention.

By KOLAWOLE OMOLOLA on 5/3/2020

Great Instructor

By Rohit Dhadwal 2018 on 4/25/2020

i am aware of these settings, so its good for me

By Ravikumar Saroj on 4/16/2020

Subtitles not correct

By David Cook on 4/16/2020

Moves a bit fast and the order in which concepts are introduced is a bit wonky. Often a concept is mentioned before it is explained so things are a bit out of order in my opinion.

Showing 12 of 91 reviews

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100

How You Can Master the Fundamentals of Transact-SQL
Visit course on Udemy Write a review
  • Video Duration: icon 2.1h
  • Price: $59.99
  • Provider: icon Udemy
  • Updated: icon April 2025
  • Level: Beginner Beginner
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com