A step by step introduction to the concept of Databases and Introduction to SQL Querying.
What you will learn
Query a database, Create Tables and Databases and be proficient with basic SQL querying
English
language
Content
Introduction and Setup
Lecture 1: Introduction to Databases
Installing / Setting up Environment / SQL Management Studio
Introduction to Querying
Creating your First SQL Table
Installing Sample Database (Adventure Works) and Querying
Deep Dive into Querying
Lets Start Writing some SQL code
Deep Dive into SQL Querying
SQL Joins
SQL Joins (1/2)
SQL Joins (2/2)
Dates / Aggregation and String Functions
TSQL Date Functions
TSQL Aggregation and String Functions
Lecture 11: Conclusion