Introduction: Get the Needed Software
  • Get SQL Server 2014 Express
  • Get Microsoft Visual Studio
  • Configure the Layout of Panels in the Management Studio and Visual Studio
Querying Basics
  • Create a Table and Write a Simple Query and Display the Results
  • Simple Queries
  • Write a Query with a Where Restriction
  • Adding a Simple Where Restriction
  • Write a Query with a Where and an Order By
  • Order By Clauses
  • Filtering with Where and Between
  • Using Between
  • Aliasing Columns
  • Aliasing Columns
  • Aliasing Computed Columns
  • Computed Values
  • Use The Query Designer
  • Query Designer
  • Make an ASP.NET Web Page with SQL Server
  • ASP.NET Pages
  • Summarize Blocks of Records with Group By
  • Group By
  • Having Clause
  • Having Clause
  • Select Into
  • Select Into
  • Add Multiple Parameters to an ASP.NET Page
  • Multiple Parameters
Table Manipulation
  • Table Creation and Data Insertion
  • Table creation and Data Insertion
  • Updating Records
  • Update Records
  • ASP.NET Page with Updating and Deleting
  • Updating, Deleting and Inserting Through Web Pages
  • 1st Normal Form
  • First Normal Form
  • Second Normal Form
  • Second Normal Form
  • Third Normal Form
Table Joins
  • Inner Join
  • Inner Joins with Editor Window and Where Statements
  • Inner Joins
  • Left Join
  • Left Joins with Editor and Where Statement
  • Left Joins
  • Right Join
  • Right Joins with Query Editor and Filtering Conditions
  • Right Joins
  • Full Joins with The Query Editor
  • Full Joins
Build an ASP.NET Page With Multiple Tables and Controls
  • Connect Gridview to Tables with C#
  • Create a Query Editor with C#
Create an XML Powered ASP.NET Page
  • Create a Table Suited For XML Output
  • Create a Page With a Control That Connects to the XML Table
  • XML Tables
Using SQL Server Functions and Operators
  • In Logical Operator
  • Where with Like
  • Like, And and In
  • Scalar Functions
  • Scalar Functions
  • Aggregate Functions
  • Aggregating Functions
  • Summarzing Records with Over
  • Over Statement
Subqueries
  • Subqueries in Select Clauses
  • Subqueries in Selects
  • Subqueries in From
Stored Procedures and Programming Constructs
  • Write and Execute a Simple Stored Procedure
  • Simple Stored Procedures
  • Part 1: Write a Parametrized Procedure
  • Part 2: Asp.NET Page Powered by Parametrized Store Procedure
  • Procedures with Parameters
  • Add IF/Else Blocks
  • If/Else Blocks
  • Case and When Statements with Functions
  • Case and When
  • While Blocks, Variables
  • While, Variables
  • Stored Procedures with Output Parameters
  • Try/Catch Error Handling
  • Try/Catch
  • Comparing Values Between Records with the Lag Function
  • Common Table Expressions
  • Using the Lead Function with Grouped Data and CTE's
  • Lead and Lag Functions
  • CTE with Inner Join and Aggregating Functions and CSV Files
  • Nesting Functions and Pivoting Tables
  • Nesting Functions and Pivoting Tables
User Defined Functions
  • Scalar Valued Functions
  • User Defined Scalar Functions
  • Table valued Functions