,

Beginning SQL

Specificaties
Paperback, 501 blz. | Engels
Wrox | 1e druk, 2005
ISBN13: 9780764577321
Rubricering
Hoofdrubriek : Computer en informatica
Wrox 1e druk, 2005 9780764577321
Onderdeel van serie Programmer to Programmer (Wrox)
Gratis verzonden | Verwachte levertijd ongeveer 9 werkdagen

Samenvatting

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. This book 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, MySQL, and many others.

What you will learn from this book:
- Howe to get answers you want from a database
- Procedures for using and manipulating data with SQL's built in functions
- Ways to retrieve data from numerous and device tables
- How to create various levels of security in a database so you can edit data or change the database's structure
- Theories and practical applications of normalization
- Advanced database design

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.

Specificaties

ISBN13:9780764577321
Taal:Engels
Bindwijze:paperback
Aantal pagina's:501
Uitgever:Wrox
Druk:1

Inhoudsopgave

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.

Net verschenen

Rubrieken

Populaire producten

    Personen

      Trefwoorden

        Beginning SQL