Microsoft SQL Server 2005
Subtitle: a beginner's guide
By: Dušan Petkovic.
Series: Essential skills for database professionals
Publisher: McGraw-Hill/Osborne
Published: 2006
Place of publication: Emeryville, Calif
Language: eng
Number of pages: 704
ISBN-13: 9780072260939
Subjects: SQL server.; Client/server computing.; Relational databases.
Other titles: SQL Server 2005
Notes: Includes index.
Table of contents: title: Pt. 1. SQL Server: basic concepts.  Database systems and SQL Server; title: SQL Server management studio; title: Pt. 2. Transact-SQL language. SQL components; title: Data definition language; title: Simple queries; title: Complex queries; title: Modification of a table's contents; title: Stored procedures and user-defined functions; title: Indices and query optimization; title: Views; title: System catalog; title: SQL Server security; title: Triggers; title: Transactions; title: SQL Server system environment; title: Pt. 3. SQL Server: system administration.  Overview of system administration; title: Planning the installation and installing SQL Server; title: Managing databases and database files; title: Managing security; title: Backup and recovery; title: Automating system administration tasks; title: Performance and tuning; title: Data partitioning; title: Data replication; title: Pt. 4. Microsoft analysis services. Data warehousing: an introduction; title: Microsoft analysis services; title: Business intelligence and SQL; title: Microsoft reporting services; title: Pt. 5. XML support.  Overview of XML; title: SQL Server 2005 and XML.