###### SQL Queries for Mere Mortals

ISBN: 978-1-64459-369-1uCertify SQL-MM.AB1

Gain in-demand SQL skills and boost your earning potential with SQL Queries for Mere Mortals - the proven course for beginners.

(SQL-MM.AB1) / ISBN : 978-1-64459-369-1This course includes

Lessons

TestPrep

Hands-On Labs

AI Tutor (Add-on)

105
Review

Our best-selling SQL Queries for Mere Mortals solutions course offers a hands-on approach to transforming you into a confident user. We'll break down relational database fundamentals and encourage you to write clear queries that retrieve the exact data you need, rendering it a perfect SQL course for beginners. From filtering results and sorting information to manipulating data sets and working with complex scenarios, you'll gain the practical SQL skills employers value. Learning how to join data from different tables and summarize it effectively will give you the edge in extracting insights and generating reports – putting you on the fast track to career advancement.

- Write clear and concise SQL queries using SELECT statements.
- Filter results effectively with WHERE clauses.
- Sort information for efficient analysis.
- Modify data sets using INSERT, UPDATE, and DELETE statements.
- Apply complex conditions and perform logical evaluations in queries.
- Work with unlinked tables for comprehensive data analysis.
- Compile data from different tables and raw datasets using INNER JOIN, OUTER JOIN, and UNION operators.
- Use GROUP BY and HAVING clauses to categorize and group data.

Get the support you need. Enroll in our Instructor-Led Course.

26+ Lessons | 414+ Exercises | 140+ Quizzes | 121+ Flashcards | 121+ Glossary of terms

83+ Pre Assessment Questions | 2+ Full Length Tests | 83+ Post Assessment Questions | 165+ Practice Test Questions

45+ LiveLab | 45+ Video tutorials | 55+ Minutes

1

- 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

2

- Types of Databases
- A Brief History of the Relational Model
- Anatomy of a Relational Database
- What’s in It for You?
- Summary

3

- Why Is this Lesson Here?
- Why Worry about Sound Structures?
- Fine-Tuning Columns
- Fine-Tuning Tables
- Establishing Solid Relationships
- Is That All?
- Summary

4

- 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

5

- 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

6

- 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

7

- 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

8

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

9

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

10

- 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

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

12

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

13

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

14

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

15

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

16

- 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

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

18

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

19

- 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

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

21

- What Is Unlinked Data?
- Solving Problems with Unlinked Data
- Solving Problems Using “Driver” Tables
- Sample Statements
- Summary
- Problems for You to Solve

22

- 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

- 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

A

B

- 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

C

- IBM DB2
- Microsoft Access
- Microsoft SQL Server
- MySQL
- Oracle
- PostgreSQL

5

- Using the SELECT Statement
- Using the DISTINCT Keyword
- Using the ORDER BY Clause

6

- Using the CAST Function
- Using a Literal
- Using the Concatenation Expression
- Using the NULL Values
- Naming an Expression
- Finding Null Values in a Column

7

- 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

8

- Using the UNION Operator
- Using the EXCEPT Operator
- Using the INTERSECT Operator

9

- Using an INNER JOIN
- Using a Subquery with the IN Predicate

10

- Using the FULL OUTER JOIN
- Using the RIGHT OUTER JOIN
- Using the LEFT OUTER JOIN

11

- Sorting with UNION

12

- Using Subqueries
- Using the COUNT Function
- Using the SOME Predicate
- Using the ALL predicate
- Using the ANY Predicate

13

- Using the MIN and MAX Functions
- Using the SUM and AVG Functions

14

- Using the GROUP BY Clause

15

- Using the HAVING Clause

16

- Using the UPDATE Statement

17

- Using the INSERT Statement

18

- Using the DELETE Statement

19

- Using the NOT EXISTS Command

20

- Using the CASE Statement

22

- Using ROLLUP
- Using the CUBE clause

23

- Using the RANK Function

Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now