Program Curriculum

4-6 Week Bootcamp in SQL and Spreadsheets(Excel)

  • 1
    Welcome to the Course
  • 2
    Introduction to SQL
    • Windows Installation
    • MAC OS installation
    • Introduction
    • Databases Introduction
    • Tables and Keys
    • SQL Basics
  • 3
    SQL Programming
    • Creating Tables - SQL - Tutorial 6
    • Inserting Data - SQL - Tutorial 7
    • Constraints - SQL - Tutorial 8
    • Update Delete SQL Tutorial 9
    • Basic Queries SQL Tutorial 10
    • Quiz 1
    • Company Database Intro SQL Tutorial 11
    • Creating Company Database SQL Tutorial 12
    • More Basic Queries SQL Tutorial 13
    • Functions SQL Tutorial 14
    • WIldcards SQL Tutorial 15
    • Union SQL Tutorial 16
    • Joins SQL Tutorial 17
    • Quiz 2
    • Nested Queries SQL Tutorial 18
    • On Delete SQL Tutorial 19
    • SQL PROJECT 1
    • Triggers SQL Tutorial 20
    • ER Diagrams Intro SQL Tutorial 21
    • Designing an ER Diagram SQL Tutorial 22
    • Converting ER Diagrams to Schemas SQL Tutorial 23
    • Quiz 3
    • SQL PROJECT 2
  • 4
    Bonus Content - Manipulating SQL Databases with Python
    • Getting Started with MySQL
    • Creating our Database and Table
    • Quiz 4
    • Populating our Database and Table
    • Selecting and Getting Data
    • Query Conditions with WHERE and Wildcards
    • Updating Entries and Limiting Queries
    • Ordering our Queries and Results
    • Deleting Entries and Dropping Tables
    • Quiz 5
  • 5
    Introduction to Excel (Data Analysis – Excel)
    • The Beginners Guide to Excel
    • Excel Intermediate tricks , navigation and tips
    • Freeze Panes
    • Find and Replace
    • Auto Fill Handle
    • Flash Fill
    • Excel Number Formats
  • 6
    Excel Functions (Data Analysis – Excel)
    • Beginners Guide to Functions and formulas
    • SUM IFs
    • Statistical Functions in Excel
    • Excel Financial Functions
  • 7
    Excel Data Management ( Data Analysis - Excel )
    • Conditional Formatting In-depth
    • Excel Relative and Absolute Cell Referencing
    • Excel Index and Match
    • Excel V Look Ups- Basics
    • Excel H- Look Ups
  • 8
    Excel Data Manipulation (Data Analysis - Excel)
    • Excel - Dealing with Duplicates
    • Unique Data
    • Excel Conditional Formatting In-depth
    • Excel Common Errors
    • Excel Common Errors Part 2
    • Excel Filtering
    • Excel Advanced Filtering
  • 9
    Excel Data Visualization(Data Analysis - Excel )
    • Simple Charts
    • Intro to Dashboards
    • Excel Intermediate Dashboards
    • Excel Quick and Simple Charts Tutorial
  • 10
    Excel Data Summarization Techniques (Data Analysis - Excel)
    • Pivot Tables
    • Advanced Excel Recommnended Pivot Tables
  • 11
    Excel Sensitivity Analysis (Data Analysis - Excel )
    • What if Analysis
    • Goal Seek
  • 12
    Excel Added
    • Excel WhatIf Analysis with Scenario Manager and Goal Seek
    • MS Excel - Advanced Filters
    • Advanced Excel - Creating Pivot Tables in Excel
    • MS Excel - Filtering Data
    • Fixing Common Excel Errors - Part 2_ NULL, NUM & #####
    • Fixing Common Excel Errors - Part 1_ DIV_0, N_A, & NAME_
    • Beginner's Guide to Excel Dashboards
    • Intermediate Guide to Excel Dashboards
    • Advanced Excel - Using _Recommended Pivot Tables_