SQL statements allow you to work with data stored in a relational database, whether you are updating existing information, adding new records, or retrieving data for analysis. Many popular database systems use SQL, including Oracle, Microsoft SQL Server, MySQL, PostgreSQL, Access, and others. While each system may include its own unique features, the core SQL commands like Select, Insert, Update, Delete, Create, and Drop function similarly across all major platforms.
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
