Introduction to Databases and SQL Querying

Description

In this course, you will :

• Perform a database query, Create tables and databases, as well as be familiar with basic SQL querying.

Syllabus :

1. Introduction and Setup

• Lecture 1: Introduction to Databases
• Installing / Setting up Environment / SQL Management Studio

 

2. Introduction to Querying

• Creating your First SQL Table
• Installing Sample Database (Adventure Works) and Querying

 

3. Deep Dive into Querying

• Lets Start Writing some SQL code
• Deep Dive into SQL Querying

 

4. SQL Joins

• SQL Joins

 

5. Dates / Aggregation and String Functions

• TSQL Date Functions
• TSQL Aggregation and String Functions

Show more