BasicPrice: $595.00

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

Lesson 5: 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 6: Exporting Query Results

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

Advanced

Lesson 1: Querying with unions and advanced joins

  • Topic A: Querying multiple tables with unions
  • Topic B: Advanced Joins
  • Topic C: Calculating with COMPUTE

Lesson 2: Querying with subqueries

  • Topic A: Subqueries

Lesson 3: Adding data

  • Topic A: Inserting data
  • Topic B: SELECT INTO

Lesson 4: Updating and removing data

  • Topic A: Updating records
  • Topic B: Deleting records
  • Topic C: Deleting the contents of tables
  • Topic A: Creating tables
  • Topic B: Modifying tables
  • Topic C: Deleting tables
  • Topic D: Adding and removing views

Lesson 6: Manipulating indexes

  • Topic A: Adding and removing indexes

Lesson 7: Ensuring data integrity with transactions

  • Topic A: Transactions

Lesson 8: Creating databases

  • Topic A: Creating a database with SQL
  • Topic B: Deleting a database