Introduction

Download and Install SQL Server Express 2017

Connect to Database Instance and Create a Database

Drop or Remove Database

What is a Database Table?

Create an SQL Database Table

Create an SQL Database Table Using Management Studio

Select Records With SQL Scripts

Select Records With Management Studio

Insert Data into the Table with SQL Scripts

Insert Data into the Table with Management Studio

Update Data in the Table with SQL Scripts

Update Data in the Table with Management Studio

Delete Records with SQL Scripts

Delete Records with Management Studio

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

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

SQL Views

Scalar Valued SQL Functions

Inline Table Valued SQL Functions

Multi Statement Table Valued Functions

Stored Procedures

SQL Table Triggers

Database Scripting, Backup and Restore