Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn Fundamental SQL Programming With SQL Server
Introduction
What we're going to learn (1:06)
Getting the necessary tools
Get SQL Server (4:07)
Install SQL Server and Management Console (4:48)
Learning the Fundamentals
Make a database and add a table from Excel (7:52)
Select a variety of columns and displays the results (8:51)
Conceptual Introduction to Where (6:32)
Filter records with simple "where" (7:44)
Filter records with more sophisticated "where" (7:40)
Sort data with "order by" (9:44)
Conceptual introduction to using "group by" and "over" (3:56)
Summarize data with "group by" (8:04)
Summarize data with "over" (7:11)
Format output to make it look more professional (8:24)
Understand order of execution of queries (3:28)
Creating and Changing Tables
Make a table to represent an entity (6:20)
Add records from a csv file to fill the table (7:35)
Insert records into a table using SQL (8:41)
Delete existing records (5:58)
Update existing records (8:23)
Create an index to prevent the insertion of duplicate records (6:15)
Understanding varchar and nvarchar in more detail (4:07)
Making SQL Server work with Asp.Net
Add IIS Web Server and configure SQL Server (5:28)
Get Visual Studio and get IIS working with SQL Server (15:14)
Create a dynamic web page (6:12)
Edit, Create and Delete records (11:04)
Search and view restricted results (5:11)
Work with the grid view control to sort and edit templates (7:56)
Create and run a stored procedure from a web page (11:40)
Joining tables
Restore Adventure Works 2014 From Backup (1:56)
Finding matching records using inner joins (9:53)
Find matching records using left outer joins (6:52)
Add a new website to IIS and copy out records with an inner join (7:48)
Add Validation (14:34)
Final Thoughts
Next possible steps (1:07)
Find matching records using left outer joins
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock