Oracle SQL Joins: The Options, Results, and Syntactical Variations

REGISTER FOR THIS WEBINAR

Description

We write queries that join tables every day. Therefore it is essential that we understand the options and syntax that are available. 

This webinar will explain (with demonstrations) all the join options:

Inner, outer, full, anti, equi, cross, natural, and more.  

You will learn what they mean, what they do and under what conditions you will want to use them.  You’ll learn the syntax possibilities, the result sets they (should be) generating, and some bugs that may be buried in the code, waiting to bite.

Note: this is not a webinar on tuning joins. Refer to our Free YouTube Tutorial “How to Tune Joins” for great information on tuning joins (also taught by OCM John Watson)

Prerequisite Knowledge

Basic Oracle SQL developer skills will be needed including experience with coding simple to advanced SQL Joins. 

Intended Audience

Oracle Database Developers. DBAs can also benefit if they are not familiar with the join options Oracle provides. 

Presenters 

John Watson, Oracle Certified Master DBA, SkillBuilders Director of All Things Oracle Database

Dave Anderson, SkillBuilders’ Founder, Oracle DBA

Recording

Barring any technical glitches, all webinars are recorded and posted as tutorials. See all tutorials HERE

Registration 

By registering for the webinar, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time. An extra-special event!