Final Exam: Pair Programming with Generative AI Tools - SQL Databases

WHAT YOU WILL LEARN

• 

  Recall foundational concepts of structured query language (sql)
  

  use generative artificial intelligence (ai) to explore sql
  

  create a database and table
  

  view and drop constraints
  

  work with primary keys
  

  use not null constraints in sql
  

  install mysql on macos and windows
  

  insert data into and view tables with chatgpt's assistance
  

  update and delete records in tables
  

  use unique constraints and trigger constraint enforcement
  

  upload data from a file to mysql
  

  filter rows using the where clause
  

  filter data with the like and in keywords
  

  view data with subqueries
  

  set up foreign keys with cascading deletes
• 

  perform numeric aggregations
  

  use not null constraints in structured query language (sql)
  

  group data and perform aggregations
  

  filter grouped results using the having clause
  

  perform complex groupby and aggregation operations
  

  create indexes to improve performance
  

  perform cross joins
  

  perform inner joins
  

  perform left, right, and full outer joins
  

  grant access to views
  

  normalize data in structured query language (sql)
  

  run queries automatically with triggers
  

  create and run advanced triggers
  

  commit and rollback transactions
  

  use savepoints in transactions