Beginning SQL

Häftad, Engelska, 2005

309 kr

Beställningsvara. Skickas inom 7-10 vardagar

Fri frakt för medlemmar vid köp för minst 249 kr.

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 timesFocuses 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 appendixPaul 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 productSQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others

Produktinformation

Utgivningsdatum2005-03-04
Mått188 x 234 x 33 mm
Vikt862 g
FormatHäftad
SpråkEngelska
SerieProgrammer to Programmer
Antal sidor528
FörlagJohn Wiley & Sons Inc
ISBN9780764577321

Tillhör följande kategorier

Programmeringsböcker inom Data och it
Databaser inom Data och it

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.

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 SystemsAppendix C: Initial Data Setup.Index.