Course Curriculum
- 6 sections
- 31 lectures
- 00:00:00 total length
-
Introduction to SQL Server and Databases
00:04:00 -
Download and Install SQL Server Express
00:05:00
-
Connect to Database Instance and Create a Database
00:06:00 -
Drop or Remove Database
00:04:00 -
What is a Database Table?
00:02:00 -
Create an SQL Database Table
00:32:00 -
Insert Data into the Table with SQL Script
00:15:00 -
Insert Data into the Table with Management Studio
00:05:00 -
Select Data from the Table with SQL Script
00:09:00 -
More Advanced Select Queries Part 1
00:18:00 -
Update Data in the Table
00:10:00 -
Update Data in the Table with Management Studio GUI
00:02:00 -
Delete Data from the Table with SQL Script
00:06:00 -
Delete Data from the Table with Management Studio GUI
00:01:00
-
What are Relationships, Foreign Keys and Normalization
00:11:00 -
Create a Relationship in SQL Server
00:19:00 -
Insert Records in Related Tables
00:13:00 -
Run Queries on Related Tables
00:19:00 -
Left, Right and Full Joins
00:11:00
-
Grouping Data using SQL GROUP BY Clause
00:12:00 -
SQL AVG Aggregate Function
00:11:00 -
SQL COUNT Aggregate Function
00:04:00 -
SQL MAX and MIN Aggregate Functions
00:04:00 -
SQL SUM Aggregate Function
00:04:00
-
Create and Manage Views
00:23:00 -
Scalar Valued Functions
00:27:00 -
Inline Table Valued Functions
00:09:00 -
Stored Procedures
00:28:00 -
Table Triggers
00:19:00 -
Database Scripting, Backup and Restore
00:15:00
-
Assignment – Microsoft SQL Server Development for Everyone
00:00:00