Python & Data Science

• Python zip(): Real-world examples of how to pair up elements from multiple iterables.
• NumPy Matrix Multiplication: Covers the difference between element-wise multiplication and matrix products.
• NumPy Random: Focuses on modern random number generation using default_rng.
• NumPy Universal Functions: A guide to ufuncs like add, subtract, and multiply.
• NumPy Basics: Standard array operations and number functions.

SQL (SQLite focus)

• CAST as Data Type: How to convert data types within queries.
• MIN and MAX: Finding extreme values in your datasets.
• Subqueries and CTEs: Advanced querying techniques using Common Table Expressions.
• Group By & Ordering: Basics of organizing and limiting query results.
• JOINs: Working with LEFT JOIN and INNER JOIN using Netflix-themed example data.