How You Can Master the Fundamentals of Transact-SQL
4.3 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
159 students enrolled
Wishlisted Wishlist

Please confirm that you want to add How You Can Master the Fundamentals of Transact-SQL to your Wishlist.

Add to Wishlist

How You Can Master the Fundamentals of Transact-SQL

A Real World Introduction to Transact-SQL
4.3 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
159 students enrolled
Created by Mike West
Last updated 3/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 9 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
Requirements
  • 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.
Description

SQL 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.


Who is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 49 Lectures Collapse All 49 Lectures 02:04:30
+
Introduction
9 Lectures 30:26

Let's find out what's in this course.

Preview 01:17

I want to make sure you are at the right place.

This lecture will discuss if this course is right for you.

Preview 01:07

What is the definition of a database?

What is different about what it is versus what it does?

Let's find out in this lecture

Preview 05:08

We are going to need to install SQL Server. Let's install the express edition of SQL Server.

Preview 07:32

Once SQL Server is installed we need a test database to learn with.

Let's install that in the lesson.

Installing Adventureworks Training Database
03:33

The main tools developers and DBAs use to manage their database environments.

Working With SQL Server Management Studio
07:48

We need a place to author our transact.

The query editor is the place we do that.

Let's learn about it in this lesson.

The Query Editor
02:39

We need to be able to speak the language of SQL Server.

These new words will help us get there.

Terminology
00:28

Summary
00:54

Quiz
10 questions
+
Writing Transact-SQL Overview
14 Lectures 41:56

Let's take a very high level look at the anatomy of a query.

A Query is Like a Sentence
01:01

There are two broad categories of Transact-SQL.

DDL and DML.

Let's define them in this lecture.

DML VS DDL
01:14

The USE statement sets our database context.

Let's see it in action in this lesson.

Use Statement
02:23

The core object in SQL Server is the table.

Let's learn about it in this lecture.

The Table Object
03:05

Let's put some data into a table.

The INSERT statement in action.

Inserting Data Into a Table
07:31

Let's go over that last lecture in more detail.

There were some "must know" concepts in there.

Lecture 14 Summary. Yes, lecture 14 was that important.
01:25

Relational databases... relate... but how?

Let's find out.

How do Tables Relate?
06:04

In lecture let's add some comments to our code so other know what we are doing.

Formatting and Commenting
05:28

Let's define DDL and discuss it in more detail.

Data Definition Language
03:48

All applications should be using stored procedure.

Let's talk about them in this lesson.

Creating Our First Stored Procedure
02:39

Let's see how we use input parameters in our stored procedures.

Input Parameters
03:05

Let's create a simple stored procedure to INSERT data into a simple table.

Create Stored Procedure for Inserts
02:20

Let's cover some of the new terms.

Terminology
00:36

Let's recap what we've covered in this lesson.

Summary
01:17

Quiz
10 questions
+
Data Manipulation Language
13 Lectures 29:03

Let's cover the very basics of the SELECT statement.

Anatomy of a SELECT Statement
02:15

Let's talk about these containers.

Schemas
02:35

In this lecture let's give our column names we want.

Column Aliasing
00:45

You can create a column on the fly in SQL Server. Let's see how.

Derived Column
01:20

Working with dates in fundamental in T-SQL.

Let's look at one of the functions we use to manipulate dates.

Using the DATEDIFF function
02:15

Views are often used to hide the tables structure and prevent direct access.

Let's create one in this lesson.

Creating a View
02:53

We compare items in T-SQL.

Let's find out what words do that work for us.

Basic Comparison Operators
02:29

A great clause that's not to relevant due to the performance implications.

Let's look at LIKE.

The Like Clause
03:35

What are logical comparisons.

Let's learn what they are and how to use them in this lecture.

Logical Comparisons
02:29

The infamous NULL value.

Let's talk about what it is and what it isn't.

The NULL
03:19

How do we filter our queries.

Let's find out.

Extended Filtering
03:11

Adding parenthesis to filtering.

Filtering With Parenthesis
01:06

Let's wrap up what we've covered.

Summary
00:51

Quiz
10 questions
+
Functions
8 Lectures 15:57

We will use functions often.

What is a function?

Let's find out.

Anatomy of a Function
03:02

There are different kinds of functions.

What's a UDF?

User Defined Function
02:32

A function that returns a table.

Let's look at this unique function.

Inline Table-Valued Function
01:35

A more complicated function.

Multi-Statement Table Valued User Defined Functions
01:34

Let's learn how to use aggregate functions.

You'll use these often.

Aggregate Functions
02:27

I subtle distinction in these two but a really important one.

Count(ALL) Versus Count(Distinct)
01:50

You'll use conversion functions in almost every stored procedure you craft.

Let's learn what they are.

Conversion Functions
01:56

Let's wrap up what we've covered in this section.

Summary
01:01

Quiz
7 questions
+
More Advanced Transact-SQL
4 Lectures 06:55

Let's use a query within the select statement.

Subqueries in the SELECT Statement
01:33

You'll see this used often.

Let's walk through the having clause.

Having Clause
00:45

CTE's don't touch tempdb... making them a must as we being to move our code to the cloud.

Common Table Expressions
04:03

Let's wrap up what we've covered in this lecture.

Summary
00:34

Quiz
8 questions
+
Conclusion
1 Lecture 00:17

Congratulations and thank you!!

Final Thoughts and Thank You!!!!
00:17
About the Instructor
Mike West
4.3 Average rating
1,957 Reviews
33,194 Students
36 Courses
SQL Server and Machine Learning Evangelist

I've been a production SQL Server DBA most of my career.

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.

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.