SQL-Queries.AD2
SQL Queries
Master SQL queries to easily extract, manage, and analyze data to increase your efficiency in database tasks.
- Practice in 42 Laboratorios prácticos — nothing to install
- 13 Lecciones interactivas y 56 topics mapped to the official exam objectives
- 274 Preguntas del examen de práctica y 4 Pruebas completas
Intermediate A tu propio ritmo · 1 año de acceso
42 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
13Lecciones interactivas
56Topics
42Laboratorio en vivo
274Preguntas del examen de práctica
111Tarjetas didácticas
111Glosario de términos
01 / Habilidades que obtendrás
What you will be able to do
Try Free →
No se requiere tarjeta de crédito
This SQL queries course will help you efficiently work with databases by teaching you how to write SQL queries. It covers everything from basic tasks like connecting to a database, running simple queries, and saving them, to more advanced topics like performing conditional searches, working with functions, and retrieving data from multiple tables. You’ll learn how to manipulate data, modify table structures, and work with views and indexes. By the end, you’ll have the skills to manage transactions, export query results, and perform advanced querying techniques.
- Connect to SQL databases and execute simple queries for efficient data retrieval
- Save and modify queries to streamline future database tasks
- Perform conditional searches to find specific data with ease
- Utilize functions to calculate dates, aggregate data, and manipulate strings
- Organize data by sorting, ranking, grouping, and filtering for better clarity
- Join and compare data from different sources to conduct in-depth analysis
- Export query results in various formats, including text and XML files
- Implement subqueries to perform advanced data searches and comparisons
- Insert, modify, and delete data to keep databases up-to-date
- Create and modify table structures, including constraints and backing up tables
- Work with views to simplify and organize complex queries
- Index data for faster query performance
- Manage transactions to ensure data integrity during database operations
Course Highlights
-
13 Lecciones estructuradas Cobertura completa de los objetivos principales del curso
-
42 LiveLabs prácticos Escenarios interactivos guiados con evaluación instantánea
-
274 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
13 Lecciones interactivas · 56 topics01 Executing a Simple Query 5 topics · 2 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
02 Performing a Conditional Search 4 topics · 4 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
03 Working with Functions 4 topics · 3 Laboratorio en vivo +
- TOPIC A: Perform Date Calculations
- TOPIC B: Calculate Data Using Aggregate Functions
- TOPIC C: Manipulate String Values
- Summary
3 Laboratorio en vivo in this lesson — see the labs panel →
04 Organizing Data 7 topics · 6 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
05 Retrieving Data from Multiple Tables 4 topics · 3 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
06 Exporting Query Results 3 topics · 2 Laboratorio en vivo +
- TOPIC A: Generate a Text File
- TOPIC B: Generate an XML File
- Summary
2 Laboratorio en vivo in this lesson — see the labs panel →
07 Using Subqueries to Perform Advanced Querying 7 topics · 6 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
08 Manipulating Table Data 3 topics · 1 Laboratorio en vivo +
- TOPIC A: Insert Data
- TOPIC B: Modify and Delete Data
- Summary
1 Laboratorio en vivo in this lesson — see the labs panel →
09 Manipulating the Table Structure 6 topics · 7 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
10 Working with Views 5 topics · 5 Laboratorio en vivo +
- TOPIC A: Create a View
- TOPIC B: Manipulate Data in Views
- TOPIC C: Create Aliases
- TOPIC D: Modify and Delete Views
- Summary
5 Laboratorio en vivo in this lesson — see the labs panel →
11 Indexing Data 3 topics · 2 Laboratorio en vivo +
- TOPIC A: Create Indexes
- TOPIC B: Drop Indexes
- Summary
2 Laboratorio en vivo in this lesson — see the labs panel →
12 Managing Transactions 3 topics · 1 Laboratorio en vivo +
- TOPIC A: Create Transactions
- TOPIC B: Commit Transactions
- Summary
1 Laboratorio en vivo in this lesson — see the labs panel →
13 Appendix A 2 topics +
- The FullerAckerman Database
- Schema
Laboratorios prácticos Our edge
42 Laboratorio en vivos- 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 the 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 a View
- Creating Views with Schema Binding
- Manipulating Data in Views
- Creating Aliases
- Modifying and Deleting Views
- Creating Indexes
- Dropping Indexes
- Creating and Committing Transactions
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
03 / Preguntas frecuentes
Preguntas antes de empezar
Do I need any prior experience with SQL or databases? +
No prior experience is required. This course is intermediate-level-friendly and will guide you step-by-step through the basics of SQL queries and database interactions.
Will I learn how to create and manage databases in this course? +
Yes, you will learn how to create and manage tables, modify table structures, and perform essential database management tasks like inserting, updating, and deleting data.
Can I take this course if I don’t have any programming background? +
Absolutely! The course is designed for intermediate-level learners and no programming language is needed. You’ll learn everything from scratch with clear, easy-to-follow instructions.
What types of databases will I learn to query? +
You will primarily learn to query relational databases, which are the most common type used in industries today. SQL is widely used and applicable to databases like MySQL, SQL Server, and Oracle.
How do SQL queries differ from other data-querying languages?+
SQL is the standard language for managing and querying databases. Unlike some other data querying languages, SQL is specifically designed for structured data and is known for its simplicity and wide industry adoption.
Learn SQL Queries
Gain the skills to write powerful SQL queries that make managing and analyzing data fast and efficient.
- 1 año de acceso completo
- 42 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito