Unit 6 Pathway 1: Introduction to SQL (optional)ΒΆ
- Unit 6 Pathway 1 Activity 1: Introduction to Databases and SQL
- Unit 6 Pathway 1 Activity 2: Use SQL to read and write to a database
- Before you begin
- Key concepts of relational databases
- Download the starter data set
- Read data with a SELECT statement
- Use
SELECTstatements with aggregate functions and distinct values - Filter queries with a WHERE clause
- Group, order, and limit results
- Insert, update, and delete data in a database
- Summary