Data Analytics: Intro to SQL using Healthcare Data

Course Curriculum

Chapter 1: Introductions

Lecture 1: Course Introduction

Lecture 2: Welcome!

Lecture 3: How to Private Message the Instructor

Lecture 4: Introduction to SQL

Lecture 5: Database Management Systems

Lecture 6: Healthcare Database

Lecture 7: SQL Cheat Sheet

Chapter 2: Downloading Software

Lecture 1: Quick Note about software download

Lecture 2: Downloading Microsoft SQL Server Management Studio

Lecture 3: Link: Download Microsoft SQL Server Management Studio

Chapter 3: Servers and Databases

Lecture 1: Section 3 Introduction

Lecture 2: Connecting to Server in SSMS

Lecture 3: Troubleshoot: Finding Hostname and Servername

Lecture 4: Creating Databases

Lecture 5: Code: Creating Databases

Lecture 6: Dropping Databases

Lecture 7: Code: Dropping Databases

Lecture 8: Using Databases

Lecture 9: Code: Using Databases

Lecture 10: Self Evaluation

Lecture 11: Code: Self Evaluation

Lecture 12: Self Evaluation Review

Lecture 13: Code: Self Evaluation Review

Chapter 4: Creating and Inserting into Tables

Lecture 1: Section 4 Introduction

Lecture 2: Table Structures

Lecture 3: Data Types

Lecture 4: Creating Tables

Lecture 5: Code: Creating Tables

Lecture 6: Dropping Tables

Lecture 7: Code: Dropping Tables

Lecture 8: Inserting Data

Lecture 9: Code: Inserting Data

Lecture 10: Inserting Multiple Rows of Data

Lecture 11: Code: Inserting Multiple Rows of Data

Lecture 12: Tables with null values

Lecture 13: Code: Tables with null values

Lecture 14: Creating Tables with Primary Keys

Lecture 15: Code: Creating Tables with Primary Keys

Lecture 16: If Object_ID

Lecture 17: Code: If Object_ID

Lecture 18: Self Evaluation

Lecture 19: Code: Self Evaluation

Lecture 20: Self Evaluation Review

Lecture 21: Code: Self Evaluation Review

Chapter 5: Retrieving Data

Lecture 1: Section 5 Introduction

Lecture 2: **NOTE**

Lecture 3: Select Statements, Top 100

Lecture 4: Code: Select Statements, Top 100

Lecture 5: Distinct Statements

Lecture 6: Code: Distinct Statements

Lecture 7: Where Clause

Lecture 8: Code: Where Clause

Lecture 9: And, Or, Not, In, Between within a Where clause

Lecture 10: Code: And, Or, Not, In, Between within a Where Clause

Lecture 11: Like, Null, Not Null within a Where Clause

Lecture 12: Code: Like, Null, Not Null within a Where Clause

Lecture 13: Order by

Lecture 14: Order by (part 2)

Lecture 15: Code: Order by

Lecture 16: Aggregate Functions – Count

Lecture 17: Code: Aggregate Functions – Count

Lecture 18: Group by

Lecture 19: Code: Group by

Lecture 20: Aggregate Functions – Min and Max

Lecture 21: Code: Aggregate Functions – Min and Max

Lecture 22: Aggregate Functions – Sum

Lecture 23: Code: Aggregate Functions – Sum

Lecture 24: Aggregate Functions – Avg

Lecture 25: Code: Aggregate Functions – Avg

Lecture 26: Alias Names

Lecture 27: Code: Alias Names

Lecture 28: Concatenation

Lecture 29: Code: Concatenation

Lecture 30: Additional Where and Having Clause Operators

Lecture 31: Code: Additional Where and Having Clause Operators

Lecture 32: Having

Lecture 33: Code: Having

Lecture 34: Case

Lecture 35: Code: Case

Lecture 36: Self Evaluation

Lecture 37: Code: Self Evaluation

Lecture 38: Self Evaluation Review

Lecture 39: Code: Self Evaluation Review

Chapter 6: Jumping Back to Inserting Data (Section 4)

Lecture 1: Section 6 Introduction

Lecture 2: Code: Section 6

Lecture 3: Updating Data

Lecture 4: Code: Updating Data

Lecture 5: Deleting Data

Lecture 6: Code: Deleting Data

Lecture 7: Truncate Tables

Lecture 8: Code: Truncate Tables

Lecture 9: Alter Tables

Lecture 10: Code: Alter Tables

Lecture 11: **NOTE**