This chapter introduces the concept of an SQL set. It discusses each of the major set operations implemented in SQL in detail (intersection, difference, and union), and shows how to use set diagrams to visualize the problem you’re trying to solve. Finally, it introduces the basic SQL syntax and keywords (INTERSECT, EXCEPT, and UNION) for all three operations.
In this lesson, you’ll learn how to use the SELECT statement to retrieve one or more columns of data from a table.
This chapter shows how to create a set of SQL standards and guidelines for developers to follow when running applications that involve DB2.
In this chapter you will learn about database objects: what they are, how they act, how they are stored, and how they relate to one another.
Is your information ready for the next 20 years? Traenk gives more information on what you must understand when creating a Data Migration Strategy, something all organizations, businesses, and people must create.