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