Home > Topics > Data > SQL

SQL

Articles

SQL Queries for Mere Mortals: Thinking in Sets
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.
Continue reading...
By Michael J. Hernandez, John ViescasJul 1, 2014
Ben FortaRetrieving Data with the SQL SELECT Statement
In this lesson, you’ll learn how to use the SELECT statement to retrieve one or more columns of data from a table.
Continue reading...
By Ben FortaDec 10, 2012
SQL Standards and Guidelines for DB2 Developers
This chapter shows how to create a set of SQL standards and guidelines for developers to follow when running applications that involve DB2.
Continue reading...
By Tony AndrewsOct 15, 2012
Managing SQL Database Objects
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.
Continue reading...
By Arie D. Jones, Ron D. Plew, Ryan StephensJun 16, 2011

See More SQL Articles