Phase3-python.md

Flatiron School Phase 3 Python Curriculum

Welcome to Phase 3!

• Welcome to Phase 3
• Installing Python on MacOS
• Verify and Troubleshoot your MacOS Environment Setup
• Windows WSL2 Python Installation
• Verify and Troubleshoot your WSL2 Environment Setup

Python Fundamentals

• Intro to Python
  • Running Python Code
• Common Data Types
  • Reading Python Error Messages
  • Functions in Python
  • Debugging with ipdb
• Variable Scope
• Indentation in Python
• Control Flow: Operators
  • Control Flow: Conditional Statements
  • Control Flow: Loops
• Conclusion to Python Fundamentals

Data Structures

• Intro to Data Structures
  • Sequences
  • List Comprehension and Generator Expressions
• Dictionaries
• Sets
  • Data Structures Lab
• Conclusion to Data Structures

Python Practice

• Parrot Lab
• Countdown to Midnight Lab
• List CRUD Lab
• Badges and Schedules Lab
• Oxford Comma Lab
• Deli Counter Lab
• Cartoon Collections Lab
• {"basket": "ball"}

Object Orientation in Python

• Introduction to Object-Oriented Programming
• Defining Object-Oriented Programming
• Classes and Instances
  • Instance Methods
  • Object Initialization
  • Attributes and Properties
  • Putting It All Together: Object-Oriented Programming Lab
• Principles of Object-Oriented Design
  • Anagram Detector Lab
  • Counting Sentences Lab
  • Cash Register Lab
• Conclusion to Object-Oriented Programming Basics

Object Inheritance in Python

• Intro to Object Inheritance
  • Defining Object Inheritance
• Super
  • Object Inheritance Lab, Part One
  • Object Inheritance Lab, Part Two
• Decorators
• Mini Lesson: Lambda Functions
• Conclusion to Object Inheritance

Class Attributes and Class Methods in Python

• Intro to Class Attributes and Class Methods
• Defining Class Attributes and Class Methods
• Remembering Objects
  • Class Attributes and Methods Lab
• Conclusion to Class Attributes and Class Methods

Configuring Python Applications

• Intro to Configuring Python Applications
• Import
• Intro to File IO
  • File IO Lab
• Environment Setup
• PyPi and Pip
  • Environment Lab
• Python Scripting

Regular Expressions

• Intro to Regular Expressions
• RegEx Basics
• The "re" Module
  • RegEx Validations Lab
  • Email Parser Lab
  • BONUS: RegEx Matching Lab
• Conclusion to Regular Expressions

SQL Fundamentals

• Intro to SQL
  • Video: Intro to SQL
• Setting up SQLite
• Database Basics
• Writing Database Commands to a File
• SQLite Data Types
  • Video: SQL SELECT
  • Video: SQL CREATE TABLE
  • Video: SQL INSERT
  • Video: SQL UPDATE and DELETE
• CRUD Operations in SQL
• SQL Queries
  • Organizing Bears Lab
• Conclusion to SQL Fundamentals

Table Relations in SQL

• Intro to Table Relations in SQL
• Relational Database Basics
• Associating Tables with Foreign Keys
  • Video: SQL Joins
• SQL Joins
• Creating Join Tables
• Conclusion to Table Relations in SQL

Object-Relational Mapping

• Intro to Object-Relational Mapping
• Defining Object-Relational Mapping
  • Mapping Python Classes to a Database
• Mapping Database Records to Python Objects
  • Putting it All Together: ORMs Lab
• Conclusion to Object-Relational Mapping

Using SQLAlchemy

• Intro to SQLAlchemy
  • Defining a Schema with SQLAlchemy ORM
• Create, Read, Update, and Delete with SQLAlchemy
  • Translating from ORMS to SQLAlchemy Lab
  • Migrations and Alembic
  • Manual Migrations and Downgrades
  • Working with Seed Data
• Conclusion to SQLAlchemy

SQLAlchemy Relationships

• Intro to SQLAlchemy Relationships
  • One-to-One and One-to-Many Relationships
  • Many-to-Many Relationships
• Conclusion to SQLAlchemy Relationships
  • Phase 3 Mock Code Challenge: Freebie Tracker
  • Phase 3 Mock Code Challenge: Theater Work

Data Structures and Algorithms

• Introduction to Data Structures and Algorithms
• Using Data Structures
  • Set Data Structure Code Along
• Stack Data Structure
  • Stack Lab
• Singly Linked List Data Structure
• Doubly Linked List Data Structure
• Tree Data Structure
  • Tree Traversal

Phase 3 Project

• Intro to CLIs
  • Phase 3 Project: CLI