SQL Overview
Presents an overview of concepts pertaining to relational databases and SQL. Describes the tables used in the course.
| Relational Concepts
Databases based on a relational model. Components of relational tables. |
| Course Tables
Data found in the tables used in the course. |
| SQL Concepts
Purpose of SQL. Features of Data Definition Language, Data Manipulation Language and Authorization Language. Syntax rules for coding SQL statements. |
Rows and Columns
Describes how to select rows and columns with SQL.
| Selecting Columns
How to select all columns or specific columns. The method to eliminate values. Use of qualified table names. Naming result columns with the AS clause. |
| Selecting Rows
Coding a WHERE clause when selecting rows. Use of the IN, BETWEEN, NULL and LIKE options. How to use AND, OR and parentheses with multiple search conditions. |
| Sorting Rows
Coding an ORDER BY clause. How to indicate ascending or descending order. The method to specify sort fields. How to indicate sorting order with column names or numbers. Using the AS results. |
Query Techniques
Describes several techniques to build basic queries with SQL.
| Built-in Functions
The built-in functions available with SQL. How rows are included or excluded in the calculations. |
| Grouping Report Information
Coding a GROUP BY clause. Using GROUP BY with ORDER BY, HAVING and AS clauses. |
| Calculating Column Values
Using column values as part of an arithmetic expression. Using calculated values with built-in functions and in a WHERE clause. How to order by a calculated column. Naming result columns with the AS clause. |
| Combining Tables
Definition of joining tables and an equijoin. Using the FROM and WHERE clauses when combining tables. |
Query Practice
| Workshop
Building a query using SQL. |
|