Structured Query Language has two halves, and this topic covers both. Data definition language is used to build a database structure, with CREATE DATABASE, CREATE TABLE and ALTER TABLE, including how keys and constraints are declared. Data manipulation language is then used to work with the stored data, covering SELECT, FROM, WHERE, GROUP BY, ORDER BY and INNER JOIN, together with the aggregate functions SUM, COUNT and AVG. You will write queries to answer given questions.
🔒 Sign in to view this topic's basics.