* Taking readers through the basics of the language, right up to
some more advanced topics, this book is a practical, hands-on
resource and aims to keep the reader involved at all times
* Focuses on the SQL standard and is loaded with detailed
examples and code; each chapter includes practice exercises that
readers can challenge themselves with before looking at the sample
solutions in the appendix
* Paul Wilton is a successful Wrox ‘Beginning’ book author and is
an ideal author to write for those who want a firm grasp of
standard SQL before learning the details specific to a particular
database product
* SQL is an international standard for manipulating data in
databases and is used by database programmers in all major database
systems: Microsoft, IBM, Oracle, My SQL, and many others
Зміст
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.
Про автора
Paul Wilton has been working professionally as a
programmer for over 6 years. He is experienced with SQL, database
design, development and deployment, as well as RDBMS systems
including SQL Server and Access. He is currently working freelance
developing functionality for websites database driven web sites
including e-commerce, message boards, chat applications, and more.
His most recent work includes a case tracking system for a law firm
and an online booking system for a holiday cottage rental company.
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.
Більше електронних книг того самого автора / Редактор
16 474 Електронні книги в цій категорі
