Join us May 11th @ 12 pm PST – Steve Stedman will teaching a FREE lesson on SQL Server Join Types.
TSQL joins – what’s the difference, and how can you use joins correctly? Sometimes an inner join is the right join type to use, other times the left outer join, right outer join, full outer join, cross join or self join may be what you are looking for. In this session you will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the same results with better performance. You will take home the right foundations to get at the data that you want.
Here’s what you’ll learn:
- What is a JOIN
- Inner join
- Left outer join
- Right outer join
- Full outer join
- Cross join
- Self join
- Use Samples
Intended Audience:
Database programmers and new administrators who are familiar with TRANSACT SQL, may know simple joins, who would like to know more about OUTER JOINS, LEFT JOINS, RIGHT JOINS, CROSS JOINS, and SELF JOINS.
Don’t miss this amazing opportunity to learn SQL Join Types from a great teacher!
Pssst …… there will be questions and a prize giveaway towards the end of the presentation
Comes Complete with:
• Easy to understand lectures with examples
• Assignments
• Sample code to work with
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!