Introduction to Databases and SQL Querying
Query a database, Create Tables and Databases and be proficient with basic SQL querying
Requirements
There is absolutely no pre-requisites for the course. We will walk through very basic installation to setting up your environment to creating your first table and writing queries against it. All videos are recorded in Windows OS. You can however follow this course on MAC/Linux, if you have a Win VM setup
Description
This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.
Who this course is for:
This course is for beginners with absolutely no experience is database. The course will make you familiar with SQL Syntax and introduce you to the concept of databases. No Prior Programming experience is required. This course is probably not for you if you’re looking to learn more advanced and complex queries
Course content
5 sections • 11 lectures • 2h 17m total length
Introduction and Setup2 lectures • 22min
- Lecture 1: Introduction to Databases
10:51
- Installing / Setting up Environment / SQL Management Studio
11:04
Introduction to Querying2 lectures • 17min
- Creating your First SQL Table
12:13
- Installing Sample Database (Adventure Works) and Querying
05:15
Deep Dive into Querying2 lectures • 31min
- Lets Start Writing some SQL code
17:41
- Deep Dive into SQL Querying
13:45
SQL Joins2 lectures • 37min
- SQL Joins (1/2)
13:35
- SQL Joins (2/2)
22:56
Dates / Aggregation and String Functions3 lectures • 30min
- TSQL Date Functions
10:51
- TSQL Aggregation and String Functions
14:57
- Lecture 11: Conclusion
04:03
