Home About Courses Schedule Services Webinars Contact Search

Writing SQL Joins, Subqueries and Set Operations

SEE SCHEDULE

Duration: 1.5 Day

Method: Instructor-led. Hands-on Workshops.

Price: $750.00

Course Code: SQ2000


Audience

Programmers, Analysts, Database Administrators, and Users who must access data in a relational database.

Description

This course provides a thorough look into writing efficient SQL joins, subqueries, and set operations against relational databases such as Db2, Oracle, SQL Server and PostgreSQL. The course will explore both inner and outer joins along with using subqueries in various places within various types of SQL statements. Lastly the course will look into using set operatorssuch as UNION, INTERSECT and EXCEPT/MINUS. Coding examples and workshops serve to reinforce the material presented in class.

Prerequisites

None

Topics

  • I. Multi-Table Operations (Joins)
    • Inner Joins
    • Outer Joins
      • Using the (+) Operator in Oracle
    • ANSI Join Syntax
      • INNER JOIN
      • OUTER JOIN
      • JOIN USING
      • NATURAL JOIN
    • Join Considerations
  • II. Subqueries
    • Non-Correlated
    • Correlated
      • Using the EXISTS/NOT EXISTS Operators
    • Usages
      • WHERE Clause
      • FROM Clause
      • SELECT Expression
      • WITH Clause (Subquery Factoring Clause)
      • DML Statements
    • Behavior and Benefits
  • III. Set Operations
    • UNION, UNION ALL
    • INTERSECT, INTERSECT ALL
    • EXCEPT / MINUS, EXCEPT ALL/ MINUS ALL
    • Behavior and Usage