SQL in easy steps, 4th edition has an easy-to-follow style that will appeal to anyone who wants to begin using databases.
SQL in easy steps, 4th edition makes no assumption that you will have previous knowledge of any programming or scripting language so it's ideal for the newcomer to SQL. Each chapter builds your knowledge of executing database queries. The book contains exciting chapters on how to selectively extract data from within one, or more, databases and there are complete examples that illustrate each aspect of SQL. By the end of this book you will have gained a sound understanding of the Structured Query Language and be able to write your own SQL scripts to insert, extract and manipulate data. This book will appeal to all who need a fundamental understanding of database administration with SQL.
- Introducing SQL
- Getting Started
- Creating Database Tables
- Inserting Data into Tables
- Retrieving Data from Tables
- Sorting Retrieved Data
- Simple Data Filtering
- Complex Data Filtering
- Generating Calculated Fields
- Manipulating Data
- Grouping Table Data
- Making Complex Queries
- Joining Database Tables
- Handy Reference