Learning SQL

石头

作者：Alan Beaulieu
出版日期：August 2005
出版社：O'Reilly
页数：306
ISBN：0596007272
文件格式：CHM


SQL(Structured Query Language) is a standard programming language forgenerating, manipulating, and retrieving information from a relationaldatabase. If you’re working with a relational database–whether you’rewriting applications, performing administrative tasks, or generatingreports–you need to know how to interact with your data. Even if youare using a tool that generates SQL for you, such as a reporting tool,there may still be cases where you need to bypass the automaticgeneration feature and write your own SQL statements.
To help you attain this fundamental SQL knowledge, look to Learning SQL, an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language.
Learning SQLmoves you quickly through the basics and then on to some of the morecommonly used advanced features. Among the topics discussed:

• The history of the computerized database
• SQL Data Statements–those used to create, manipulate, and retrievedata stored in your database; example statements include select,update, insert, and delete
• SQL Schema Statements–those used to create database objects, such as tables, indexes, and constraints
• How data sets can interact with queries
• The importance of subqueries
• Data conversion and manipulation via SQL’s built-in functions
• How conditional logic can be used in Data Statements

Best of all, Learning SQLtalks to you in a real-world manner, discussing various platformdifferences that you’re likely to encounter and offering a series ofchapter exercises that walk you through the learning process. Wheneverpossible, the book sticks to the features included in the ANSI SQLstandards. This means you’ll be able to apply what you learn to any ofseveral different databases; the book covers MySQL, Microsoft SQLServer, and Oracle Database, but the features and syntax should applyjust as well (perhaps with some tweaking) to IBM DB2, Sybase AdaptiveServer, and PostgreSQL.
Put the power and flexibility of SQL to work. With Learning SQL you can master this important skill and know that the SQL statements you write are indeed correct.

Jamesliu2009