3.4 Structured Query Language (SQL)

• describe types of structured query language statements
• perform structured query language operations in a database
• appreciate the use of structured query language in database management

“How are SQL skills essential in database management?”

“Why is SQL considered a powerful tool in data management?”

The titles are open to everyone. Reading a lesson needs an account — sign in or create one.

1. What SQL is
   40 min · 1 practice tasks · quiz
   Describe SQL and what it is used for.
2. SQL applications
   40 min · 1 practice tasks · quiz
   Name common SQL database systems.
3. Types of SQL statements
   40 min · 1 practice tasks · quiz
   Describe DDL, DML and DQL statements.
4. DDL: creating a table
   40 min · 1 practice tasks · quiz
   Use CREATE TABLE to define a table.
5. DDL: altering and dropping
   40 min · 1 practice tasks · quiz
   Use ALTER, RENAME and DROP.
6. Keys and constraints in SQL
   40 min · 1 practice tasks · quiz
   Define keys and constraints when creating tables.
7. DML: inserting data
   40 min · 1 practice tasks · quiz
   Use INSERT to add records.
8. DML: updating and deleting
   40 min · 1 practice tasks · quiz
   Use UPDATE and DELETE with a WHERE clause.
9. DQL: the SELECT statement
   40 min · 1 practice tasks · quiz
   Use SELECT to read data.
10. DQL: filtering with WHERE
    40 min · 1 practice tasks · quiz
    Use WHERE to filter records.
11. DQL: sorting with ORDER BY
    40 min · 1 practice tasks · quiz
    Sort query results with ORDER BY.
12. DQL: grouping with GROUP BY
    40 min · 1 practice tasks · quiz
    Summarise data with GROUP BY.
13. Creating relationships in SQL
    40 min · 1 practice tasks · quiz
    Create relationships among tables using SQL.
14. Creating an SQL database for community data
    40 min · 1 practice tasks · quiz
    Build an SQL database for a real community task.
15. Reviewing SQL
    40 min · 1 practice tasks · quiz
    Review and appreciate SQL.