You will review some of the most commonly used SQL commands to ensure you are prepared to tackle both real-world problems as well as every exercise covered in this course.

Essential SQL

Review the essentials

Practice the essentials

Transforming your results

Transform numeric & strings

Extract what you need

Working with aggregate functions

Aggregating finances

Aggregating strings

Which tables?

Use Real-World SQL

How do you find the data you need in your database in order to answer real-world business questions?  Here you will learn how to use system tables to explore your database. You will use these tables to create a new tool that contains a list of all tables and columns in your database. Finally, you will create an Entity Relationship Diagram (ERD) which will help you connect multiple tables.

Find the right table

LIMITing your search

Which table to use?

What tables are in your database?

Determine the monthly income

Join the correct tables

What columns are in your database?

A VIEW of all your columns

Testing out your new VIEW

The average length of films by category

Complex joins

Build the entity relationship diagram

Which films are most frequently rented?

Find Your Data

Working with SQL to solve real-world problems will oftentimes require you to do more than retrieve the data you need, oftentimes you will need to manage the data in your database. This includes creating data, updating it and, when necessary, deleting it.

Almacena tus datos

Almacenar datos nuevos

Usar datos existentes

TABLE vs VIEW

Actualiza tus datos

¿Qué deberías modificar?

Actualiza el precio de los alquileres

Actualización basada en otras tablas

Elimina tus datos

Eliminar todos los datos de una tabla

Eliminar registros seleccionados

Un videoclub apto para familias

Manage Your Data

How do you ensure that the SQL scripts you write will be easy to understand for anyone who needs to read them? This chapter will cover approaches you can leverage to ensure that your code clearly conveys your intent, is readable by others and follows best practices.

Convey your intent

How to convey our intent

Clarify the intent of this query

Fix this query - intent

Write readable code

How to make code easier to read

Make this query easier to read - Part I

Make this query easier to read - Part II

Avoid common mistakes

What are the don'ts of writing SQL code?

Apply best practices to your code

Recap

Best Practices for Writing SQL

DVD Rental Database

Ahora que ya dominas las herramientas básicas de SQL, estás listo para integrarlas en habilidades prácticas y reales. En este curso, trabajarás con la base de datos de una empresa ficticia de alquiler de películas. El tamaño y la complejidad de esta base de datos te permitirán experimentar de primera mano los retos de trabajar con bases de datos. A lo largo del curso, usarás SQL para responder a preguntas con enfoque empresarial. Aprenderás nuevas habilidades que te ayudarán a encontrar las tablas que necesitas. Después, verás cómo guardar y gestionar estos datos en tablas y vistas que tú mismo crees. Y lo mejor: también aprenderás a escribir código que no solo exprese claramente tu intención, sino que además sea legible.

Data Manipulation in SQL

Encuentra, almacena y gestiona tablas y vistas nuevas, y escribe SQL mantenible para responder preguntas.

Aplicar SQL a problemas del mundo real

Busca tablas, almacena y gestiona nuevas tablas y vistas y escribe código SQL fácil de mantener para responder a preguntas empresariales.

SQL para analistas empresariales

Eliminar registros seleccionados

Aplicar SQL a problemas del mundo real

Instrucciones del ejercicio

ejercicio interactivo práctico