Essential Sql - Join Together Now, Write Complex Queries

Learn to combine data from multiple tables using inner & outer sql joins. Master database joins, write awesome queries.

What you'll learn

Write queries to combine data from two or more database tables.

Understand the difference between an inner and outer join.

Have the confidence to use joins in t-sql queries.

Learn to simplify complex SQL statement with table aliases

Overcome one of the major stumbling blocks stopping you from mastering SQL.

Requirements

You should already be familiar with SELECT, GROUP BY, and ORDER BY clauses

Access to a PC running Windows 7, 8, or 10

Description

Learning SQL Should Not Be Out of Your ReachWith 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!In this Course you will Learn to:· 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.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!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 What is a Join?

Lecture 3 Writing your First Join

Section 2: Setup Your Learning Lab (Optional)

Lecture 4 Download SQL Server

Lecture 5 Install SQL Server

Lecture 6 Download and Install SSMS

Lecture 7 Download Sample Databases

Lecture 8 Restore Sample Databases

Section 3: Inner Joins

Lecture 9 Basics

Lecture 10 Table Aliases and multi Table Joins

Lecture 11 Do you have any questions?

Section 4: Cross Joins

Lecture 12 What is a Cross Join?

Section 5: Join Conditions

Lecture 13 Joining Two or More Columns

Lecture 14 Non-Equi Joins

Section 6: Outer Joins

Lecture 15 Introduction

Lecture 16 Right versus Left Outer Joins

Lecture 17 Full Outer Joins

Lecture 18 Uses for Outer Joins

Section 7: Self Joins

Lecture 19 What is a Self Join?

Lecture 20 Calculating a Running Total using Self Joins (Intermediate)

Section 8: Wrap-up

Lecture 21 Bonus Lecture: Additional Resources and Course Coupons

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!