Videos

• Install SQL Server Express
• Restore a Database - Sample DB
• Attach a Database - AdventureWorks

Assignments

Videos

• Select and Where pt 1
• Select and Where pt 2

Assignments

Videos

• Logic Operators and Precedence
• Sorting

Assignments

Videos

• Database Diagrams
• Cross Joins
• Join On
• Join with Non-equality Operator
• Three Table Join
• Outer Joins
• Self Joins

Assignments

Videos

• Schemas
• Top-N, Offset and Fetch
• Select Into
• Union, Intersect, Except

Assignments

Videos

• Aggregation
• Group By and Having
• SQL Aggregation Assignment

Assignments

Videos

• Join Review
• Query Editor
• Subqueries
• Multi-Valued Subqueries
• Recognizing Correlated Subqueries

Assignments

Videos

• Database Integrity
• Conceptual to Physical Model
• T-SQL Data Types
• Create Table
• Alter Table
• GUI Tables
• Primary Keys
• DDL Assignment

Assignments

Videos

• Table Indexes
• Foreign Keys
• Foreign Keys GUI
• FK and Index Assignment

Assignments

Videos

• Insert
• Insert with a Query
• Update
• Delete
• CRUD Assignment

Assignments

Videos

• Transactions and Locking
• Types of Backups
• Backup and Restore Commands
• Backup and Restore GUI
• Backup and Restore Assignment

Assignments

Videos

• Views
• Stored Procedures
• Scalar Functions
• Table-Valued Functions

Assignments

Videos

• Create Windows Account
• Server Logins
• Database Users
• Roles
• Built-In and Custom Roles
• Grant and Revoke

Assignments

Videos

• Flat File Databases
• CSV Files
• SQL vs No SQL vs Mongo DB
• Naming Conventions
• Three tier Architecture
• Normalization Summary
• Types of Backups
• Troubleshooting
• Software Development Life-Cycle
• Full Normalization Videos

Assignments