Beginning SQL
Published on 16. February 2005
520 pages
978-0-7645-9632-2 (ISBN)
Description
* Taking readers through the basics of the language, right up tosome more advanced topics, this book is a practical, hands-onresource and aims to keep the reader involved at all times
* Focuses on the SQL standard and is loaded with detailedexamples and code; each chapter includes practice exercises thatreaders can challenge themselves with before looking at the samplesolutions in the appendix
* Paul Wilton is a successful Wrox "Beginning" book author and isan ideal author to write for those who want a firm grasp ofstandard SQL before learning the details specific to a particulardatabase product
* SQL is an international standard for manipulating data indatabases and is used by database programmers in all major databasesystems: Microsoft, IBM, Oracle, MySQL, and many others
More details
Other editions
Additional editions
Paul Wilton | John Colby
Beginning SQL
Book
03/2005
1st Edition
Wrox Press
€33.90
Shipment within 15-20 days
Persons
Paul Wilton has been working professionally as aprogrammer for over 6 years. He is experienced with SQL, databasedesign, development and deployment, as well as RDBMS systemsincluding SQL Server and Access. He is currently working freelancedeveloping functionality for websites database driven web sitesincluding e-commerce, message boards, chat applications, and more.His most recent work includes a case tracking system for a law firmand an online booking system for a holiday cottage rental company.
John Colby is database consultant providing databaseanalysis and design as well as Access, SQL Server, and VisualFoxpro programming to companies in the United States, Mexico, andEurope.
Content
About the Authors.
Acknowledgments.
Introduction.
Chapter 1. Introduction to SQL.
Chapter 2. Entering Information.
Chapter 3. Extracting Information.
Chapter 4. Advanced Database Design.
Chapter 5. Manipulating Data.
Chapter 6. Grouping and Aggregating Data.
Chapter 7. Selecting Data from Different Tables.
Chapter 8. Queries within Queries.
Chapter 9. Advanced Queries.
Chapter 10. Views.
Chapter 11. Transactions.
Chapter 12. SQL Security.
Chapter 13. Database Tuning.
Appendix A: Exercise Answers.
Appendix B: Setting up and Using the Five Database Systems
Appendix C: Initial Data Setup.
Index.
