Summary

Team-Fly

---

 

	DB2 Universal Database for OS/390 v7.1 Application Certification Guide By Susan Lawson
	Table of Contents
	Chapter 4.  Advanced SQL Coding

---

Summary

In the chapter we looked at some of the advanced features of SQL, including all the different types of joins: inner, left outer, right outer, and full outer. Star joins, which are used in support of star schemas, were also examined.

SQL can become very useful for solving complex business problems by using such features as CASE expressions, nested table expressions, UNIONs and subqueries. These features allow us to push a lot of business logic into the SQL statement.

---

Team-Fly

Top