EssentialSQL: Join Together Now, Write Complex Queries

Learn INNER, OUTER, LEFT, RIGHT, SELF, & CROSS JOINS | use JOIN and ON clauses | SQL Query for Multiple Tables | T SQL

Created by: Kris Wenzel
Let me teach you SQL using simple to understand English.

Created by: Essential Sql
Learn everything you need to use SQL in your next project

What Will I Learn?

• Completely revamped course, fully reproduced videos, new exercises, and more!
• Understand the different types of joins available in SQL Server, including inner joins, outer joins, and cross joins.
• Know how to use the JOIN clause to combine rows from multiple tables based on a common column.
• Understand how to use the ON and clause to specify join conditions.
• Know how to use self-joins to join a table to itself.
• Create queries using either MySQL, PostgreSQL, or SQL Server.
• Learn to simplify complex SQL statement with table aliases
• Overcome one of the major stumbling blocks stopping you from mastering SQL.

Requirements

• If you can write a simple GROUP BY statement with HAVING, then you are ready for this course.
• No special equipment needed, all exercises are done online.
• Optional: Install a MySQL, PostgreSQL, or SQL Server learning lab on your own computer.

Target audience

• Beginner SQL query authors curious about combining data from multiple tables using SQL joins.
• If you're struck writing joins or baffled by outer joins, then this course is for you!
• Business analysts looking more ways to write queries.
• If you're having a hard time understanding the ins and outs of SQL joins, then this course is for you as I explain it to you in simple to understand English.