How You Can Master the Fundamentals of Transact-SQL

Focused View

Mike West

1:57:13

19 View

01 - Introduction

001 Welcome To The Course.mp4

01:17

002 Is this Course Right For You.mp4

01:07

003 A Quick Look at Objects.mp4

05:08

004 Installing SQL Server Express Edition.mp4

07:32

005 Installing Adventureworks Training Database.mp4

03:33

006 Working With SQL Server Management Studio.mp4

07:48

007 The Query Editor.mp4

02:39

008 Terminology.html

009 Summary.html

02 - Writing Transact-SQL Overview

001 A Query is Like a Sentence.mp4

01:01

002 DML VS DDL.mp4

01:14

003 Use Statement.mp4

02:23

004 The Table Object.mp4

03:05

005 Inserting Data Into a Table.mp4

07:31

006 Important Summary.html

007 How do Tables Relate.mp4

06:04

008 Formatting and Commenting.mp4

05:28

009 Data Definition Language.mp4

03:48

010 Creating Our First Stored Procedure.mp4

02:39

011 Input Parameters.mp4

03:05

012 Create Stored Procedure for Inserts.mp4

02:20

013 Terminology.html

014 Summary.html

03 - Data Manipulation Language

001 Anatomy of a SELECT Statement.mp4

02:15

002 Schemas.mp4

02:35

003 Column Aliasing.mp4

00:45

004 Derived Column.mp4

01:20

005 Using the DATEDIFF function.mp4

02:15

006 Creating a View.mp4

02:53

007 Basic Comparison Operators.mp4

02:29

008 The Like Clause.mp4

03:35

009 Logical Comparisons.mp4

02:30

010 The NULL.mp4

03:19

011 Extended Filtering.mp4

03:12

012 Filtering With Parenthesis.mp4

01:06

013 Summary.html

04 - Functions

001 Anatomy of a Function.mp4

03:02

002 User Defined Function.mp4

02:32

003 Inline Table-Valued Function.mp4

01:35

004 Multi-Statement Table Valued User Defined Functions.mp4

01:34

005 Aggregate Functions.mp4

02:27

006 Count(ALL) Versus Count(Distinct).mp4

01:50

007 Conversion Functions.mp4

01:56

008 Summary.html

05 - More Advanced Transact-SQL

001 Subqueries in the SELECT Statement.mp4

01:33

002 Having Clause.mp4

00:45

003 Common Table Expressions.mp4

04:03

004 Most-Know-SQL-Server-Interview-Quetions.pdf

004 Summary.html

06 - Conclusion

001 Final Thoughts and Thank You!!!!.html

Description

A Real World Introduction to Transact-SQL

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.

Who is this 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.

What You Need to Know?

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.

More details

Description
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." -- Mansoor

COURSEÂ OVERVIEW
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 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.

User Reviews

Rating

average 0

Total votes0

Focused display

I'm the founder of LogikBot. I've worked at Microsoft and Uber. I helped design courses for Microsoft's Data Science Certifications. If you're interested in machine learning, I can help. 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.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.