EARLY ACCESSNETWORKING & SYSTEMS PATHLIFETIME ACCESS
Microsoft SQL Server Development for Everyone!
Self-paced video training — 5 modules, 62 lessons. Work through it at your own pace — every lesson is real practitioner training, not slide-reading.
5
MODULES
62
LESSONS
1080p
STREAMING
1st
LESSON FREE
▶FREE PREVIEW · INTRODUCTION TO SQL SERVER AND DATABASESFREE · NO ACCOUNT NEEDEDWATCH NOW →
CURRICULUM
5 modules, in order.
01Introduction4 LESSONS
▶Introduction to SQL Server and DatabasesFREE
▶Download and Install SQL Server Express E7
▶Introduction to SQL Server and Databases
▶Download and Install SQL Server Express E7
02Manipulating Tables and Data24 LESSONS
▶Connect to Database Instance and Create a Database
▶Drop or Remove Database
▶What is a Database Table
▶Create an SQL Database Table
▶Insert Data into the Table with SQL Script
▶Insert Data into the Table with Management Studio
▶Select Data from the Table with SQL Script
▶More Advanced Select Queries Part 1
▶Update Data in the Table
▶Update Data in the Table with Management Studio GUI
▶Delete Data from the Table with SQL Script
▶Delete Data from the Table with Management Studio GUI
+ 12 more lessons
03Relationships and Foreign Keys10 LESSONS
▶What are Relationships Foreign Keys and Normalization
▶Create a Relationship in SQL Server
▶Insert Records in Related Tables
▶Run Queries on Related Tables (Inner Joins)
▶Left Right and Full Joins
▶What are Relationships Foreign Keys and Normalization
▶Create a Relationship in SQL Server
▶Insert Records in Related Tables
▶Run Queries on Related Tables (Inner Joins)
▶Left Right and Full Joins
04Group By and Aggregate Functions10 LESSONS
▶Grouping Data using SQL GROUP BY Clause
▶SQL AVG Aggregate Function
▶SQL COUNT Aggregate Function
▶SQL MAX and MIN Aggregate Functions
▶SQL SUM Aggregate Function
▶Grouping Data using SQL GROUP BY Clause
▶SQL AVG Aggregate Function
▶SQL COUNT Aggregate Function
▶SQL MAX and MIN Aggregate Functions
▶SQL SUM Aggregate Function
05Advanced SQL Server Objects and Concepts14 LESSONS
▶Create and Manage Views
▶Scalar Valued Functions
▶Inline Table Valued Functions
▶Multi Statement Table Valued Functions
▶Stored Procedures
▶Table Triggers
▶Database Scripting Backup and Restore
▶Create and Manage Views
▶Scalar Valued Functions
▶Inline Table Valued Functions
▶Multi Statement Table Valued Functions
▶Stored Procedures
+ 2 more lessons
CURATED BY
SecuraLearn
PRACTITIONER-CURATED LIBRARY
Selected from working practitioners' training libraries and kept whole — modules, labs and walkthroughs exactly as taught.
GOOD TO KNOW
Lessons stream in the browser and remember where you stopped.
Watch on two devices at once — phone, tablet or desktop.
Download buttons are disabled; delivery uses expiring encrypted links.
$149 · ONE PAYMENT
Start with the free lesson.
The first lesson is open to everyone. Buy the course when you are sure — after that it is yours for life.