Data Analytics: Intro to SQL using Healthcare Data 

Course Introduction

Welcome!

How to Private Message the Instructor

Introduction to SQL

Database Management Systems

Healthcare Database

SQL Cheat Sheet

Quick Note about software download

Downloading Microsoft SQL Server Management Studio

Link: Download Microsoft SQL Server Management Studio

Section 3 Introduction

Connecting to Server in SSMS

Troubleshoot: Finding Hostname and Servername

Creating Databases

Code: Creating Databases

Dropping Databases

Code: Dropping Databases

Using Databases

Code: Using Databases

Self Evaluation

Code: Self Evaluation

Self Evaluation Review

Code: Self Evaluation Review

Section 4 Introduction

Table Structures

Data Types

Creating Tables

Code: Creating Tables

Dropping Tables

Code: Dropping Tables

Inserting Data

Code: Inserting Data

Inserting Multiple Rows of Data

Code: Inserting Multiple Rows of Data

Tables with null values

Code: Tables with null values

Creating Tables with Primary Keys

Code: Creating Tables with Primary Keys

If Object_ID

Code: If Object_ID

Self Evaluation

Code: Self Evaluation

Self Evaluation Review

Code: Self Evaluation Review

Section 5 Introduction

**NOTE**

Select Statements, Top 100

Code: Select Statements, Top 100

Distinct Statements

Code: Distinct Statements

Where Clause

Code: Where Clause

And, Or, Not, In, Between within a Where clause

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

Like, Null, Not Null within a Where Clause

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

Order by

Order by (part 2)

Code: Order by

Aggregate Functions - Count

Code: Aggregate Functions - Count

Group by

Code: Group by

Aggregate Functions - Min and Max

Code: Aggregate Functions - Min and Max

Aggregate Functions - Sum

Code: Aggregate Functions - Sum

Aggregate Functions - Avg

Code: Aggregate Functions - Avg

Alias Names

Code: Alias Names

Concatenation

Code: Concatenation

Additional Where and Having Clause Operators

Code: Additional Where and Having Clause Operators

Having

Code: Having

Case

Code: Case

Self Evaluation

Code: Self Evaluation

Self Evaluation Review

Code: Self Evaluation Review

Section 6 Introduction

Code: Section 6

Updating Data

Code: Updating Data

Deleting Data

Code: Deleting Data

Truncate Tables

Code: Truncate Tables

Alter Tables

Code: Alter Tables

**NOTE**

Select Into

Code: Select Into

Select Into with Conditions

Code: Select Into with Conditions

Temporary Tables

Code: Temporary Tables

Self Evaluation

Code: Self Evaluation

Self Evaluation Review

Code: Self Evaluation Review

Section 7 Introduction

Primary Key Review

Relational Databases

Data Relationships

Setting up our Practice Data

**NOTE**

Inner Joins

Code: Inner Joins

Left Joins

Code: Left Joins

Right Joins

Code: Right Joins

Foreign Keys

Foreign Key Constraints

Code: Foreign Key Constraints

Review Cheat Sheet

No Self Evaluation

Section 8 Introduction

Round

Code: Round

Convert and Cast

Code: Convert and Cast

Format

Code: Format

Upper and Lower

Code: Upper and Lower

Isnull

Code: Isnull

Nullif

Code: Nullif

Inner Queries

Code: Inner Queries

Stored Procedures

Code: Stored Procedures

Updating Data using another Table

Code: Updating Data using another Table

Constraints

Code: Constraints

Left and Right

Code: Left and Right

Trim

Code: Trim

Section 8 Conclusion

Section 9 Introduction

Healthcare Example using data

Review Entity Relationship Diagram

Healthcare_DB ERD

Data Dictionary

Healthcare_DB Review in Excel

Create Healthcare Database and Tables

Upload data into SSMS

Troubleshoot: Uploading data via Import Wizard not working

Creating Primary and Foreign Key Relationships

Do not Drop Healthcare_DB or Tables

Healthcare Example in SQL

Code: Healthcare Example in SQL

Introduction to Healthcare Finance

Link to Healthcare Finance Course

Healthcare Finance Example