Aldo Jaime Juárez

Exercise 1 with MySQL:ANSWERING QUESTIONS WITH QUERIES

In this video I answer questions creating a Query in MySQL.

Exercise 2 with MySQL:SQL LEFT JOIN

In this video I use LEFT JOIN to create a table with the clients who have transactions and the clients that do not.

Exercise 3 with MySQL:SQL INNER JOIN

In this video I execute an example with columns of four different tables.

Exercise 4 with MySQL:FUNCTIONS, VIEWS AND FILTERS WITH WHERE CLAUSE IN SQL

In this vide, I use fuctions to find new information, I create a VIEW and I use different filters with WHERE.

Exercise 5 with MySQL:NESTED QUERY

In this video I will show you an example of subquery with "INSERT".

Exercise 6 with MySQL:Important steps to understand a database

Describe tables, data types, constraints, EER diagram, cardinality and visualize rows.