SQL Foundations
Write SQL queries to select, filter, sort and group data in a real database.
What you'll learn
- Select and filter rows with WHERE
- Sort and limit results
- Group data and use aggregate functions
- Insert, update and delete rows
- Answer business questions with queries
About this course
You work with a sample online store database from the first lesson. You write queries of growing complexity and finish with a set of reports that answer business questions.
Course curriculum
4 modules and 12 lessons over 4 weeks. Plan for about 12 learning hours.
01Databases and tablesWeek 1 · 3 lessons
- Tables, rows and columns
- Installing SQLite
- Your first SELECT
02Filtering and sortingWeek 2 · 3 lessons
- WHERE and operators
- ORDER BY and LIMIT
- NULL handling
03AggregatesWeek 3 · 3 lessons
- COUNT, SUM, AVG
- GROUP BY
- HAVING
04Store reports projectWeek 4 · 3 lessons
- Changing data
- Writing report queries
- Checking your answers
Project
Store reports. Ten SQL queries that answer questions about orders, customers and products in a sample store.
Who this course is for
Beginners and developers who have never written SQL.
Prerequisites
None.
What's included
- 180-day course access
- Project brief
- Starter repository
- Coding labs
- Reference solutions
- One written project review
- A digital completion certificate
Learning format
Project-based online course, part of our guided project courses. One written project review.
Access and delivery
- Course access is delivered within 15 minutes after payment.
- Written project review is returned within 2 business days of submission.
- Completion materials are issued within 2 business days after the project is approved.
Certificate
You receive a digital completion certificate. Completion materials are issued within 2 business days after the project is approved.
Frequently asked questions
When does access start?
Course access is delivered within 15 minutes after payment.
Is payment taken on this website?
No. After you submit your enrollment request, we reply by email with payment details and enrollment confirmation.
Does this course guarantee a job or income?
No. It is an education and training service and does not include employment, income or placement guarantees.
Can I cancel?
Our Refund and Cancellation Policy lists the terms for project-based programs.
