Master SQL Fundamentals Using Python & Movie Data

Learn Real SQL Skills Inside Python – Without the Hassle of Database Setup!

Unlock the Power of SQL + Python for Data Analysis

Are you an internal auditor, data analyst, or business professional looking to sharpen your data skills?

This course is designed to get you hands-on with SQL inside Python, leveraging the popular MovieLens dataset to make your learning engaging and practical.

No need to set up databases. No complex installations. Just pure SQL querying power, right in Python!

What You'll Learn:

✅ SQL Basics – SELECT, WHERE, ORDER BY, GROUP BY, and more.

✅ Filtering & Sorting Data – How to retrieve exactly the data you need.

✅ Aggregating Data – Using COUNT, AVG, MIN, MAX, SUM functions.

✅ Joining Tables – Combine datasets like a pro with INNER JOIN.

✅ Subqueries & Advanced Filtering – Nest queries for deeper insights.

✅ Real-World Projects – Apply everything in a capstone project that mimics real business scenarios.

Why Take This Course?

✨ SQL + Python Combo: Learn SQL querying without needing a separate database. Use the lightweight pandasql library.

🎬 Mixed-Media Lessons: Engage with clear video walk throughs, written explanations, and ready-to-run Python notebooks.

📊 Real Datasets: You'll use real, non-commercial MovieLens movie ratings data – perfect for analysis exercises.

📈 Auditor & Analyst Focus: Specifically designed for internal auditors and data-focused professionals who want to use SQL as a powerful analysis tool within Python workflows.

What You’ll Get:

• Complete access to 10 modules walking you step-by-step through beginner SQL concepts.
• Fully commented Python notebooks with working SQL code.
• Quizzes, exercises, and real-world project assignments.
• Downloadable environment files to quickly set up your Python workspace using Miniconda or PIP.
• Lifetime access + updates as the course evolves.

Is This Course for You?

If you:

• Want to use SQL without the hassle of setting up servers.
• Already use Python (or want to) for data tasks.
• Are in Internal Audit, Data Analytics, or related fields.
• Need practical, beginner-to-intermediate SQL skills for real-world problems.

Then YES — this course is built for you!

Course Curriculum Highlights:

1. Course Environment
2. SQL Basics: SELECT & LIMIT
3. Filtering Data: WHERE Clause
4. Sorting & Ordering: ORDER BY
5. Aggregating Data: COUNT, AVG, SUM, GROUP BY
6. Joining Tables: INNER JOIN
7. Aliases & Renaming: AS Keyword
8. Subqueries: Nested queries
9. Real-World Queries
10. Final Project – Data views as a base for a Movie Ratings Report

Enroll Now & Start Mastering SQL Inside Python!

CPE & Accreditation Details:

CPE Hours: 5.0
Field of Study: Data Analytics
Program Level: Intermediate
Delivery Method: Self Study
Who Should Attend: This course is designed for internal auditors at all levels seeking to use SQL alongside Python for Data Analysis.
Prerequisites:A computer with Python installed (Miniconda preferred).
Note: We will showcase the Miniconda environment file used for installation. Miniconda is not required if you're able to install the required packages through PIP or other method.
Format: Mixed Media - Audio, Text, Video