- This event has passed.
Oracle SQL Joins: The Options, Results, and Syntactical Variations
May 26, 2021 @ 9:00 am - 10:00 am EDT
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)
Basic Oracle SQL developer skills will be needed including experience with coding simple to advanced SQL Joins.
Oracle Database Developers. DBAs can also benefit if they are not familiar with the join options Oracle provides.
John Watson, Oracle Certified Master DBA, SkillBuilders Director of All Things Oracle Database
Dave Anderson, SkillBuilders’ Founder, Oracle DBA
Barring any technical glitches, all webinars are recorded and posted as tutorials. See all tutorials HERE
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!
All dates are in Eastern Time (ET).