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.
Auflage
Sprache
Verlagsort
Verlagsgruppe
McGraw-Hill Education - Europe
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Editions-Typ
Illustrationen
Maße
Höhe: 233 mm
Breite: 187 mm
Dicke: 32 mm
Gewicht
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 Klassifikation
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.
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.
