Petkovic, Dušan.

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.

0072260939 (pbk.) 9780072260939

2006279408

GBA577172 bnb

013291857 Uk


SQL server.


Client/server computing.
Relational databases.
SQL server.

QA76.9.C55 / P478 2006

005.7585