SQL Querying: Fundamentals

This Course Includes:

Lessons 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

Lessons 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

Lessons 3: Working with Functions

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

Lessons 4: Organising Data

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

Lessons 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

Lessons 6: Exporting Query Results

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

Lessons 7: Using Subqueries to Perform Advanced Querying

  • 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

Lessons 8: Manipulating Table Data

  • TOPIC A: Insert Data
  • TOPIC B: Modify and Delete Data

Lessons 9: Manipulating the Table Structure

  • 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

Lessons 10: Working with Views

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

Lessons 11: Indexing Data

  • TOPIC A: Create Indexes
  • TOPIC B: Drop Indexes

Lessons 12: Managing Transactions

  • TOPIC A: Create Transactions
  • TOPIC B: Commit Transactions

Appendix A

  • The FullerAckerman Database
  • Schema

Hands-on LAB Activities

Executing a Simple Query

  • Connecting to a Database
  • Saving a Query and Modifying and Executing the Saved Query

Performing a Conditional Search

  • Comparing Column Values in a Table
  • Searching Using Simple and Multiple Conditions
  • Searching for a Range of Values and NULL Values
  • Retrieving Data Based on Patterns

Working with Functions

  • Performing Date Calculations
  • Using Aggregate Functions
  • Manipulating String Values in a Table

Organising Data

  • Sorting Data in a Table
  • Ranking Data in a Table
  • Grouping Data in a Table
  • Filtering Grouped Data in a Table
  • Summarising Grouped Data
  • Using the PIVOT and UNPIVOT Operators

Retrieving Data from Multiple Tables

  • Combining the Results of Two Queries
  • Comparing the Results of Two Queries
  • Retrieving Data by Joining Tables

Exporting Query Results

  • Saving the Query Results in CSV Format
  • Generating an XML File

Using Subqueries to Perform Advanced Querying

  • Searching for Records Based on Unknown Values
  • Searching for Records by Comparing Them with Unknown Values
  • Searching for Records Based on Their Existence in Another Table
  • Generating Output Using Correlated Subqueries
  • Filtering Grouped Data Within a Subquery
  • Generating Output Using Nested Subqueries

Manipulating Table Data

  • Inserting, Modifying and Deleting Data

Manipulating the Table Structure

  • Creating a Table
  • Creating a Table with Constraints
  • Adding and Dropping Columns in a Table
  • Adding and Dropping Constraints in a Table
  • Modifying the Column Definition in a Table

Working with Views

  • Creating Views
  • Creating Views with Schema Binding
  • Manipulating Data in Views
  • Creating Aliases
  • Modifying and Deleting Views

Indexing Data

  • Creating Indexes
  • Dropping Indexes

Managing Transactions

  • Creating and Comitting Transactions

Exam FAQs

FAQ's are not Available for this course.



SQL Querying


13+ Lessons

Delivery Method:




Scroll to Top