Write Queries in PostgreSQL, MySQL, SQL Server, Oracle, or SQLite | Crash Course | Beginner | Interview Prepare

Welcome to the EssentialSQL Crash course!  This 7-day course is designed to get you started learning SQL.  I designed it as a seven day course, not because it will take you seven day to complete, but to make it easier for you to digest.  To be honest, work it at any pace you find comfortable.

Here is what we are going to do!

On Day 1, you’ll learn the basics of SQL, including SELECT statements and how to write basic queries. You’ll learn how to select columns and use expressions in your queries. You’ll then have the opportunity to practice what you’ve learned with a set of exercises.

On Day 2, you’ll dive deeper into filtering data with the WHERE clause. You’ll learn about comparison and logical operators and how to use the LIKE operator. You’ll get to apply your newfound skills with a set of practice exercises.

Day 3 is all about sorting data with ORDER BY. You’ll learn how to use the ORDER BY clause and how to sort by multiple columns. You’ll then practice sorting data with a set of exercises.

On Day 4, you’ll learn how to manipulate data with INSERT, UPDATE, and DELETE statements. You’ll learn how to add, modify, and remove data from tables, and then you’ll practice these skills with exercises.

Day 5 is all about aggregating data with GROUP BY. You’ll learn how to use the GROUP BY clause and how to use aggregate functions like COUNT, SUM, AVG, MIN, and MAX. You’ll then have the opportunity to practice what you’ve learned with a set of exercises.

On Day 6, you’ll learn about joining tables. You’ll learn about the INNER join, and how to join multiple tables. You’ll then practice what you’ve learned with a set of exercises.

Finally, on Day 7, you’ll learn about subqueries. You’ll learn what they are and how to use them in SELECT statements and WHERE clauses. You’ll then get to practice your skills with a set of exercises.

By the end of this course, you’ll be starting to learn SQL and be able to write basic queries, manipulate data, and use cool techniques like grouping and joining.

Curso acelerado de SQL

Write Queries in PostgreSQL, MySQL, SQL Server, Oracle, or SQLite | Crash Course | Beginner | Interview Prepare”

Este curso es GRATIS

Curso gratis en Udemy

Con los cursos gratis de Udemy puedes aprender muchas cosas sin tener que gastar en ello. Pero primero debes tener en cuenta varias cosas:

Contenido Gratuito

Los cursos gratis de Udemy te permiten aprender nuevas cosas sin tener que pagar. Aprovecha la oportunidad.

Aprendizaje

Pon en práctica todos tus conocimientos aprendidos. Realiza increíbles proyectos basados en el mundo real.

Limites

Debes tener en cuenta que todos los cursos gratuitos de Udemy son de máximo 2 horas y no incluyen un certificado.

Este curso se encuentra disponible de manera gratuita sin necesidad de ningún cupón, a través de la opción “GRATIS”.

Te recomendamos primero leer las diferencias entre un curso gratis y uno de pago para evitar malentendidos:

Deja tus comentarios y sugerencias

Sobre Facialix

Facialix es un sitio web que tiene como objetivo apoyar en el aprendizaje y educación de jóvenes y grandes. Buscando y categorizando recursos educativos gratuitos de internet, de esta manera Facialix ayuda en el constante aprendizaje de todos.