Chapters

• 1. Introduction
• 2. How Programs Work
• 3. How To Write Code
• 4. Terminal
• 5. Data and Variables
• 6. Making Decisions With Conditionals
• 7. Repeating Things With Loops
• 8. Stringing Characters Together
• 9. Lists Keep Things in Order
• 10. Errors and Debugging
• 11. What’s Your Function
• 12. Python Dictionaries and Tuples
• 13. Introduction To Data
• 14. Exploratory Data Analysis
• 15. EDA With Python Part 2
• 16. Cleaning Data
• 17. Data Manipulation
• 18. Data Visualization with Python
• 19. SQL Part 1 - Introduction and Azure Data Studio
• 20. SQL Part 2 - String and Date Functions
• 21. SQL Part 3 - Joins
• 22. SQL Part 4 - Subqueries, UNION, INTERSECT, EXCEPT
• 23. SQL Part 5 - Schemas and CRUD Operations
• 24. Working with Databases in Python
• 25. Tableau Part 1 - Introduction to Visualization
• 26. Tableau Part 2 - Data Preparation
• 27. Tableau Part 3
• 28. Tableau Part 4 - Stories and Dates
• 29. Introduction to Statistics and Data Modeling
• 30. Data Modeling Part 2: Linear Regression

• Index

Studios

• 7.10. Studio: Goal Setting and Getting into the Right Mindset
• 9.11. Studio: Strings and Lists
• 10.8. Studio: Errors and Debugging
• 11.11. Studio: Functions
• 12.9. Studio: Mad Dictionaries
• 13.3. Studio: Introduction To Data
• 14.3. Studio: Exploratory Data Analysis
• 15.3. Studio: EDA With Python Part 2
• 16.3. Studio: Cleaning Data
• 17.3. Studio: Data Manipulation
• 18.3. Studio: Data Visualization with Python
• 19.3. Studio: SQL Part 1 - Introduction and Azure Data Studio
• 20.5. Studio: SQL Part 2 - String and Date Functions
• 21.3. Studio: SQL Part 3 - Joins
• 22.3. Studio: SQL Part 4 - Subqueries, UNION, INTERSECT, EXCEPT
• 23.3. Studio: SQL Part 5 - Schemas and CRUD Operations
• 24.3. Studio: Working with Databases in Python
• 25.4. Studio: Tableau Part 1 - Introduction to Visualization
• 26.3. Studio: Tableau Part 2 - Data Preparation
• 27.3. Studio: Tableau Part 3
• 28.3. Studio: Tableau Part 4 - Stories and Dates
• 29.3. Studio: Introduction to Statistics and Data Modeling
• 30.3. Studio: Data Modeling Part 2: Linear Regression

Assignments

• Assignment #1: Candidate Testing
• Assignment #2: Call Center Cleanup
• Assignment #3: 9 to 5
• Assignment #4: Final Project
• Checkpoint 1: Choose your Data
• Checkpoint 2: EDA
• Checkpoint 3: Cleaning Data
• Checkpoint 4: Tableau Story
• Checkpoint 5: Modeling Data
• Final Project Presentations

Appendices

• Best Practices: Learning To Code
• Setting Up Software for this Class
• Terminal Commands
• Jupyter Notebooks
• Common Python String Methods
• Common Python List Methods
• Common Python Dictionary Methods
• Exercise Solutions