by Chris Fehily (Author)
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..
Format: Paperback
Pages: 480
Edition: 2
Publisher: Peachpit Press
Published: 12 May 2005
ISBN 10: 0321334175
ISBN 13: 9780321334176
Book Overview: As dynamic, database-driven Web sites become the standard, more and more nonprogrammers are being forced to create and edit database objects. With SQL and this task-based guide to it, they can--no programming experience required! After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily immediately launches into the tasks that will get readers comfortable with SQL. In addition to covering all the SQL basics, this thoroughly updated reference contains a wealth of brand-new information--from new chapters on set operations and common tasks to wellplaced Optimization Tip sidebars, added IBM DB2 coverage, and a slew of new appendixes (Advanced Features, Resources, Key Words, Syntax Quick Reference, Glossary). Best of all, the book's companion Web site includes the sample database used in all of the book's examples so that readers can put their knowledge to work on a real database immediately.
FREE UK DELIVERY 
Global shipping from £2.99
FREE UK DELIVERY
30 Day Refund Guarantee
