Working with databases and tables

This section of the course is designed to create the database we will be working with throughout the course as well as the tables. There is a quiz associated with this section. You can take the quiz by clicking the button at the right corner of the outline.There are four lessons included in this section:

In this section we will use the following SQL commands, keywords, or clauses:

  • CREATE DATABASE
  • SHOW DATABASES
  • USE
  • SELECT DATABASE()
  • DROP DATABASE
  • CREATE TABLE
  • DROP TABLE
  • DESCRIBE
  • SHOW TABLES
  • NOT NULL
  • UNIQUE
  • PRIMARY KEY
  • FOREIGN KEY
  • CHECK
  • DEFAULT
  • AUTO_INCREMENT

Questions