Complex Retrieval Queries in MySQL Workbench

4.5
estrellas
19 calificaciones
ofrecido por
Coursera Project Network
En este proyecto guiado, tú:

Practice problem-solving skills in SQL query building.

Generate a complex retrieval query using SQL code.

Verify complex query results.

Clock80 minutes
IntermediateIntermedio
CloudNo se necesita descarga
VideoVideo de pantalla dividida
Comment DotsInglés (English)
LaptopSolo escritorio

In this intermediate-level course you will use MySQL Workbench to expand your basic SQL query-writing skills with more complex examples and activities. In hands-on activities in MySQL Workbench, you will write and execute SQL queries that retrieve data from multiple tables. In addition, you will generate queries that summarize data and perform calculations. Nested queries and SQL scripting rounds out the course content. While the course concentrates on query writing, you also get a taste of the problem-solving and data analysis efforts required for complex query construction and query results verification. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Habilidades que desarrollarás

Mysql WorkbenchAggregate FunctionSQLNested QuerySQL Scripting

Aprende paso a paso

En un video que se reproduce en una pantalla dividida con tu área de trabajo, tu instructor te guiará en cada paso:

  1. Database Review

  2. Join with the WHERE Clause

  3. Join with the JOIN Statement

  4. Grouping, Summing, Counting, and More

  5. Nested Queries

  6. The Kitchen Sink Script

  7. Check Your Results

Cómo funcionan los proyectos guiados

Tu espacio de trabajo es un escritorio virtual directamente en tu navegador, no requiere descarga.

En un video de pantalla dividida, tu instructor te guía paso a paso

Preguntas Frecuentes

Preguntas Frecuentes

¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.