SQL Fundamentals
Query any database with confidence: the skill behind every analytics and ops role.
SQL (Structured Query Language) is the language used to ask questions of relational databases, and it has been the standard for fifty years. Nearly every system a company runs, its orders, customers, payments, employees, sits in such a database, which is why SQL appears in the job description of analysts, product managers, marketers, finance teams and operations roles alike.
Unlike most programming languages, SQL reads almost like English. 'SELECT name, city FROM customers WHERE spend > 10000' is a complete, working query. You declare what you want, and the database engine works out how to get it.
Where you will meet it: analysts query a warehouse to build reports; developers read and write application data; HR and finance teams pull their own numbers instead of waiting for the tech team; and tools like Power BI, Tableau and Excel can all send SQL under the hood.
Common engines include PostgreSQL, MySQL, SQL Server and cloud warehouses like BigQuery and Snowflake. They differ in small ways but the core language, SELECT, FROM, WHERE, GROUP BY, JOIN, is identical everywhere.
This course teaches that core, using plain business tables: customers, orders, products and employees. Every concept is one you will use on your first day in a data-adjacent role.
Loading…
The assessment
10 multiple-choice questions · 50% pass mark · two attempts.
