[ Skip Main Nav ]
This course provides an introduction to the Structured Query Language (SQL) that provides a unified language that lets you query, manipulate, or control data in a business applications environment.
Explain the function of entities, attributes, and relationships in a relational database.
Identify primary keys.
Describe functional dependency.
Explain a normalized database.
Create tables using SQL.
Use the INSERT command to insert data into a table.
Describe how to save SQL for later use.
Use the SELECT command to retrieve data from a table.
Use the WHERE clause to restrict the results of the query with a simple condition.
Use the WHERE clause to restrict the results of the query with a compound condition.
Use the LIKE, IN, and BETWEEN operators to restrict the results of a query.
Use the ORDER BY clause to sort data.
Use aggregate functions to run calculated queries.
Use the GROUP BY clause to group data on a column.
Use the HAVING clause to restrict the groups on a column.
Create joins to retrieve data from multiple tables.
Use IN and EXISTS operators to restrict the results of a multiple table query.
Create new tables from existing tables.
Use the UPDATE command to add rows to a table.
Use the ALTER TABLE command to change a tables structure.
Apply SQL to a business application.