Microsoft SQL Server 2005 : a beginner's guide /
SQL Server 2005
Dušan Petkovic.
- Emeryville, Calif. : McGraw-Hill/Osborne, c2006.
- xxix, 704 p. : ill. ; 23 cm.
- Essential skills for database professionals .
- Essential skills for database professionals. .
Includes index.
Pt. 1. SQL Server: basic concepts. Database systems and SQL Server -- SQL Server management studio -- Pt. 2. Transact-SQL language. SQL components -- Data definition language -- Simple queries -- Complex queries -- Modification of a table's contents -- Stored procedures and user-defined functions -- Indices and query optimization -- Views -- System catalog -- SQL Server security -- Triggers -- Transactions -- SQL Server system environment -- Pt. 3. SQL Server: system administration. Overview of system administration -- Planning the installation and installing SQL Server -- Managing databases and database files -- Managing security -- Backup and recovery -- Automating system administration tasks -- Performance and tuning -- Data partitioning -- Data replication -- Pt. 4. Microsoft analysis services. Data warehousing: an introduction -- Microsoft analysis services -- Business intelligence and SQL -- Microsoft reporting services -- Pt. 5. XML support. Overview of XML -- SQL Server 2005 and XML.