Course curriculum

    1. Welcome!

    2. Link to community

    3. Installing PostgreSQL + PgAdmin & Uploading Data

    4. Troubleshooting the SQL Installation or Importing Data

    5. SQL Installation Tracker

    6. What Do Clinical Data Analysts Do?

    1. PgAdmin Environment

    2. The SELECT and FROM Statements

    3. Practice Questions: SELECT/FROM Statement

    4. WHERE clause

    5. Practice Questions: WHERE Clause

    6. Clinical Data Fundamentals

    7. Data Types

    8. Creating and Maintaining Tables

    9. GROUP BY & HAVING Clauses

    10. ORDER BY Statement

    11. Practice Questions: GROUP BY & HAVING

    12. Lesson File for Lab 1

    13. Lab 1 - SQL Basics with HAI Data

    1. Normalization

    2. Data Dictionary

    3. Practice Questions: Primary / Foreign Keys

    4. Inner, Left, and Right Joins

    5. Practice Questions: JOINs

    6. Cardinality

    7. Chained Joins

    8. Many-to-Many Relationships

    9. Unions

    10. Case Statements

    11. SQL Functions

    12. Lab 2 - Exploring Clinical Data with Joins

    1. Common Table Expressions, Subqueries, and Views

    2. Test your understanding! - CTEs

    3. Partitions

    4. Practice Questions: Partition Statements

    5. Subquery Mini-Lesson

    6. Full Outer Joins and Self Joins

    7. What Are Readmissions?

    8. Lab 3: Building Patient Populations and Metrics

    1. The "Software" Development Lifecycle for Data Analysts

    2. How I Use ChatGPT

    3. Building a Data Extract

    1. Building Your First Dashboard!

    2. (Optional) Tableau Desktop Features

    3. (Optional) Tableau Joins & Relationships

    4. Basic Data Visualization Concepts

    5. Calculations in Tableau

    6. Lab 4: Exploring Complications & Deaths using Tableau

About this course

  • $800.00
  • 96 lessons
  • 26 hours of video content