.jpg){kind=logo}
SQL-MM.AB1.0L0
SQL Queries for Mere Mortals Labs
Intermediate Self-paced · 1 year access
45 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
22 Interactive Lessons · 153 topics01 What Is Relational? 5 topics +
- Types of Databases
- A Brief History of the Relational Model
- Anatomy of a Relational Database
- What’s in It for You?
- Summary
02 Ensuring Your Database Structure Is Sound 7 topics +
- Why Is this Lesson Here?
- Why Worry about Sound Structures?
- Fine-Tuning Columns
- Fine-Tuning Tables
- Establishing Solid Relationships
- Is That All?
- Summary
03 A Concise History of SQL 9 topics +
- The Origins of SQL
- Early Vendor Implementations
- “… And Then There Was a Standard”
- Evolution of the ANSI/ISO Standard
- Commercial Implementations
- What the Future Holds
- Why Should You Learn SQL?
- Which Version of SQL Does this Course Cover?
- Summary
04 Creating a Simple Query 10 topics · 3 LiveLab +
- Introducing SELECT
- The SELECT Statement
- A Quick Aside: Data versus Information
- Translating Your Request into SQL
- Eliminating Duplicate Rows
- Sorting Information
- Saving Your Work
- Sample Statements
- Summary
- Problems for You to Solve
3 LiveLab in this lesson — see the labs panel →
05 Getting More Than Simple Columns 10 topics · 6 LiveLab +
- What Is an Expression?
- What Type of Data Are You Trying to Express?
- Changing Data Types: The CAST Function
- Specifying Explicit Values
- Types of Expressions
- Using Expressions in a SELECT Clause
- That “Nothing” Value: Null
- Sample Statements
- Summary
- Problems for You to Solve
6 LiveLab in this lesson — see the labs panel →
06 Filtering Your Data 8 topics · 10 LiveLab +
- Refining What You See Using WHERE
- Defining Search Conditions
- Using Multiple Conditions
- Nulls Revisited: A Cautionary Note
- Expressing Conditions in Different Ways
- Sample Statements
- Summary
- Problems for You to Solve
10 LiveLab in this lesson — see the labs panel →
07 Thinking in Sets 7 topics · 3 LiveLab +
- What Is a Set, Anyway?
- Operations on Sets
- Intersection
- Difference
- Union
- SQL Set Operations
- Summary
3 LiveLab in this lesson — see the labs panel →
08 INNER JOINs 6 topics · 2 LiveLab +
- What Is a JOIN?
- The INNER JOIN
- Uses for INNER JOINs
- Sample Statements
- Summary
- Problems for You to Solve
2 LiveLab in this lesson — see the labs panel →
09 OUTER JOINs 7 topics · 3 LiveLab +
- What Is an OUTER JOIN?
- The LEFT/RIGHT OUTER JOIN
- The FULL OUTER JOIN
- Uses for OUTER JOINs
- Sample Statements
- Summary
- Problems for You to Solve
3 LiveLab in this lesson — see the labs panel →
10 UNIONs 6 topics · 1 LiveLab +
- What Is a UNION?
- Writing Requests with UNION
- Uses for UNION
- Sample Statements
- Summary
- Problems for You to Solve
1 LiveLab in this lesson — see the labs panel →
11 Subqueries 7 topics · 5 LiveLab +
- What Is a Subquery?
- Subqueries as Column Expressions
- Subqueries as Filters
- Uses for Subqueries
- Sample Statements
- Summary
- Problems for You to Solve
5 LiveLab in this lesson — see the labs panel →
12 Simple Totals 5 topics · 2 LiveLab +
- Aggregate Functions
- Using Aggregate Functions in Filters
- Sample Statements
- Summary
- Problems for You to Solve
2 LiveLab in this lesson — see the labs panel →
13 Grouping Data 7 topics · 1 LiveLab +
- Why Group Data?
- The GROUP BY Clause
- “Some Restrictions Apply”
- Uses for GROUP BY
- Sample Statements
- Summary
- Problems for You to Solve
1 LiveLab in this lesson — see the labs panel →
14 Filtering Grouped Data 6 topics · 1 LiveLab +
- A New Meaning for “Focus Groups”
- Where You Filter Makes a Difference
- Uses for HAVING
- Sample Statements
- Summary
- Problems for You to Solve
1 LiveLab in this lesson — see the labs panel →
15 Updating Sets of Data 7 topics · 1 LiveLab +
- What Is an UPDATE?
- The UPDATE Statement
- Some Database Systems Allow a JOIN in the UPDATE Clause
- Uses for UPDATE
- Sample Statements
- Summary
- Problems for You to Solve
1 LiveLab in this lesson — see the labs panel →
16 Inserting Sets of Data 6 topics · 1 LiveLab +
- What Is an INSERT?
- The INSERT Statement
- Uses for INSERT
- Sample Statements
- Summary
- Problems for You to Solve
1 LiveLab in this lesson — see the labs panel →
17 Deleting Sets of Data 6 topics · 1 LiveLab +
- What Is a DELETE?
- The DELETE Statement
- Uses for DELETE
- Sample Statements
- Summary
- Problems for You to Solve
1 LiveLab in this lesson — see the labs panel →
18 “NOT” and “AND” Problems 6 topics · 1 LiveLab +
- A Short Review of Sets
- Finding Out the “Not” Case
- Finding Multiple Matches in the Same Table
- Sample Statements
- Summary
- Problems for You to Solve
1 LiveLab in this lesson — see the labs panel →
19 Condition Testing 5 topics · 1 LiveLab +
- Conditional Expressions (CASE)
- Solving Problems with CASE
- Sample Statements
- Summary
- Problems for You to Solve
1 LiveLab in this lesson — see the labs panel →
20 Using Unlinked Data and “Driver” Tables 6 topics +
- What Is Unlinked Data?
- Solving Problems with Unlinked Data
- Solving Problems Using “Driver” Tables
- Sample Statements
- Summary
- Problems for You to Solve
21 Performing Complex Calculations on Groups 9 topics · 2 LiveLab +
- Grouping in Sub-Groups
- Extending the GROUP BY Clause
- Getting Totals in a Hierarchy Using Rollup
- Calculating Totals on Combinations Using CUBE
- Creating a Union of Totals with GROUPING SETS
- Variations on Grouping Techniques
- Sample Statements
- Summary
- Problems for You to Solve
2 LiveLab in this lesson — see the labs panel →
22 Partitioning Data into Windows 8 topics · 1 LiveLab +
- What You Can Do With a “Window” into Your Data
- Calculating a Row Number
- Ranking Data
- Splitting Data into Quintiles
- Using Windows with Aggregate Functions
- Sample Statements
- Summary
- Problems for You to Solve
1 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
45 LiveLabs- Using the SELECT Statement
- Using the DISTINCT Keyword
- Using the ORDER BY Clause
- Using the CAST Function
- Using a Literal
- Using the Concatenation Expression
- Using the NULL Values
- Naming an Expression
- Finding Null Values in a Column
- Using the LIKE Predicate
- Using the IN Predicate
- Using the BETWEEN Predicate
- Using Comparison Predicates
- Using the WHERE Clause
- Using the NOT Operator
- Using the ESCAPE Option
- Using the Order of Precedence
- Using AND and OR Operators
- Using the NOT IN Operator
- Using the UNION Operator
- Using the EXCEPT Operator
- Using the INTERSECT Operator
- Using an INNER JOIN
- Using a Subquery with the IN Predicate
- Using the FULL OUTER JOIN
- Using the RIGHT OUTER JOIN
- Using the LEFT OUTER JOIN
- Sorting with UNION
- Using Subqueries
- Using the COUNT Function
- Using the SOME Predicate
- Using the ALL predicate
- Using the ANY Predicate
- Using the MIN and MAX Functions
- Using the SUM and AVG Functions
- Using the GROUP BY Clause
- Using the HAVING Clause
- Using the UPDATE Statement
- Using the INSERT Statement
- Using the DELETE Statement
- Using the NOT EXISTS Command
- Using the CASE Statement
- Using ROLLUP
- Using the CUBE clause
- Using the RANK Function
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for SQL Queries for Mere Mortals Labs
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
- 45 LiveLab included
- Certificate of completion
No credit card required