1- Relational Database Fundamentals

• Overview of Relational Database Concepts
• Relational Databases and Relational Database Management Systems
• Data Normalization
• DDL Syntax

2- Writing Basic SQL Queries

• Displaying Table Structures
• Retrieving Column Data From a Table or View
• Selecting Unique Values
• Filtering Rows Using the WHERE Clause
• Sorting Results Using ORDER BY
• Joining Multiple Tables
• Using Column and Table Aliases

3- Creating a Database

• Database Development Methodology Overview
• Building a Logical Data Model
• Identifying Entities and Attributes
• Isolating Keys
• Relationships Between Entities
• Creating Entity-Relationship Diagrams
• Transforming to Physical Design
• Migrating Entities to Tables
• Selecting Primary Keys
• Defining Columns
• Enforcing Relationships with Foreign Keys
• Constructing the Database Using DDL
• Creating Tables, Indexes, Constraints and Views
• Dropping Tables, Indexes, Constraints and Views
• Modifying Tables, Indexes, Constraints and Views

4- Manipulating Query Results

• Using Row Functions
• Character
• Numeric
• Date and Time
• Data Conversion (CAST and CONVERT)
• Using the CASE Function
• Handling Null Values

5- Advanced Query Techniques

• Inner Joins
• Outer Joins (Left, Right, Full)
• Joining a Table to Itself
• Subqueries
• Tips for Developing Complex SQL Queries
• Using Aggregate Functions
• AVG
• COUNT
• SUM
• MIN
• MAX
• Aggregating Results Using GROUP BY
• Restricting Groups with the HAVING Clause
• Creating Temporary Tables

6- Manipulating Table Data Using SQL's Data Manipulation Language (DML)

• Inserting Data into Tables
• Updating Existing Data
• Deleting Records
• Truncating Tables
• Implementing Data Integrity with Transactions
• Beginning Explicit Transactions
• Committing Transactions
• Rolling Back Transactions
• Defining Save Points

The following topics may be included at the discretion of your instructor.

7- User-Defined Functions

• Definition and Benefits of Use
• CREATE FUNCTION
• Syntax
• RETURN Clause and the RETURNS Statement
• Scalar vs. Table Functions
• Comparison with Stored Procedures
• Returning Scalar Values and Tables
• ALTER and DROP FUNCTION

8- Stored Procedures

• Definition and Benefits of Use
• CREATE PROCEDURE
• Syntax
• Variables and Parameters
• Control of Program Flow
• ALTER and DROP PROCEDURE
• Implementation Differences

9- Triggers

• Definition and Benefits of Use
• Alternatives (e.g., Constraints)
• CREATE TRIGGER
• Syntax
• Trigger Types
• "Inserted" (or "NEW") and "Deleted" (or "OLD") Tables
• Event Handling and Trigger Execution
• ALTER and DROP TRIGGER

10- Working with Views

• Benefits of Using Views
• Creating Views
• ALTER and DROP VIEW