Essential SQL Join Together Now Write Complex 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.
You should already be familiar with SELECT, GROUP BY, and ORDER BY clauses
Access to a PC running Windows 7, 8, or 10
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!
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!
Udemy | English | 2h 34m | 880.34 MB
Created by: Kris Wenzel