The Language of SQL — Larry Rockoff (2011)

Book Description

An understanding of SQL is necessary for both the Information Systems professionals and other business analysts who need to create reports against data in relational databases. Most SQL texts attempt to serve as an encyclopedic reference on SQL syntax. This approach is counterproductive, since this information is readily available in online references published by the major database vendors. For the beginning user or student, it’s more important to focus on general concepts and to offer clear explanations and examples of what the various statements can accomplish. THE LANGUAGE OF SQL allows users to learn SQL as they would learn a foreign language. SQL keywords are presented in a logical progression, from simple to more complex, allowing the reader to gain a sense of accomplishment as they learn new words. There is also an emphasis on statements and strategies pertaining to data retrieval. Readers are led through a sequence of chapters covering SQL syntax, from basic data retrieval to Boolean logic to table joins and subqueries. Final chapters discuss data updates, database design, and strategies for displaying data. Scripts will run in each of the 3 databases covered in the book: Microsoft SQL Server, MySQL, and Oracle. The book provides instructions on how to obtain and install free versions of those databases for testing.

Book Details

• Author: Larry Rockoff
• Publisher: Cengage
• Published Date: 2011
• Published Year: 2011
• Language: English
• ISBN-13: 9781435457515