Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Complete Microsoft SQL Bootcamp :Learn SQL For Beginners
Introduction
Introduction to the course: SQL For Beginners : Microsoft : Beginner To Expert (1:19)
Installing SQL Server on a Windows Server Environment
Download and Installing SQL Server on the Windows Server . (9:02)
Installing SQL Server Management Studio (5:01)
How to create a database and table a SQL Server Database
What is a database. (1:31)
What is a table. (1:02)
Setup and creating test data. (1:09)
Getting information from tables using SELECT Statements
SELECT. (4:04)
UNION. (1:28)
DATE Functions. (5:08)
CASE Statements. (3:10)
Further Reading
TSQL Quiz
Assignment : Learn TSQL
Joining tables using JOIN Statements
JOINS : INNER, LEFT AND RIGHT JOINS - PART 1
JOINS : INNER, LEFT AND RIGHT JOINS. - PART 2 (11:36)
Which JOIN is better? PART 1 (4:20)
Which JOIN is better? PART 2
Aggregation Functions
COUNT Statement. (3:23)
SUM Statement. (2:39)
AVG (Average) Statement. (3:29)
Filter GROUP BY Statement using HAVING Statements
Filter GROUP BY Statement using HAVING Statements. (4:19)
Insert Statements
Insert Statements. (2:57)
Further Reading
Update Statements
Update Statements. (2:52)
Further Reading
Delete Statements
Delete Statements. (2:26)
Further Reading
Condition Statements
IF/ ELSE. (4:53)
Further Reading
Practice Assignment
Practice Assignment
Learn how to import a file into SQL Server
Importing a file into SQL Server. (5:40)
Practice Assignment - Import File
SQL Server Training Path
SQL Server Training Path
Certificate Of Completion
Certificate Of Completion
Teach online with
Which JOIN is better? PART 1
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock