Program Curriculum

6-Week Bootcamp in Python and SQL

  • 2
    Part 1: Python Programming
    • Overview of Python Programming
    • Downloadable Python Resource
    • Additional Resources
    • Git & Github Fundamentals
  • 3
    1A: Introduction to Python
    • Pythion as a Language
    • Elements of Python
    • Installing Python on Windows
    • Installing a Python on a Mac
    • Assignment : Currency Converter
  • 4
    1B: Variables, Expressions, Statements
    • Constants and Variables
    • Python Expressions
  • 5
    1C: Conditional Execution and Functions
    • Overview of Functions
    • Extended If Statements
    • If Statements
    • Building Functions
    • Assignment : Monopoly Dice Game
  • 6
    1D: Loops and Iterations
    • While Loops
    • For Loops
    • Loop Idioms
    • Applying Loops
    • Assignment : Rock Paper Scissors
  • 7
    2A: Python Strings
    • Strings Data Type
    • Strings Methods
    • Assignment : Password Generator
  • 8
    2B: Python File Handling
    • Overview of Files
    • File Handle as Sequence
  • 9
    2C: Python Lists and Tuples
    • Overview of Lists
    • List Methods
    • List-String Relationships
    • Overview of Tuples
    • Tuple Methods
    • Assignment : Pascal Triangle
  • 10
    2D: Python Dictionaries
    • Overview of Dictionaries
    • Dictionary Methods
    • Applying Dictionaries
    • Assignment : Hangman Game
  • 11
    3A: Object-Oriented Programming (OOP)
    • Objects
    • Classes
    • Object Lifecycle
    • Inheritance
    • Assignment : Snakes and Ladders Game
  • 12
    Python Projects
    • Project : Youtube Downloader
    • Project : Pomodoro Desktop Notifier
  • 13
    4A: Introduction to SQL
    • Windows Installation
    • MAC OS installation
    • Introduction
    • Databases Introduction
    • Tables and Keys
    • SQL Basics
  • 14
    4B: 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
  • 15
    5A: 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
  • 16
    Introduction to Excel (Data Analysis – Excel) – Week 6
    • The Beginners Guide to Excel
    • Excel Intermediate tricks , navigation and tips
    • Freeze Panes
    • Find and Replace
    • Auto Fill Handle
    • Flash Fill
    • Excel Number Formats
  • 17
    Excel Functions (Data Analysis – Excel) – Week 6
    • Beginners Guide to Functions and formulas
    • SUM IFs
    • Statistical Functions in Excel
    • Excel Financial Functions
  • 18
    Excel Data Management ( Data Analysis - Excel ) - Week 6
    • Conditional Formatting In-depth
    • Excel Relative and Absolute Cell Referencing
    • Excel Index and Match
    • Excel V Look Ups- Basics
    • Excel H- Look Ups
  • 19
    Excel Data Manipulation (Data Analysis - Excel) - Week 7
    • Excel - Dealing with Duplicates
    • Unique Data
    • Excel Conditional Formatting In-depth
    • Excel Common Errors
    • Excel Common Errors Part 2
    • Excel Filtering
    • Excel Advanced Filtering
  • 20
    Excel Data Visualization(Data Analysis - Excel ) Week 7
    • Simple Charts
    • Intro to Dashboards
    • Excel Intermediate Dashboards
    • Excel Quick and Simple Charts Tutorial
  • 21
    Excel Data Summarization Techniques (Data Analysis - Excel) - Week 7
    • Pivot Tables
    • Advanced Excel Recommnended Pivot Tables
  • 22
    Excel Sensitivity Analysis (Data Analysis - Excel ) Week 7
    • What if Analysis
    • Goal Seek
  • 23
    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_