EssentialSQL: Join Together Now, Write Complex Queries

In this Course you will Learn to:

• Write join statements that work with MySQL, PostgreSQL, SQL Server, Oracle, and SQLite.

• Write Inner Joins.

• Learn to write outer joins, and know the difference between a right and left outer join.

• Understand when and how to use a full outer join.  You even be able to reproduce the result of a full outer join using other statements!

• Learn about other types of joins such as self joins, cross joins, non-equi joins, and outer joins, and when it is appropriate to use them.

• Use different types of joins to solve real-world query problems.

• Understand the key differences between inner and outer joins.

• Use non-equi joins to solve interesting problems such as calculating running totals.

• Combine columns from two or more tables into a single result.

• Know when to use an outer join.

  
  

Learning SQL Should Not Be Out of Your Reach

With so much information available on the Internet it's easy to get confused. You want to continue learning SQL but don't know where to start. SQL is deceptive, mysterious, especially if not explained well.

But it doesn’t have to be this way!

Nothing is worse than

• Being excited to learn something new but not knowing where to start.

• Wasting time learning the wrong features.

• Being overwhelmed with options and not know which to use.

  
  

Imagine Having

• Knowledge - Knowing how to quickly use joins to take your SQL to the next level.

• Confidence - Feeling good that you’re on the right track.

• Accomplishment - Having a sense of accomplishment that you've learned something most cannot.

• Fun - Having fun learning SQL inner and outer joins!

  
  

By the time you’ve completed this course you’ll have an appreciation of joins, overcome your fear, and able to write queries combining data from multiple tables.

Now that’s cool!