uCertify

SQL Querying: Advanced

(SQL-Advance.AD1) / ISBN : 978-1-64459-361-5
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Instructor-Led (Add-on)
Get A Free Trial

About This Course

Skills You’ll Get

Get the support you need. Enroll in our Instructor-Led Course.

Download Course Outline

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
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
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
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
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
6

Exporting Query Results

  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Generate a Text File
  • TOPIC B: Generate an XML File
  • Summary
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
8

Manipulating Table Data

  • Lesson Objectives
  • Introduction
  • TOPIC A: Insert Data
  • TOPIC B: Modify and Delete Data
  • Summary
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
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
11

Indexing Data

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

Managing Transactions

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

Appendix A

  • The FullerAckerman Database
  • Schema

1

Executing a Simple Query

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

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
3

Working with Functions

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

Organizing Data

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

Retrieving Data from Multiple Tables

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

Exporting Query Results

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

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
8

Manipulating Table Data

  • Inserting, Modifying, and Deleting Data
9

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
  • Backing Up a Table
  • Deleting a Table
10

Working with Views

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

Indexing Data

  • Creating Indexes
  • Dropping Indexes
12

Managing Transactions

  • Creating and Comitting Transactions

Related Courses

All Course