Course Curriculum

    1. Getting Started

    2. Pre-course Survey

    3. MySQL Download

    4. SQL Foundations Files

    5. Import Data

    6. Exercise File Overview

    1. 1. SQL Intro

    2. 2. SQL Intro Tutorial

    3. 3. SELECT & FROM

    4. 4. SELECT & FROM Tutorial

    1. 5. WHERE

    2. 6. LIKE

    3. 7. Data Types

    4. 8. Implicit Conversion

    5. 9. Explicit Conversion

    1. 10. INNER & OUTER Joins

    2. 11. ON Condition

    3. 12. Aliases

    4. JOINs Tutorial - Prep

    5. 13. JOINs Tutorial

    1. 14. Aggregation Functions

    2. 15. GROUP BY

    3. 16. HAVING

    4. 17. DISTINCT, ORDER BY, & LIMIT

    5. 18. Aggregation Tutorial

    1. Course Completion

    2. Post-Course Survey & Feedback

Course Overview

  • 27 lessons
  • 1 hour of video content
  • Guided exercises

Course Activities

  • Lessons

    Complex topics are broken into small, easy to understand videos.

  • Exercises

    Hands-on exercises reinforce key concepts.

Enroll in the Sparx Academy

Already a member? Find this course in your dashboard to start learning.

Enroll

Frequently Asked Questions

  • How do I enroll?

    This course is included in all Sparx Academy memberships. Click "Enroll" to register if you aren't already a member. If you are a member, the course will be located in your dashboard.

  • Do I need any experience prior to starting this program?

    No prior experience is needed. This program is great for those new to excel or those with prior experience who want to learn new approaches.

  • How long does the program take to complete?

    It is estimated to take 5 hours to watch all videos and complete the project. However, this can vary depending on your previous experience.

  • Do I need software?

    You will need your own access to Microsoft Excel prior to enrollment. The videos were created using Excel on Windows 365. You can still take the class if using Excel on a Mac.

  • Are there group discounts?

    Yes! Groups of 3+ that would like to enroll at the same time are eligible for a discount. Email [email protected] for details.