Beginning SQL Server for Developers

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.

• 1. Overview and Installation 2. SQL Server Management Studio 3. Database Design and Creation 4. Security and Compliance 5. Defining Tables 6. Creating Indexes and Database Diagramming 7. In-memory Tables 8. Database Backups and Recovery 9. Database Maintenance 10. Data Insertion, Deletion, and Transactions-- Disk-Based 11. Selecting and Updating Data from Disk-Based Tables 12. Working with In-Memory Tables 13. Building a View 14. Stored Procedures, Functions, and Security 15. Natively Compiled Stored Procedures 16. Essentials for Effective Coding 17. Advanced T-SQL and Debugging 18. Triggers 19. Connecting via Code