Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt

SQL Querying: Advanced

Submit form to obtain discount

Test Prep
62+ Pre Assessment Questions | 4+ Full Length Tests | 65+ Post Assessment Questions | 120+ Practice Test Questions
Features
42+ LiveLab | 42+ Video tutorials | 01:15+ Hours
5+ Videos | 15+ Minutes

Why choose TOPTALENT?

Outline

Lessons 1:
Executing a Simple Query

  • Lesson Objectives
  • Lesson Introduction
  • 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
  • Summary

Lessons 2:
Performing a Conditional Search

  • Lesson Objectives
  • Lesson Introduction
  • 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
  • Summary

Lessons 3:
Working with Functions

  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Perform Date Calculations
  • TOPIC B: Calculate Data Using Aggregate Functions
  • TOPIC C: Manipulate String Values
  • Summary

Lessons 4:
Organizing Data

  • Lesson Objectives
  • Lesson Introduction
  • 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
  • Summary

Lessons 5:
Retrieving Data from Multiple Tables

  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Combine the Results of Two Queries
  • TOPIC B: Compare the Results of Two Queries
  • TOPIC C: Retrieve Data by Joining Tables
  • Summary

Lessons 6:
Exporting Query Results

  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Generate a Text File
  • TOPIC B: Generate an XML File
  • Summary

Lessons 7:
Using Subqueries to Perform Advanced Querying

  • Lesson Objectives
  • Introduction
  • TOPIC A: Search Based on Unknown Values
  • TOPIC B: Compare a Value with Unknown Values
  • TOPIC C: Search Based on the Existence of Records
  • TOPIC D: Generate Output Using Correlated Subqueries
  • TOPIC E: Filter Grouped Data Within Subqueries
  • TOPIC F: Perform Multiple-Level Subqueries
  • Summary

Lessons 8:
Manipulating Table Data

  • Lesson Objectives
  • Introduction
  • TOPIC A: Insert Data
  • TOPIC B: Modify and Delete Data
  • Summary

Lessons 9:
Manipulating the Table Structure

  • Lesson Objectives
  • Introduction
  • TOPIC A: Create a Table
  • TOPIC B: Create a Table with Constraints
  • TOPIC C: Modify a Table’s Structure
  • TOPIC D: Back Up Tables
  • TOPIC E: Delete Tables
  • Summary

Lessons 10:
Working with Views

  • Lesson Objectives
  • Introduction
  • TOPIC A: Create a View
  • TOPIC B: Manipulate Data in Views
  • TOPIC C: Create Aliases
  • TOPIC D: Modify and Delete Views
  • Summary

Lessons 11:
Indexing Data

  • Lesson Objectives
  • Introduction
  • TOPIC A: Create Indexes
  • TOPIC B: Drop Indexes
  • Summary

Lessons 12:
Managing Transactions

  • Lesson Objectives
  • Introduction
  • TOPIC A: Create Transactions
  • TOPIC B: Commit Transactions
  • Summary

Appendix A

  • The FullerAckerman Database
  • Schema