Packed with essential code, theories, concepts, and techniques, as well as a cache of useful examples, this comprehensive text will have you quickly designing your own databases and writing SQL code sufficient for many real–world situations. Practice exercises in each chapter help speed up your comprehension. By the end of the book, you'll be prepared to handle any surprise that SQL might throw your way.
What you will learn from this book
Who this book is for
This book is for programmers with some prior programming experience who are seeking to develop their database programming skills using SQL. The book assumes no previous programming experience, so it is also suitable for database programming beginners including database administrators.
Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.
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.
John Colby is database consultant providing database analysis and design as well as Access, SQL Server, and Visual Foxpro programming to companies in the United States, Mexico, and Europe.
Utilizziamo i cookie di profilazione, anche di terze parti, per migliorare la navigazione, per fornire servizi e proporti pubblicità in linea con le tue preferenze. Se vuoi saperne di più o negare il consenso a tutti o ad alcuni cookie clicca qui. Chiudendo questo banner o proseguendo nella navigazione acconsenti all’uso dei cookie.