Introduction To Sql –

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.