SQL Essentials

sql

Introduction

SQL (Structured Query Language) is a standard language for storing, manipulating and retrieving data in databases. This course is designed to help users understand the most common language for database wrangling. The content covers major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and working with subselects and views.

Outline

  1. Introduction
    • What is SQL?
    • Installation Environment
  1. SQL Quick Start
    • Quick-start introduction
    • Save Quick-start introduction
    • Using the basic SELECT statement
    • Save Using the basic SELECT statement
    • Selecting rows
    • Save Selecting rows
    • Selecting columns
    • Save Selecting columns
    • Counting rows
    • Save Counting rows
    • Inserting data
    • Save Inserting data
    • Updating data
    • Save Updating data
    • Deleting data
    • Save Deleting data
  1. Fundamentals
    • Databases and tables
    • Save Databases and tables
    • SQL syntax overview
    • Save SQL syntax overview
    • Formatting SQL
    • Save Formatting SQL
    • Creating tables
    • Save Creating tables
    • Deleting a table with DROP TABLE
    • Save Deleting a table with DROP TABLE
    • Inserting rows into a table
    • Save Inserting rows into a table
    • Deleting rows from a table
    • Save Deleting rows from a table
    • Understanding NULL
    • Save Understanding NULL
    • Controlling column behaviors with constraints
    • Save Controlling column behaviors with constraints
    • Changing a schema with ALTER
    • Save Changing a schema with ALTER
    • Creating an ID column
    • Save Creating an ID column
    • Filtering data with WHERE, LIKE, and IN
    • Save Filtering data with WHERE, LIKE, and IN
    • Removing duplicates with SELECT DISTINCT
    • Save Removing duplicates with SELECT DISTINCT
    • Sorting with ORDER BY
    • Save Sorting with ORDER BY
    • Conditional expressions with CASE
    • Save Conditional expressions with CASE
  1. Relationships
    • Understanding joins
    • Save Understanding joins
    • Accessing related tables with JOIN
    • Save Accessing related tables with JOIN
    • Using multiple related tables
    • Save Using multiple related tables
  1. Strings
    • About SQL strings
    • Save About SQL strings
    • Finding the length of a string
    • Save Finding the length of a string
    • Selecting part of a string
    • Save Selecting part of a string
    • Removing spaces with TRIM
    • Save Removing spaces with TRIM
    • Making strings uppercase and lowercase
    • Save Making strings uppercase and lowercase
  1. Numbers
    • About numeric types
    • Save About numeric types
    • Finding the type of a value
    • Save Finding the type of a value
    • Integer division and remainders
    • Save Integer division and remainders
    • Rounding numbers
    • Save Rounding numbers
  1. Dates
    • Dates and times
    • Save Dates and times
    • Date- and time-related functions
    • Save Date- and time-related functions
  1. Aggregates
    • How aggregates work
    • Save How aggregates work
    • Using aggregate functions
    • Save Using aggregate functions
    • Aggregating DISTINCT values
    • Save Aggregating DISTINCT values
  1. Transactions
    • Why use transactions?
    • Save Why use transactions?
    • Using transactions
    • Save Using transactions
  1. Triggers
    • Updating a table with a trigger
    • Save Updating a table with a trigger
    • Preventing automatic updates with a trigger
    • Save Preventing automatic updates with a trigger
    • Automating timestamps with a trigger
    • Save Automating timestamps with a trigger
  1. Subselects and Views
    • Creating a simple subselect
    • Save Creating a simple subselect
    • Searching within a result set
    • Save Searching within a result set
    • Creating a view
    • Save Creating a view
    • Creating a joined view
    • Save Creating a joined view
  1. A Simple CRUD Application
    • Touring the CRUD application
    • Save Touring the CRUD application
    • The SELECT functions
    • Save The SELECT functions
    • The INSERT, UPDATE, and DELETE functions
    • Save The INSERT, UPDATE, and DELETE functions