Program Curriculum

  • 1

    Introduction

    • Welcome

    • Career Focused Program
  • 2

    How to Learn

    • How this course is different

    • Effective learning methods
  • 3

    SQL

    • Introduction to SQL

    • Part 1: Introduction to Databases

    • Part 1 Review

    • Part 2: SELECT Command

    • Part 2 Practice

    • Part 2 Review

    • Part 3: Beginner SQL Commands

    • Part 3 Practice

    • Part 3 Review

    • Part 4: Joining Data Tables

    • Part 4 Practice

    • Part 4 Review

    • Part 5: Creating Data Tables

    • Part 5 Practice

    • Part 5 Review

    • Part 6: Inserting Data

    • Part 6 Practice

    • Part 6 Review

    • End of Section Quiz

    • SQL Continued Learning
  • 4

    Python

    • Introduction to Python

    • How to Learn Python

    • Part 1: First Python Code

    • Part 1 Review Quiz

    • Part 2: Python for Data Analysis

    • Part 2: Structuring Data with Python

    • Part 2: Data Analysis Functions

    • Part 2 Practice

    • Part 2 Review Quiz

    • Part 3: Python for Automation

    • Part 3: Report Automation

    • Part 3 Practice

    • Part 3 Quiz

    • Python vs Excel

    • End of Section Quiz

    • Python Continued Learning
  • 5

    VBA

    • Introduction to VBA

    • VBA Use Cases

    • Part 1: Setting up VBA

    • Part 2: Formatting with VBA

    • Part 2 Code Review

    • Part 3: Report automation

    • Part 3 Code Review

    • Part 4: Message Boxes

    • VBA Summary

    • VBA Jobs

    • End of Section Quiz
  • 6

    Continued Learning

    • Continued Learning

    • Thank you