SQL

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.

<H2> Part I: Learning the Essentials.<H3> Chapter 1: Accessing the Database.<H3> Chapter 2: Retrieving Data.<H3> Chapter 3: Inserting Data.<H3> Chapter 4: Updating Data.<H3> Chapter 5: Deleting Data.<H3> Chapter 6: Creating Tables.<H3> Chapter 7: Creating Databases.<H2> Part II: Building Skills.<H3> Chapter 8: Using Operators.<H3> Chapter 9: Using Functions.<H3> Chapter 10: Building Subqueries.<H3> Chapter 11: Building Views.<H3> Chapter 12: Building Stored Procedures.<H3> Chapter 13: Programming in Stored Procedures.<H3> Chapter 14: Using Parameters.<H3> Chapter 15: Using Cursors.<H3> Chapter 16: Building Unions.<H2> Part III: Mastering SQL.<H3> Chapter 17: Solving Practical Problems.<H3> Chapter 18: Combining Views and Subqueries to Select Data.<H3> Chapter 19: Combining Views and Subqueries to Update Data.<H3> Chapter 20: Building Complex Stored Procedures.<H3> Chapter 21: Optimizing SQL Performance.<H4> Appendix: The Critical SQL Desk Reference.