Beginning SQL

Front Cover
John Wiley & Sons, Mar 4, 2005 - Computers - 520 pages
  • 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, MySQL, and many others
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Introduction
1
Chapter 1 Introduction to SQL
7
Chapter 2 Entering Information
41
Chapter 3 Extracting Information
53
Chapter 4 Advanced Database Design
117
Chapter 5 Manipulating Data
157
Chapter 6 Grouping and Aggregating Data
189
Chapter 7 Selecting Data from Different Tables
207
Chapter 10 Views
287
Chapter 11 Transactions
301
Chapter 12 SQL Security
327
Chapter 13 Database Tuning
349
Appendix A Exercise Answers
367
Appendix B Setting Up and Using the Five Database Systems
391
Appendix C Initial Data Setup
451
Index
475

Chapter 8 Queries within Queries
235
Chapter 9 Advanced Queries
263

Other editions - View all

Common terms and phrases

About the author (2005)

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.

Bibliographic information