Programming for Data Science with Python

An Introduction to the course and using the Parch & Posey sales database to solve real-world business questions.

Explore SQL basics, its importance for data analysis, business use cases, database structure, and an overview of popular SQL databases with hands-on practice.

Learn how to interpret Entity Relationship Diagrams (ERDs) to visualize tables, columns, and relationships in a relational database.

Learn SQL basics by understanding key statements like SELECT and FROM, practicing queries, and following best practices for formatting and execution in a SQL workspace environment.

Learn how to use the LIMIT clause in SQL to restrict the number of rows returned in query results, making data exploration faster and more manageable.

Learn to use the SQL ORDER BY clause to sort query results by one or multiple columns, in ascending or descending order, with practical query exercises and solutions.

Learn to use the SQL WHERE clause to filter table data based on numeric or text conditions, using operators like =, !=, >, <, and practice with real-world queries.

Learn how to use arithmetic operators in SQL to create derived columns, perform calculations in queries, and apply order of operations for accurate results.

Learn how to use SQL's LIKE and IN operators to filter text and numeric data efficiently, enabling flexible database queries with wildcards and value lists.

Learn to use AND and BETWEEN operators in SQL to filter data with multiple conditions and ranges, practicing queries on real tables and understanding inclusivity of endpoints.

Learn how to use SQL's NOT and OR operators to filter data, combine conditions, and query for records that do not or do match given criteria, with practical examples and exercises.

Review key SQL commands, syntax, and concepts such as SELECT, FROM, WHERE, ORDER BY, LIKE, and data structure. Reinforce skills to write and understand basic SQL queries.

Gain an understanding of the definition of JOINS and database normalization and learn why they are needed.

Learn how to use INNER JOINs in SQL to combine data from multiple tables, write JOIN queries, and specify columns from different tables using the ON clause.

Learn how to use INNER, LEFT, and RIGHT JOINs in SQL to combine data from multiple tables, including filtering joins and understanding NULLs in join results.

Explore advanced SQL JOINs, primary and foreign keys, multi-table joins, and aliases to efficiently combine and analyze relational database tables.

Recap key concepts learned in this lesson.

An overview of the content that will be learned in Lesson 3.

Learn how NULLs represent missing data in SQL, how they differ from zeros, and how to identify or exclude them using IS NULL or IS NOT NULL in queries and aggregations.

Learn how to use SQL's COUNT function to count rows, understand the difference between COUNT(*) and COUNT(column), and see how NULL values affect results.

Learn how to use the SQL SUM function to total numeric columns, handle NULL values, and perform aggregations across data for inventory analysis and sales calculations.

Learn to use SQL's MIN, MAX, and AVG aggregate functions to find minimums, maximums, and averages, while understanding their handling of NULLs and practical business applications.

Learn how to use GROUP BY in SQL to aggregate data within subsets, group by multiple columns, and combine GROUP BY with ORDER BY for insightful data analysis.

Learn how to use DISTINCT in SQL SELECT statements to retrieve unique rows across specified columns, with practical examples and exercises for real-world query scenarios.

Learn how to use the SQL HAVING clause to filter aggregated group results, enabling analysis of grouped data with aggregate functions beyond the WHERE clause.

Explore how to use SQL date functions like DATE_TRUNC and DATE_PART to analyze, aggregate, and group data by various date parts for effective reporting.

Learn to use SQL CASE statements for conditional logic in SELECT queries, including multi-case logic, handling NULLs, and combining CASE with aggregations.

Learn the basics of SQL subqueries, focusing on scalar subqueries, to simplify complex logic and compare values efficiently within a single query.

Learn how to use subqueries in the WHERE clause to filter SQL results dynamically, making queries more flexible and readable. Practice building both scalar and filtering subqueries.

Learn how to use subqueries in the FROM clause to create derived tables, transform data, and build complex SQL queries efficiently with practical examples.

Learn how Common Table Expressions (CTEs) make complex SQL queries cleaner, more readable, and efficient by organizing logic into reusable, easily-managed parts with the WITH clause.

Discover how temporary tables in SQL simplify complex queries by storing intermediate results, boosting performance, organizing logic, and supporting efficient data analysis.

Learn key tips for writing clean, efficient SQL using subqueries, CTEs, and temp tables, plus best practices for clarity, performance, and maintainability.

Discover SQL window functions to perform calculations like totals, averages, and ranking across rows while retaining individual data for advanced analysis.

Discover how SQL's PARTITION BY enables advanced analytics—like running totals, rankings, and trend analysis—across groups without losing row-level detail.

Understand the role of ORDER BY in SQL window functions for ordering, ranking, and framing data, including ROWS vs RANGE and practical uses like running totals and moving averages.

Learn how to build SQL window functions for detailed analysis, cumulative totals, and efficient queries using PARTITION BY, ORDER BY, and smart optimization strategies.

Learn why data cleaning is crucial, how to identify issues like duplicates, nulls, and outliers, and practical SQL techniques to ensure analysis is accurate and reliable.

Learn essential SQL data cleaning skills: handle missing values, remove duplicates, standardize text, and fix data types for accurate, reliable analysis.

Learn advanced SQL data cleaning using staging tables and workflows for scalable, reliable data prep, with best practices for consistency, deduplication, and quality control.

Learn Python fundamentals and data analysis by writing programs, working with data structures, exploring datasets, creating visualizations, and applying analytical techniques to real-world data.

Familiarize yourself with the building blocks of Python! Learn about data types and operators, built-in functions, type conversion, whitespace, and style guidelines.

Use data structures to order and group different data types together! Learn about the types of data structures in Python, along with more useful built-in functions and operators.

Build logic into your code with control flow tools! Learn about conditional statements, repeating code with loops and useful built-in functions, and list comprehensions.

Learn how to use functions to improve and reuse your code! Learn about functions, variable scope, documentation, lambda expressions, iterators, and generators.

Leverage Python libraries and packages to solve data analysis problems efficiently, install and manage tools with pip, and use community-built resources to accelerate insight generation.

Explore datasets with Pandas and Polars by loading data into DataFrames, inspecting structure and quality, generating summaries, and comparing tools to support effective analysis workflows.

Analyze and summarize data with Pandas using filtering, aggregation, grouping, and pivot tables to uncover patterns, compare categories, and generate actionable insights.

Visualize and communicate data insights with charts that reveal distributions, trends, correlations, and outliers while selecting effective techniques for exploration and storytelling.

Review key Python, data analysis, and visualization skills while reinforcing workflows for exploring data and communicating insights effectively.

Navigate the filesystem, inspect file contents, and manage files and directories efficiently in the Unix shell while building practical skills for common terminal workflows.

Automate file handling and data workflows with shell scripts, command chaining, loops, conditionals, and text-processing tools to organize files, analyze logs, and transform datasets.

Develop reusable Python automation tools that process data, handle command-line inputs, integrate shell workflows, and manage files efficiently using Python's built-in modules.

Version control is an incredibly important part of a professional programmer's life. In this lesson, you'll learn about the benefits of version control and install the version control tool Git!

Now that you've learned the benefits of Version Control and gotten Git installed, it's time you learn how to create a repository.

Knowing how to review an existing Git repository's history of commits is extremely important. You'll learn how to do just that in this lesson.

In this lesson, you'll learn how to fork another developer's project. Collaborating with other developers can be a tricky process, so you'll learn how to contribute to a public project.

Learn the importance of well documented code and see how to craft meaningful READMEs.