EssentialSQL: Join Together Now, Write Complex Queries

EssentialSQL: Join Together Now, Write Complex Queries, available at $54.99, has an average rating of 4.55, with 24 lectures, 21 quizzes, based on 125 reviews, and has 849 subscribers.

You will learn about 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. This course is ideal for individuals who are Beginner SQL query authors curious about combining data from multiple tables using SQL joins. or If you're struck writing joins or baffled by outer joins, then this course is for you! or Business analysts looking more ways to write queries. or 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. It is particularly useful for Beginner SQL query authors curious about combining data from multiple tables using SQL joins. or If you're struck writing joins or baffled by outer joins, then this course is for you! or Business analysts looking more ways to write queries. or 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.

Enroll now: EssentialSQL: Join Together Now, Write Complex Queries

Summary

Title: EssentialSQL: Join Together Now, Write Complex Queries

Price: $54.99

Average Rating: 4.55

Number of Lectures: 24

Number of Quizzes: 21

Number of Published Lectures: 24

Number of Published Quizzes: 21

Number of Curriculum Items: 46

Number of Published Curriculum Objects: 46

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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.

Target Audiences

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.

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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the Course

Lecture 2: Why You Should Learn SQL Joins

Lecture 3: What Flavor of SQL Should I Choose?

Lecture 4: How to Take the Course

Lecture 5: Tools Used and Database Setup

Chapter 2: Warmup

Lecture 1: Introduction to Relational Databases

Lecture 2: Do you have any questions?

Chapter 3: Inner Joins

Lecture 1: Inner Join Basics

Lecture 2: Inner Joins Basics – Examples

Lecture 3: Table Aliases

Lecture 4: Multi-Table Joins

Lecture 5: Multi-Table Joins – Examples

Chapter 4: SQL Cross Joins

Lecture 1: What is a Cross Join?

Lecture 2: Cross Join Examples

Chapter 5: Join Conditions

Lecture 1: Joining Two or More Columns

Lecture 2: Joining Two or More Columns Examples

Lecture 3: Non-Equi Joins

Chapter 6: Outer Joins

Lecture 1: Introduction

Lecture 2: Right versus Left Outer Joins

Lecture 3: Full Outer Joins

Lecture 4: Full Outer Joins – Examples

Chapter 7: Self Joins

Lecture 1: What is a Self Join?

Lecture 2: Calculating a Running Total using Self Joins (Intermediate)

Chapter 8: Wrap-up

Lecture 1: Bonus Lecture: Additional Resources and Course Coupons

Instructors

Kris Wenzel
Let me teach you SQL using simple to understand English.
Essential Sql
Learn everything you need to use SQL in your next project

Rating Distribution

1 stars: 2 votes
2 stars: 3 votes
3 stars: 14 votes
4 stars: 38 votes
5 stars: 66 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu