Microsoft SQL Course
at just
$69
Enroll Now
Sign Up
Sign In
Microsoft SQL Course
Microsoft SQL Course
Section 1 : Introduction to SELECT Statements
Lecture 1
START HERE Introduction Lecture
4:11
Lecture 2
How to Install Microsoft SQL Server Express
Pdf
Lecture 3
How to Download and Install SQL Server Express
11:26
Lecture 4
How to Attach the AdventureWorks Database
4:45
Lecture 5
Introduction to T-SQL and Database Concepts
4:13
Lecture 6
Literal SELECT Statements - Part 1
Preview
Lecture 7
Literal SELECT Statements - Part 2
3:39
Lecture 8
Literal SELECT Statement Practice Problems
Pdf
Lecture 9
Basic SELECT Statements - Part 1
8:42
Lecture 10
Basic SELECT Statements - Part 2
8:10
Lecture 11
Basic SELECT Statements - Part 3
6:29
Lecture 12
Basic SELECT Statement Practice Problems
Pdf
Section 2 : Filtering Data with the WHERE Clause
Lecture 13
Using the WHERE Clause - Part 1
5:33
Lecture 14
Using the WHERE Clause - Part 2
5:11
Lecture 15
Using the WHERE Clause - Part 3
Preview
Lecture 16
Using the WHERE Clause - Part 4
8:16
Lecture 17
Using the WHERE Clause - Part 5
8:3
Lecture 18
Using the WHERE Clause - Part 6
8:29
Lecture 19
Using the WHERE Clause - Part 7
7:27
Lecture 20
WHERE Clause Practice Problems
Pdf
Section 3 : Sorting Data with the ORDER BY Clause
Lecture 21
Sorting with the ORDER BY Clause - Part 1
7:48
Lecture 22
Sorting with the ORDER BY Clause - Part 2
6:23
Lecture 23
ORDER BY Clause Practice Problems
Pdf
Section 4 : Querying Multiple Tables with Joins
Lecture 24
Using the INNER JOIN - Part 1
8:15
Lecture 25
Using the INNER JOIN - Part 2
Preview
Lecture 26
INNER JOIN Practice Problems
Pdf
Lecture 27
Using the LEFT OUTER JOIN - Part 1
Preview
Lecture 28
Using the LEFT OUTER JOIN - Part 2
10:25
Lecture 29
Using the LEFT OUTER JOIN - Part 3
Preview
Lecture 30
LEFTRIGHT OUTER JOIN Practice Problems
Pdf
Section 5 : Aggregate Functions
Lecture 31
Aggregate Functions - Part 1
7:53
Lecture 32
Aggregate Functions - Part 2
4:34
Lecture 33
Aggregate Function Practice Problems
Pdf
Section 6 : Grouping Data with the GROUP BY Clause
Lecture 34
Grouping with the GROUP BY Clause - Part 1
6:45
Lecture 35
Grouping with the GROUP BY Clause - Part 2
8:9
Lecture 36
GROUP BY Clause Practice Problems
Pdf
Section 7 : Filtering Groups with the HAVING Clause
Lecture 37
Filtering Groups with the HAVING Clause - Part 1
7:17
Lecture 38
Filtering Groups with the HAVING Clause - Part 2
7:10
Lecture 39
HAVING Clause Practice Problems
Pdf
$69
Take this course now.
Enroll Now
Lectures
39
Video
3:20:56 Hours
Skill level
intermdiate
level
Languages
English
Includes
Lifetime access
Certificate of Completion
Preview
×