SQL: A Beginner's Guide, Second Edition

Content: Part I: SQL Databases 1: Introduction to Relational Databases and SQL 2: Working with the SQL Environment 3: Creating and Altering Tables 4: Enforcing Data Integrity 5: Creating SQL Views 6: Managing Database Security Part II: Data Access and Modification 7: Querying SQL Data 8: Modifying SQL Data 9: Using Predicates 10: Working with Functions and Value Expressions 11: Accessing Multiple Tables 12: Using Subqueries to Access and Modify Data Part III: Advanced Data Access 13: Creating SQL-Invoked Routines 14: Creating SQL Triggers 15: Using SQL Cursors 16: Managing SQL Transactions 17: Accessing SQL Data from Your Host Program Part IV: Appendixes A: Answers to Mastery Checks B: SQL:1999 Keywords C: SQL Code Used in the Book's Projects Here is the foundation upon which you can build your relational database design and programming, then apply those skills to any SQL-based product. Organized for beginners, you'll learn step-by-step how to create a database, create tables, enforce data integrity, query and modify data, and implement advanced data access techniques.--From publisher description Here is the foundation upon which you can build your relational database design and programming, then apply those skills to any SQL-based product. Carefully organized for beginners, you’ll learn step-by-step how to create a database, create tables, enforce data integrity, query and modify data, and implement advanced data access techniques. Helping you to build your relational database design and programming, this book also allows you to apply those skills to almost any SQL-based product. Useful for beginners, it teaches step-by-step how to create a database, create tables, enforce data integrity, query and modify data, and implement advanced data access techniques. In 1999, the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO) published their long-awaited SQL standard, which was dubbed "SQL:1999" (also known as SQL3). Explains how to program with SQL, covering topics including database objects, queries, modifications, embedded statements, and troubleshooting.