Read more
Appropriate for beginning to intermediate courses on SQL, as well as introductory courses on database-enabled Web development.
SQL: Visual QuickStart Guide is the ideal introduction to SQL for programming students, Web development students, and others with little or no database programming experience. Veteran database developer Chris Fehily teaches SQL with exceptional clarity, using the proven Visual QuickStart format: step-by-step explanations, practical tips, and hundreds of screen captures that demonstrate exactly what students will see and what they should do. The book begins with a practical, easy-to-understand overview of databases, the relational model, and SQL's goals. Fehily covers fundamental SQL techniques, including retrieving data from single and multiple tables; using operators and functions; summarizing and grouping data; creating subqueries; inserting, updating, and deleting rows; creating, altering, and dropping tables; and more. Fehily concludes by introducing three more advanced SQL techniques: indexes, views, and transactions. SQL: Visual QuickStart Guide covers the latest ANSI SQL standard, while adding tips for making the most of popular proprietary database management systems. The book's companion Web site includes a sample database used in all the book's examples.
