Introduction to SQL with an Online Shop

Overview

This learning path is a fun, accessible introduction to SQL, one of the most popular database query languages. It uses online shop orders data as your database. Your journey to SQL greatness starts here, exploring real-world e-commerce data!

What you'll learn

Write SQL queries to retrieve and filter database records
Sort, group, and summarize online shop data
Apply SQL functions and clauses to analyze datasets
Join related tables containing orders, products, and customer data
Use conditional logic to categorize values and control query results
Build complex queries to answer practical business questions

Advantages and disadvantages

Advantages

University courses you can audit for free, with lectures, readings and practice quizzes.
A verified certificate from the university if you pay for it.
Self-paced: start any time.

Disadvantages

Graded assignments and the certificate need the paid track.
Audit access can expire a few weeks after the course ends.
Learning is free, but the certificate costs money.
Some parts (graded work, certificate) are paid.

Some points apply to every course of this kind; see how we rank.

Free to audit

Free: Choose "Audit this course" when you enrol: lectures, readings and practice are free.
Paid: Graded assignments and the verified certificate (Certificate $45). Audit access may end after the course closes.

Similar courses

Compare these

Massachusetts Institute of Technology · YouTube

MIT 6.01SC Introduction to EECS I

Instructor: Dennis Freeman, Kendra Pugh This course provides an integrated introduction to electrical engineering and computer science, including modern software engineering, linear systems analysis, electronic circuits, and decision-making. The lecture videos provide an overview of each topic, whi…

Free video27 videos, 17 hours

Harvard University · edX

Exercising Leadership: Foundational Principles

4.71,590 ratings

Mobilize people to tackle tough problems and build the capacity to thrive through the dangers of change

Free to audit4 weeks, 2 - 3 hours per week

Harvard University · edX

Fundamentals of TinyML

4.567 ratings

Focusing on the basics of machine learning and embedded systems, such as smartphones, this course will introduce you to the “language” of TinyML.

Free to audit5 weeks, 2 - 4 hours per week

Harvard University · edX

Introduction to Data Science with Python

4.3174 ratings

Learn the concepts and techniques that make up the foundation of data science and machine learning.

Free to audit8 weeks, 3 - 5 hours per week

Harvard University · edX

CS50's Introduction to Computer Science

An introduction to the intellectual enterprises of computer science and the art of programming.

Free to audit12 weeks, 5 - 14 hours per week

Massachusetts Institute of Technology · YouTube

MIT MAS.S62 Cryptocurrency Engineering and Design, Spring 2018

Instructor: Neha Narula, Tadge Dryja View the complete course: https://ocw.mit.edu/MAS-S62S18 YouTube Playlist: https://www.youtube.com/playlist?list... This course looks at the design of Bitcoin and other cryptocurrencies and how they function in practice, focusing on cryptography, game theory, an…

Free video20 videos, 25 hours