TY - BOOK AU - Petkovic,DuĊĦan TI - Microsoft SQL Server 2005: a beginner's guide T2 - Essential skills for database professionals SN - 0072260939 (pbk.) AV - QA76.9.C55 P478 2006 U1 - 005.7585 22 PY - 2006/// CY - Emeryville, Calif. PB - McGraw-Hill/Osborne KW - SQL server KW - Client/server computing KW - Relational databases KW - sears N1 - 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 ER -