Beginning SQL Programming

• Database structure from Tables to Normalisation
• Basic SQL, including DDL, DCL, DML
• The only tutorial that is comprehensive and up-to-date with coverage of SQL '99
• Tutorial exercises tied into each element of database structure - as it appears

The book gives step-by-step instructions, alerts readers to common pitfalls, tricks and traps, and uses real-world examples, including two extensive case studies, to create a thorough tutorial. It will furnish readers with a firm grasp of SQL concepts that you can work with straight away, as well as provide solid foundations and challenging ideas with which you can later develop more advanced SQL techniques.

Included with this book is a 120-day evaluation enterprise edition of Microsoft's SQL Server 2000. An end user license agreement is contained in this licensed software. Who is this book for?

• Novice database programmers and administrators
• Highly suitable for Visual Basic novices
• Highly suitable for web developers who have wandered into the world of dynamic page creation from databases

• Chapter 01 Introduction
• Chapter 02 Getting Started with SQL
• Chapter 03 Introduction to Databases
• Chapter 04 SQL Syntax and Basic SELECT
• Chapter 05 More Techniques with SELECT
• Chapter 06 Creating and Modifying Tables
• Chapter 07 Table Constraints
• Chapter 08 Relating Tables
• Chapter 09 Creating Records and Cleaning Data
• Chapter 10 Deleting Records
• Chapter 11 Changing Existing Data
• Chapter 12 SQL Functions - Date, Time and String
• Chapter 13 SQL Functions - Math and Data Type Conversion
• Chapter 14 Grouping - using aggregate functions
• Chapter 15 Stored Procedures
• Chapter 16 Views and Indices
• Chapter 17 Schema
• Chapter 18 Case Study 1
• Chapter 19 Case Study 2
• Chapter 20 What to Study Next

• Appendix A Intro to DCL
• Appendix B Schema for example databases
• Appendix C SQL Quick Reference
• Appendix D Notes on Flavours of SQL
• Index