SQL-Fundamentals.AD1
SQL Querying: Fundamentals
- Practice in 42 Hands-On Labs — nothing to install
- 13 Interactive Lessons and 80 topics mapped to the official exam objectives
- 273 Practice Test Questions and 4 Full Length Tests
Intermediate Self-paced · 1 year access
42 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
13Interactive Lessons
80Topics
42LiveLab
273Practice Test Questions
5Videos
113Flashcards
113Glossary of terms
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
13 Interactive Lessons · 80 topics01 Executing a Simple Query 7 topics · 2 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
02 Performing a Conditional Search 6 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
03 Working with Functions 6 topics · 3 LiveLab +
- Lesson Objectives
- Lesson Introduction
- TOPIC A: Perform Date Calculations
- TOPIC B: Calculate Data Using Aggregate Functions
- TOPIC C: Manipulate String Values
- Summary
3 LiveLab in this lesson — see the labs panel →
04 Organizing Data 9 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
05 Retrieving Data from Multiple Tables 6 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
06 Exporting Query Results 5 topics · 2 LiveLab +
- Lesson Objectives
- Lesson Introduction
- TOPIC A: Generate a Text File
- TOPIC B: Generate an XML File
- Summary
2 LiveLab in this lesson — see the labs panel →
07 Using Subqueries to Perform Advanced Querying 9 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
08 Manipulating Table Data 5 topics · 1 LiveLab +
- Lesson Objectives
- Introduction
- TOPIC A: Insert Data
- TOPIC B: Modify and Delete Data
- Summary
1 LiveLab in this lesson — see the labs panel →
09 Manipulating the Table Structure 8 topics · 7 LiveLab +
- 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
7 LiveLab in this lesson — see the labs panel →
10 Working with Views 7 topics · 5 LiveLab +
- 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
5 LiveLab in this lesson — see the labs panel →
11 Indexing Data 5 topics · 2 LiveLab +
- Lesson Objectives
- Introduction
- TOPIC A: Create Indexes
- TOPIC B: Drop Indexes
- Summary
2 LiveLab in this lesson — see the labs panel →
12 Managing Transactions 5 topics · 1 LiveLab +
- Lesson Objectives
- Introduction
- TOPIC A: Create Transactions
- TOPIC B: Commit Transactions
- Summary
1 LiveLab in this lesson — see the labs panel →
13 Appendix A 2 topics +
- The FullerAckerman Database
- Schema
Hands-On Labs Our edge
42 LiveLabs- Connecting to a Database
- Saving a Query and Modifying and Executing the Saved Query
- 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
- Performing Date Calculations
- Using Aggregate Functions
- Manipulating String Values in a Table
- 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
- Combining the Results of Two Queries
- Comparing the Results of Two Queries
- Retrieving Data by Joining Tables
- Saving the Query Results in CSV Format
- Generating an XML File
- 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
- Inserting, Modifying, and Deleting Data
- 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
- Creating Views
- Creating Views with Schema Binding
- Manipulating Data in Views
- Creating Aliases
- Modifying and Deleting Views
- Creating Indexes
- Dropping Indexes
- Creating and Comitting Transactions
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for SQL Querying: Fundamentals
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 42 LiveLab included
- Certificate of completion
No credit card required