SQL-MM.AB1
SQL Queries for Mere Mortals
Gain in-demand SQL skills and boost your earning potential with SQL Queries for Mere Mortals - the proven course for beginners.
- Practice in 45 Laboratorios prácticos — nothing to install
- 26 Lecciones interactivas y 175 topics mapped to the official exam objectives
- 516 Preguntas del examen de práctica y 2 Pruebas completas
Intermediate A tu propio ritmo · 1 año de acceso 4.9/5 (105 Revisar)
45 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
26Lecciones interactivas
175Topics
45Laboratorio en vivo
516Preguntas del examen de práctica
120Tarjetas didácticas
120Glosario de términos
01 / Habilidades que obtendrás
What you will be able to do
Try Free →
No se requiere tarjeta de crédito
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.
Course Highlights
-
26 Lecciones estructuradas Cobertura completa de los objetivos principales del curso
-
45 LiveLabs prácticos Escenarios interactivos guiados con evaluación instantánea
-
516 Preguntas de práctica Pruebas de evaluación con justificaciones de respuesta detalladas
-
1 año de acceso completo Aprendizaje a tu propio ritmo, accesible en cualquier momento y en todos los dispositivos
02 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
26 Lecciones interactivas · 175 topics01 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 · 3 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
06 Getting More Than Simple Columns 10 topics · 6 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
07 Filtering Your Data 8 topics · 10 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
08 Thinking in Sets 7 topics · 3 Laboratorio en vivo +
- What Is a Set, Anyway?
- Operations on Sets
- Intersection
- Difference
- Union
- SQL Set Operations
- Summary
3 Laboratorio en vivo in this lesson — see the labs panel →
09 INNER JOINs 6 topics · 2 Laboratorio en vivo +
- What Is a JOIN?
- The INNER JOIN
- Uses for INNER JOINs
- Sample Statements
- Summary
- Problems for You to Solve
2 Laboratorio en vivo in this lesson — see the labs panel →
10 OUTER JOINs 7 topics · 3 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
11 UNIONs 6 topics · 1 Laboratorio en vivo +
- What Is a UNION?
- Writing Requests with UNION
- Uses for UNION
- Sample Statements
- Summary
- Problems for You to Solve
1 Laboratorio en vivo in this lesson — see the labs panel →
12 Subqueries 7 topics · 5 Laboratorio en vivo +
- What Is a Subquery?
- Subqueries as Column Expressions
- Subqueries as Filters
- Uses for Subqueries
- Sample Statements
- Summary
- Problems for You to Solve
5 Laboratorio en vivo in this lesson — see the labs panel →
13 Simple Totals 5 topics · 2 Laboratorio en vivo +
- Aggregate Functions
- Using Aggregate Functions in Filters
- Sample Statements
- Summary
- Problems for You to Solve
2 Laboratorio en vivo in this lesson — see the labs panel →
14 Grouping Data 7 topics · 1 Laboratorio en vivo +
- Why Group Data?
- The GROUP BY Clause
- “Some Restrictions Apply”
- Uses for GROUP BY
- Sample Statements
- Summary
- Problems for You to Solve
1 Laboratorio en vivo in this lesson — see the labs panel →
15 Filtering Grouped Data 6 topics · 1 Laboratorio en vivo +
- A New Meaning for “Focus Groups”
- Where You Filter Makes a Difference
- Uses for HAVING
- Sample Statements
- Summary
- Problems for You to Solve
1 Laboratorio en vivo in this lesson — see the labs panel →
16 Updating Sets of Data 7 topics · 1 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
17 Inserting Sets of Data 6 topics · 1 Laboratorio en vivo +
- What Is an INSERT?
- The INSERT Statement
- Uses for INSERT
- Sample Statements
- Summary
- Problems for You to Solve
1 Laboratorio en vivo in this lesson — see the labs panel →
18 Deleting Sets of Data 6 topics · 1 Laboratorio en vivo +
- What Is a DELETE?
- The DELETE Statement
- Uses for DELETE
- Sample Statements
- Summary
- Problems for You to Solve
1 Laboratorio en vivo in this lesson — see the labs panel →
19 “NOT” and “AND” Problems 6 topics · 1 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
20 Condition Testing 5 topics · 1 Laboratorio en vivo +
- Conditional Expressions (CASE)
- Solving Problems with CASE
- Sample Statements
- Summary
- Problems for You to Solve
1 Laboratorio en vivo in this lesson — see the labs panel →
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 · 2 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
23 Partitioning Data into Windows 8 topics · 1 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
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
Laboratorios prácticos Our edge
45 Laboratorio en vivos- 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
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
03 / Preguntas frecuentes
Preguntas antes de empezar
I have no prior SQL experience. Is this course right for me?+
Absolutely! This course is designed for beginners with no prior SQL knowledge. We'll build your skills step-by-step using the SQL training online course as a foundation.
What are the benefits of learning SQL?+
Employers across various industries are actively seeking advanced SQL skills in the candidates. By mastering SQL, you'll be able to efficiently extract and analyze data, generate reports, and answer critical business questions – all valuable skills that can lead to better career opportunities and potentially higher earning potential.
What outcomes can I achieve after completing this course?+
You'll be able to write clear and effective SQL queries to retrieve, filter, manipulate, and analyze data from relational databases. You'll also be comfortable working with complex queries involving multiple tables and data summarization.
Does this course include hands-on exercises? +
Yes! The course is rich with hands-on exercises that will solidify your understanding of the concepts and develop your practical SQL skills for real-world scenarios.
What software do I need for this course?+
You don’t need to install or buy a software program/ license to access its hands-on labs. Our platform is a completely web-hosted solution, which can be accessed from any device through browser.
Learn SQL For Database Management The Easy Way
We'll show you how to join data from different tables for a complete picture and use summarization tools to generate hidden insights.
- 1 año de acceso completo
- 45 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito