Section 6 – Creating Databases with MySQL

Learning Objectives:

  • Create tables in a MySQL database
  • Define columns and at types for a table
  • Create a primary key for a table
  • Create foreign keys and use them to establish relationships between tables
  • Enter data into a table using an insert statement
  • Display data in a table using a select query
  • Delete records from a table
  • Identify reserved words that cannot be used for field names

Related Videos: