SQL-MM.AB1.E0T

SQL Queries for Mere Mortals Course

Intermediate Self-paced · 1 year access

01 / Lessons & labs

See exactly what you will learn and practice

Download outline (PDF)

Lessons

26 Interactive Lessons · 175 topics

01 Introduction 6 topics

Are You a Mere Mortal?
About This Course
What This Course Is Not
How to Use This Course
Reading the Diagrams Used in This Course
Sample Databases Used in This Course

02 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

03 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

04 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

05 Creating a Simple Query 10 topics

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

06 Getting More Than Simple Columns 10 topics

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

07 Filtering Your Data 8 topics

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

08 Thinking in Sets 7 topics

What Is a Set, Anyway?
Operations on Sets
Intersection
Difference
Union
SQL Set Operations
Summary

09 INNER JOINs 6 topics

What Is a JOIN?
The INNER JOIN
Uses for INNER JOINs
Sample Statements
Summary
Problems for You to Solve

10 OUTER JOINs 7 topics

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

11 UNIONs 6 topics

What Is a UNION?
Writing Requests with UNION
Uses for UNION
Sample Statements
Summary
Problems for You to Solve

12 Subqueries 7 topics

What Is a Subquery?
Subqueries as Column Expressions
Subqueries as Filters
Uses for Subqueries
Sample Statements
Summary
Problems for You to Solve

13 Simple Totals 5 topics

Aggregate Functions
Using Aggregate Functions in Filters
Sample Statements
Summary
Problems for You to Solve

14 Grouping Data 7 topics

Why Group Data?
The GROUP BY Clause
“Some Restrictions Apply”
Uses for GROUP BY
Sample Statements
Summary
Problems for You to Solve

15 Filtering Grouped Data 6 topics

A New Meaning for “Focus Groups”
Where You Filter Makes a Difference
Uses for HAVING
Sample Statements
Summary
Problems for You to Solve

16 Updating Sets of Data 7 topics

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

17 Inserting Sets of Data 6 topics

What Is an INSERT?
The INSERT Statement
Uses for INSERT
Sample Statements
Summary
Problems for You to Solve

18 Deleting Sets of Data 6 topics

What Is a DELETE?
The DELETE Statement
Uses for DELETE
Sample Statements
Summary
Problems for You to Solve

19 “NOT” and “AND” Problems 6 topics

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

20 Condition Testing 5 topics

Conditional Expressions (CASE)
Solving Problems with CASE
Sample Statements
Summary
Problems for You to Solve

21 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

22 Performing Complex Calculations on Groups 9 topics

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

23 Partitioning Data into Windows 8 topics

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

24 Appendix A: SQL Standard Diagrams

25 Appendix B: Schema for the Sample Databases 10 topics

Sales Orders Example Database
Sales Orders Modify Database
Entertainment Agency Example Database
Entertainment Agency Modify Database
School Scheduling Example Database
School Scheduling Modify Database
Bowling League Example Database
Bowling League Modify Database
Recipes Database
“Driver” Tables

26 Appendix C: Date and Time Types, Operations, and Functions 6 topics

IBM DB2
Microsoft Access
Microsoft SQL Server
MySQL
Oracle
PostgreSQL

Prepare for SQL Queries for Mere Mortals Course

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
Certificate of completion

Try Free

No credit card required

SQL Queries for Mere Mortals Course

See exactly what you will learn and practice

Lessons

You might also like

Prepare for SQL Queries for Mere Mortals Course