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
    • What is a database?
    • What is SQLite?
    • Representing data with SQLite
  • Download the starter data set
    • Use the Database Inspector
  • Read data with a SELECT statement
    • SELECT
    • Read email data using a SELECT statement
  • Use SELECT statements with aggregate functions and distinct values
    • Reduce columns with aggregate functions
    • Filter duplicate results with DISTINCT
  • Filter queries with a WHERE clause
    • Logical operators with WHERE clauses
    • Search for text using LIKE
  • Group, order, and limit results
    • Group results with GROUP BY
    • Sort results with ORDER BY
    • Restrict the number of results with LIMIT
  • Insert, update, and delete data in a database
    • Insert data into a database
    • Update existing data in a database
    • Delete a row from a database
  • Summary