SQL

Within these castle walls be forged Mavens of Computer Science ...

— Merlin, The Coder

Employees

Create a file named ~/.my.cnf in your home directory containing the following:

[client]
host=db
database=employees
user=employees_user
password=N@!S%9poX5HE,CdPJ6_2

Sakilla

[client]
host=db
database=sakila
user=sakila-user
password="J4wZwE:}.5RySc-"

LOGIN Topics

• Successfully log in to a database using command line options
• Successfully log in to a database using a configuration file

SHOW Topics

• Show all tables in a specified database
• Show all columns from a specified table

Column Types

• CHAR
• VARCHAR
• TEXT
• BLOB
• ENUM
• SET
• BOOLEAN
• INT
• FLOAT
• DOUBLE
• DECIMAL
• DATE
• TIME
• DATETIME
• TIMESTAMP
• NULL

SELECT Topics

• Selecting constants
• Select all records from a specified table
• Select specific columns from a specified table
• Select non-repeating (distinct) records from a specified table
• Column aliases

Ordering Records

• Ordering records with a single column
• Ordering records with multiple columns

Filters

• Using where
• Using logical operators
• Using NULL
• Using LIKE and wildcards
• Using IN
• Using BETWEEN

Aggregate Queries

• Count
• Average
• Maximum
• Minimum
• Sum

Joins

• Inner
• Left
• Right
• Outer
• Self

Unions

• Union (distinct)
• Union (all)