|Lynda.com| - SQL Essential Training

Creating tables

Deleting a table with DROP TABLE

Inserting rows into a table

Deleting rows from a table

Understanding NULL

Controlling column behaviors with constraints

Changing a schema with ALTER

Creating an ID column

Filtering data with WHERE, LIKE, and IN

Removing duplicates with SELECT DISTINCT

Sorting with ORDER BY

Conditional expressions with CASE

Understanding joins

Accessing related tables with JOIN

Using multiple related tables

About SQL strings

Finding the length of a string

Selecting part of a string

Removing spaces with TRIM

Making strings uppercase and lowercase

About numeric types

Finding the type of a value

Integer division and remainders

Rounding numbers

Dates and times

Date- and time-related functions

How aggregates work

Using aggregate functions

Aggregating DISTINCT values

Why use transactions?

Using transactions

Updating a table with a trigger

Preventing automatic updates with a trigger

Automating timestamps with a trigger

Creating a simple subselect

Searching within a result set

Creating a view

Creating a joined view

Touring the CRUD application

The SELECT functions

The INSERT, UPDATE, and DELETE functions

Goodbye