Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft SQL Server Development for Everyone!
Full Course
Introduction to SQL Server and Databases (4:08)
Download and Install SQL Server Express 2017 (5:21)
Connect to Database Instance and Create a Database (5:55)
Drop or Remove Database (4:16)
What is a Database Table? (2:08)
Create an SQL Database Table (31:40)
Insert Data into the Table with SQL Script (15:03)
Insert Data into the Table with Management Studio (4:33)
Select Data from the Table with SQL Script (9:19)
More Advanced Select Queries Part 1 (17:50)
Update Data in the Table (9:49)
Update Data in the Table with Management Studio GUI (2:13)
Delete Data from the Table with SQL Script (6:27)
Delete Data from the Table with Management Studio GUI (1:23)
What are Relationships, Foreign Keys and Normalization (11:29)
Create a Relationship in SQL Server (19:24)
Insert Records in Related Tables (12:58)
Run Queries on Related Tables (Inner Joins) (19:22)
Left, Right and Full Joins (10:41)
Grouping Data using SQL GROUP BY Clause (11:41)
SQL AVG Aggregate Function (11:00)
SQL COUNT Aggregate Function (3:46)
SQL MAX and MIN Aggregate Functions (3:29)
SQL SUM Aggregate Function (4:02)
Create and Manage Views (23:12)
Scalar Valued Functions (26:52)
Inline Table Valued Functions (9:25)
Multi Statement Table Valued Functions (12:28)
Stored Procedures (27:38)
Table Triggers (19:13)
Database Scripting, Backup and Restore (14:35)
Run Queries on Related Tables (Inner Joins)
Download
joins_enrollments.sql
Complete and Continue