Programmers, Analysts, Database Administrators, and Users who must access data in a relational database.
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.