Beginning SQL

Beginning SQL
with source code

• Author(s) : Paul Wilton and John W. Colby
• Publisher : Wrox
• Year : Mar 2005
• ISBN 10 : 0764577328
• ISBN 13 : 9780764577321
• Language : English
• Pages : 528
• File type : PDF
• Size : 3.6 MB (book + source code)
  

This book starts right from the basics with databases and SQL. Prior database or SQL knowledge is not necessary, as this book covers everything from database design to creating your first database and understanding how the SQL language is used with databases.

If you have some previous experience with databases and SQL, then you’ll have a head start and you may want to just skim Chapter 1. You’ll need to follow its instructions for creating the book’s example database, as this is used for all the examples throughout the book.

This book will look at Structured Query Language, or SQL as it’s usually abbreviated. SQL works with a database to create the database and to insert and extract data. Therefore, it’s essential to understand the theory and concepts behind database systems. Hence, this book also covers database theory and database design, so that you’re equipped to create an effective database.

The SQL code in this book reflects the modern SQL standards set by organizations such as the American National Standards Institute (ANSI) and the International Standards Organization (ISO). However, while standards are great, what’s available for practical use is what really counts. This book, then, concentrates on the sort of SQL supported by most modern database systems. You should that find most of the code runs with little or no modification on most database systems released within the last six or seven years.

TABLE OF CONTENT:

1. Chapter 01 - Introduction to SQL
2. Chapter 02 - Entering Information
3. Chapter 03 - Extracting Information
4. Chapter 04 - Advanced Database Design
5. Chapter 05 - Manipulating Data
6. Chapter 06 - Grouping and Aggregating Data
7. Chapter 07 - Selecting Data from Different Tables
8. Chapter 08 - Queries within Queries
9. Chapter 09 - Advanced Queries
10. Chapter 10 - Views
11. Chapter 11 - Transactions
12. Chapter 12 - SQL Security
13. Chapter 13 - Database Tuning
14. Appendix A - Exercise Answers
15. Appendix B - Setting up and Using the Five Database Systems
16. Appendix C - Initial Data Setup

Download Now
Password =  ganelon