EssentialSQL: Join Together Now, Write Complex Queries
What you'll 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.
Description
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!
Who this course is for:
- 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.
Featured review
Instructors
- 4.5 Instructor Rating
- 1,850 Reviews
- 12,640 Students
- 9 Courses
If you're interested in learning SQL, you're in the right place.
I'm here to help you build a strong foundation in all aspects of SQL: from the very first steps to complex data architectures and designs. Many people struggle with where to begin learning SQL, but you don’t have to!! Essential SQL is my platform for bringing all aspects of SQL to you.
With more than 30 years of experience in SQL and a degree in Computer Engineering from the University of Michigan, I am passionate about helping others learn this valuable skill. As a blogger, I share SQL tips and how-to articles with over a million readers each year on my blog, Essential SQL. In addition, I have been teaching online for over eight years to people from various industries, including accounting, purchasing, and human resources.
In my professional life, I work with large corporations to design data warehouses that support business intelligence and data science activities. I believe that SQL is a valuable skill that is within reach for anyone, and my courses are designed to help you learn and grow with the technology.
So, what will you get out of my courses?
You will learn SQL from the ground up and progress to advanced concepts. Whether you are a beginner with no prior experience in SQL or looking to expand your knowledge and skills, these courses are tailored to meet your needs.
One of the key features of my courses is the hands-on experience and exercises that I provide. Instead of just talking about concepts and theories, I believe that the best way to learn is by doing. That's why my courses are packed with practical exercises that allow you to apply what they have learned and see the results for yourself.
As you work through my courses, I will be with you every step of the way to provide guidance and support. I will walk you through the very basics of SQL, such as selecting data from tables and filtering results, and then progress to more advanced topics like creating and modifying tables, working with data types, and using built-in functions. By the end of the course, you will have a solid understanding of SQL and be able to apply what you have learned to real-world situations.
In short, my Essential SQL courses offer a comprehensive and practical learning experience that will take you from the very basics to advanced concepts in SQL. Whether you are looking to improve your career prospects, solve problems more efficiently, or just want to learn more about this powerful language, my courses have you covered.
What are Students Saying?
For the lessons I have covered so far, the instructor is doing a great job in explaining key concepts of stored procedure with several examples of SQL statements to refine business logic. Pretty cool -- Billandre O.
Teaching style is really practical. It takes a depth of topical understanding to reduce the topic to an accessible form. He’s got those skillz – Mathew C
I like the way Kris teaches delicate subjects in simple English. This course helps students and beginners to better understand Database Design and Data Modeling. I highly recommend it to start your journey in the relational database world. – Radouane B
So far this course teach me in a very short of time how to get confidence with Stored Procedures. I need to learn the subject quick for a job interview . But it's not only basic staff. The lecture gave important example and teach us to use it in the most advantage way for SQL. – Yael M.
Excellent course with clear explanations. The instructor had an easy and likeable approach that comprehensively answered how to wield the power of the subquery. Highly recommended. – Andre M
So what are you waiting for? Enroll in one of my courses today.
See you in class.
Kris
- 4.5 Instructor Rating
- 1,745 Reviews
- 9,497 Students
- 7 Courses
Welcome to EssentialSQL, where we believe in the power of hands-on learning to master SQL. If you're a business analyst feeling overwhelmed by the abundance of information available on the internet, we're here to help.
Our courses are designed to give you the guidance and support you need to succeed, using simple and easy-to-understand language.
You'll learn at the right time and in the right order, with expert instruction and motivation to keep you on track. And if you ever have any questions, our team is here to answer them and help you succeed.
Here's what you can expect from our courses:
· A clear and structured learning path, so you can learn at the right time and in the right order
· Expert instruction to help you work smarter and avoid missing deadlines
· Support and motivation to keep you on track and motivated to learn new skills Don't let learning SQL feel out of reach.
Ready to get started? Enroll now and start learning SQL with EssentialSQL.