SQL : Basic and Advanced Queries

About the Webinar

Users of relational databases want all the data they need at their fingertips, while the database designers want to responsibly “decompose” the data into the smallest possible and most efficient tables. There’s always a tension between ease and efficiency at scale. SQL Join satisfyingly bridges this tension, giving you the power to derive tables that contain exactly the data you need.

SQL Join generates a new (temporary or permanent) table from one or more tables by combining columns based on the way the Join is invoked. There’s also a “self-join” variant to groom an unruly table into something more manageable.

Agenda

1. Introduction to Joins
2. Types of SQL Joins
3. Understanding utility of each join
4. Implementation of various Joins