Step by Step Microsoft SQL Server 2000 Programming (Paperback, CD-ROM)

Introduction

PART 1. GETTING STARTED WITH SQL SERVER

Lesson 1. The SQL Server 2000 Environment
Lesson 2. Administering SQL Server
Lesson 3. SQL Server 2000 Security

PART 2. CREATING DATABASES

Lesson 4. Creating a Database
Lesson 5. Creating Tables
Lesson 6. Creating Indexes
Lesson 7. Creating Relationships
Lesson 8. Creating Check Constraints
Lesson 9. Creating Table Objects
Lesson 10. Creating Database Diagrams

PART 3. RETRIEVING DATA

Lesson 11. Retrieving Rows
Lesson 12. The SELECT Statement
Lesson 13. Sorting and Selecting Rows
Lesson 14. Joining Tables
Lesson 15. Summarizing Data
Lesson 16. Views

PART 4. WORKING WITH DATA

Lesson 17. Adding Rows
Lesson 18. Updating Rows
Lesson 19. Deleting Rows
Lesson 20. Copying and Moving Data

PART 5. TRANSACT-SQL

Lesson 21. The Query Analyzer
Lesson 22. Data Definition Language
Lesson 23. Analyzing Queries
Lesson 24. Transact-SQL Language Components
Lesson 25. Programming Objects
Lesson 26. Controlling Execution
Lesson 27. Transact-SQL Cursors
Lesson 28. Stored Procedures
Lesson 29. Triggers
Lesson 30. User-Defined Functions

GLOSSARY
INDEX