Mastering Microsoft SQL server 2005. / Mike Gunderloy, Susan Sales Harkins.
- Express ed.
- Indianapolis, Indiana : Wiley Publishing, 2006.
- xxii, 576 p. : ill. ; 23 cm. +
Includes index.
Contents: Introducing SQL server express: Introduction to SQL server express -- Overview of database concepts -- Overview of SQL server express -- Database design and normalization -- Transact-SQL overview and basics -- Select queries -- Action queries -- Topics in advanced transact-SQL -- Digging into SQL server express: Using management studio express -- Databases -- Tables -- Indexing -- Views -- Stored procedures -- Using triggers -- Administering SQL server express: Basic administrative tasks -- Security and SQL server express -- Developing applications with SQL server express: Working with visual basic express -- Accessing data using ADO.NET -- Automating SQL server express using SMO and RMO -- Advanced SQL server express administration: Locking -- Monitoring and optimizing SQL server express -- Replication -- Service broker -- Troubleshooting --