SQL Visual QuickStart Guide 2nd edition

1,410 views

As dynamic, database-driven Web sites become the standard, more and more nonprogrammers just like yourself are being forced to work with database information and create and edit database objects. With SQL and this task-based guide to it, you can do it too–no programming experience required!After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily launches into the tasks that will get you comfortable with SQL fast. In addition to explaining SQL basics, this updated reference covers the ANSI SQL:2003 standard and contains a wealth of brand-new information, including a new chapter on set operations and common tasks, well-placed optimization tips to make your queries run fast, sidebars on advanced topics, and added IBM DB2 coverage.

Best of all, the book’s examples were tested on the latest versions of Microsoft Access, Microsoft SQL Server, Oracle, IBM DB2, MySQL, and PostgreSQL. On the companion Web site, you can download the SQL scripts and sample database for all these systems and put your knowledge to work immediately on a real database.

SQL is the standard programming language for creating, updating, and retrieving information that is stored in databases. With SQL, you can turn your ordinary questions (”Where do our customers live?”) into statements that your database system can understand (SELECT DISTINCT city, state FROM customers;). You might already know how to extract this type of information by using a graphical query or reporting tool, but perhaps you’ve noticed that this tool becomes limiting or cumbersome as your questions grow in complexitythat’s where SQL comes in.

You also can use SQL to add, change, and delete data and database objects. All modern relational database management systems (DBMSes) support SQL, although support varies by product (more about that later in this chapter).

TABLE OF CONTENT:
Chapter 01 - DBMS Specifics
Chapter 02 - The Relational Model
Chapter 03 - SQL Basics
Chapter 04 - Retrieving Data From a Table
Chapter 05 - Operators and Functions
Chapter 06 - Summarizing and Grouping Data
Chapter 07 - Joins
Chapter 08 - Subqueries
Chapter 09 - Set Operations
Chapter 10 - Inserting, Updating, and Deleting Rows
Chapter 11 - Creating, Altering, and Dropping Tables
Chapter 12 - Indexes
Chapter 13 - Views
Chapter 14 - Transactions
Appendix A - Creating the Sample Database
Appendix B - SQL Keywords

Download here

Password: ganelon