Beginning SQL
- 7h 52m
- John W. Colby, Paul Wilton
- John Wiley & Sons (US)
- 2005
SQL works with databases to insert and extract data and is an international standard for manipulating data in databases. This hands-on resource covers everything from a review of SQL basics and database design to creating your own databases and using the SQL language in a variety of database applications.
Packed with essential code, theories, concepts, and techniques, as well as a cache of useful examples, this comprehensive text will have you quickly designing your own databases and writing SQL code sufficient for many real-world situations. Practice exercises in each chapter help speed up your comprehension. By the end of the book, you’ll be prepared to handle any surprise that SQL might throw your way.
What you will learn from this book
- How to get the 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 diverse 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
About the Authors
After an initial start as a Visual Basic applications programmer at the Ministry of Defense in the U.K., Paul Wilton found himself pulled into the Net. Having joined an Internet development company, he spent the last three years helping create Internet solutions and is currently working on an e-commerce Web site for a major British bank.
John Colby is an independent consultant who has specialized in Access development since 1994. He has designed databases for companies in the U.S., Mexico, Canada, and Ireland. John is past president and current board member of Database Advisors, Inc., a not-for-profit organization dedicated to providing fellow developers with a place to discuss Access, SQL Server, Visual Basic, and other topics relative to modern database applications development. Database Advisors also allows developers to showcase their talents by sharing databases, wizards, and various code packages.
In this Book
-
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
