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
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