SLOs

Week 07: April 27 – May 1¶

At the end of this week, you should be able to:

1. Choose appropriate column data types (text, numeric, date/time, boolean, etc.) when designing a table.

2. Create a new table using CREATE TABLE.

3. Define column constraints — NOT NULL, UNIQUE, DEFAULT, and CHECK — to enforce data integrity.

4. Define and use foreign keys to model relationships between tables.

5. Create an index to improve query performance.

6. Insert new rows into a table using INSERT.

7. Delete rows from a table using DELETE.

8. Update existing rows in a table using UPDATE.

9. Modify an existing table’s structure using ALTER TABLE.

10. Grant and revoke user permissions on database objects using GRANT and REVOKE.

11. Combine result sets from multiple queries using UNION.

12. Return only rows common to two result sets using INTERSECT.

13. Subtract one result set from another using EXCEPT.