Table Joins in Microsoft SQL Sever

In this tutorial I will explain and demonstrate the three main categories of joins in SQL Server. These are Inner Joins, Outer Joins & Cross Joins. I will also cover using the Query Editor tool which is SQL Server's graphical tool for creating SQL code. Then to wrap up, the tutorial, I will show you how to join three or more tables. The code to create the database and tables used in this tutorial are available at www.analyticsinaction.com/joins/ As a FYI, joins is a topic in the "Querying Microsoft SQL Server Exam, - 70-461". This is the first exam in the Business Intelligence Certification. In this tutorial I will cover off joins in enough detail to satisfy the exam requirements. I also have a comprehensive 60 minute T-SQL course available at Udemy : www.udemy.com/t-sql-for-data-analysts/?couponCode=…

• #education
• #sql_server_tables_joins_inner_join_outer_joins_full_outer_joins
• #microsoft_sql_server_database_management_system
• #query_editor