- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
New Trade Paper
Ships in 1 to 3 days
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
More copies of this ISBN
Other titles in the Beginner's Guides series:
SQL (Beginner's Guides)by Forrest Houlette
Synopses & Reviews
Learn the basics of Structured Query Language programming from the tutorials and examples in this easy-to-follow resource.
SQL: A Beginner's Guide teaches you how to use SQL to work with data in a database, develop database objects, create subqueries, build views, write stored procedures, and accomplish complex selects and updates. The examples throughout the book walk you through real-world database tasks. If you want to get started programming in SQL right away, this is the ideal self-paced learning tool for you.
This Beginner's Guide is Designed for Easy Learning:
Book News Annotation:
Tutorials and examples in this book teach the basics of Structured Query Language (SQL) programming and show how to use SQL to work with data in a database, develop database objects, create subqueries, build views, write stored procedures, and accomplish complex selects and updates. Learning features include examples that walk readers through real-world database tasks, question and answer sections, example code annotated with commentary that points to particular techniques illustrated, and coding exercises. Houlette is president of a firm specializing in software development and training.
Annotation c. Book News, Inc., Portland, OR (booknews.com)
The book also includes quick-look up appendix of the most critical SQL commands and techniques, sample SQL code for both Access and SQL Server 2000, and syntax and information on the emerging new standard to SQL -SQL 3.
Table of Contents
Part I: Learning the Essentials.
Chapter 1: Accessing the Database.
Chapter 2: Retrieving Data.
Chapter 3: Inserting Data.
Chapter 4: Updating Data.
Chapter 5: Deleting Data.
Chapter 6: Creating Tables.
Chapter 7: Creating Databases.
Part II: Building Skills.
Chapter 8: Using Operators.
Chapter 9: Using Functions.
Chapter 10: Building Subqueries.
Chapter 11: Building Views.
Chapter 12: Building Stored Procedures.
Chapter 13: Programming in Stored Procedures.
Chapter 14: Using Parameters.
Chapter 15: Using Cursors.
Chapter 16: Building Unions.
Part III: Mastering SQL.
Chapter 17: Solving Practical Problems.
Chapter 18: Combining Views and Subqueries to Select Data.
Chapter 19: Combining Views and Subqueries to Update Data.
Chapter 20: Building Complex Stored Procedures.
Chapter 21: Optimizing SQL Performance.
Appendix: The Critical SQL Desk Reference.
What Our Readers Are Saying
Other books you might like
Computers and Internet » Computer Languages » SQL