SQL Querying: Fundamentals

Lesson 1: Getting Started with Relational Database Design

• Topic A: Identify Database Components
• Topic B: Identify Common Database Design Problems
• Topic C: Follow a Database Design Process
• Topic D: Gather Requirements

Lesson 2: Defining the Database Conceptual Model

• Topic A: Create the Conceptual Model
• Topic B: Identify Entity Relationships

Lesson 3: Defining the Database Logical Model

• Topic A: Identify Columns
• Topic B: Identify Primary Keys
• Topic C: Identify and Diagram Relationships

Lesson 4: Normalizing Data

• Topic A: Avoid Common Database Design Errors
• Topic B: Comply with Higher Normal Forms

Lesson 5: Finalizing the Database Design

• Topic A: Adapt the Physical Model for Different Systems
• Topic B: Ensure Referential Integrity
• Topic C: Ensure Data Integrity at the Column Level
• Topic D: Ensure Data Integrity at the Table Level
• Topic E: Design for the Cloud

Lesson 6: 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 7: 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 String Patterns

Lesson 8: Working with Functions

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

Lesson 9: 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

Lesson 10: Retrieving Data from Multiple Tables

• Topic A: Combine the Results of Two Queries
• Topic B: Compare the Results of Two Queries
• Topic C: Retrieve Data by Joining Tables

Lesson 11: Exporting Query Results

• Topic A: Generate a Text File
• Topic B: Generate an XML File