uCertify

SQL Queries

(SQL-Queries.AD1) / ISBN : 978-1-64459-358-5
(Add-on)
(Add-on)
Get A Free Trial

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

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More