EARLY ACCESSNETWORKING & SYSTEMS PATHLIFETIME ACCESS
— THE LIBRARY — COURSE
Microsoft SQL Server Development
Self-paced video training — 5 modules, 31 lessons. Work through it at your own pace — every lesson is real practitioner training, not slide-reading.
5
MODULES
31
LESSONS
1080p
STREAMING
1st
LESSON FREE
▶FREE PREVIEW · INTRODUCTION TO SQL SERVER AND DATABASESFREE · NO ACCOUNT NEEDEDWATCH NOW →
CURRICULUM
5 modules, in order.
01Introduction2 LESSONS
▶Introduction to SQL Server and DatabasesFREE
▶Download and Install SQL Server Express E7
02Manipulating Tables and Data12 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
03Relationships and Foreign Keys5 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
04Group By and Aggregate Functions5 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
05Advanced SQL Server Objects and Concepts7 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
CURATED BY
CyberCoreSchool
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.