SQL Queries Introduction

SQL statements are used to perform tasks such as updating data on a database, or retrieving data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, and others. 

Some of these database systems will have extensions specific only to their system. However, the standard SQL commands such as “Select”, “Insert”, “Update”, “Delete”, “Create”, and “Drop” are used with all these database systems.

Class Outline

Lesson 1: Executing a Simple Query

• Topic A: Connect to the SQL Database
• Topic B: Query a Database
• Topic C: Save a Query
• Topic D: Modify and Execute a Saved Query

Lesson 2: Performing a Conditional Search

• Topic A: Search Using One or More Conditions
• Topic B: Search for a Range of Values and NULL Values
• Topic C: Search Data Based on Patterns

Lesson 3: Working with Functions

• Topic A: Perform Date Calculations
• Topic B: Calculate Data Using Aggregate Functions
• Topic C: Manipulate String Values

Lesson 4: Organizing Data

• Topic A: Sort Data
• Topic B: Rank Data
• Topic C: Group Data
• Topic D: Filter Grouped Data
• Topic E: Summarize Grouped Data
• Topic F: Use PIVOT and UNPIVOT Operators