SQL: A Beginner's Guide
Published on 16. January 2001
Book
Paperback/Softback
452 pages
978-0-07-213096-6 (ISBN)
Description
Essential Skills for First-Time Programmers! SQL: A Beginner's Guide explains the fundamentals of SQL programming. You'll learn to access a database and retrieve, insert, and delete data, build and deploy stored procedures, and combine views and subqueries to select and update data.
More details
Edition
Annotated edition
Language
English
Place of publication
United States
Publishing group
McGraw-Hill Education - Europe
Target group
College/higher education
Professional and scholarly
Edition type
Annotated edition
Illustrations
1
Dimensions
Height: 233 mm
Width: 187 mm
Thickness: 32 mm
Weight
871 gr
ISBN-13
978-0-07-213096-6 (9780072130966)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Person
Forrest Houlette is a computer writer and consultant and president of Write Environment, Inc., a consulting firm that specializes in Visual Basic software development, custom documentation, training, and software for both education and business. Forrest focuses on writing about computers and creating custom software. He is a former Learning Tree International instructor, for whom he taught courses Windows 95, Windows NT, Office 97, and Visual. He has authored or co-authored books for IDG, New Riders Publishing, Que, and Sybex. He is also a Microsoft Certified Product Specialist.
Content
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.