.jpg){kind=logo}
SQL-Queries.AD1.00T
uCertifyPrep SQL
Intermediate Self-paced · 1 year access
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
13 Interactive Lessons · 80 topics01 Executing a Simple Query 7 topics +
- 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
02 Performing a Conditional Search 6 topics +
- 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
03 Working with Functions 6 topics +
- Lesson Objectives
- Lesson Introduction
- TOPIC A: Perform Date Calculations
- TOPIC B: Calculate Data Using Aggregate Functions
- TOPIC C: Manipulate String Values
- Summary
04 Organizing Data 9 topics +
- 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
05 Retrieving Data from Multiple Tables 6 topics +
- 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
06 Exporting Query Results 5 topics +
- Lesson Objectives
- Lesson Introduction
- TOPIC A: Generate a Text File
- TOPIC B: Generate an XML File
- Summary
07 Using Subqueries to Perform Advanced Querying 9 topics +
- 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
08 Manipulating Table Data 5 topics +
- Lesson Objectives
- Introduction
- TOPIC A: Insert Data
- TOPIC B: Modify and Delete Data
- Summary
09 Manipulating the Table Structure 8 topics +
- 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 7 topics +
- 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 5 topics +
- Lesson Objectives
- Introduction
- TOPIC A: Create Indexes
- TOPIC B: Drop Indexes
- Summary
12 Managing Transactions 5 topics +
- Lesson Objectives
- Introduction
- TOPIC A: Create Transactions
- TOPIC B: Commit Transactions
- Summary
13 Appendix A 2 topics +
- The FullerAckerman Database
- Schema
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for uCertifyPrep SQL
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.