Taylor's Library

Normal view MARC view ISBD view

Microsoft SQL Server 2005 : a beginner's guide / Dusan Petkovic.

By: Petković, Dušan.
Publisher: Emeryville, Calif. : McGraw-Hill/Osborne, c2006Description: xxix, 704 p. : ill. ; 24 cm.ISBN: 0072260939 (pbk.).Other title: SQL Server 2005.Subject(s): SQL server | Client/server computing | Relational databasesDDC classification: 005.2768
Contents:
Pt. 1. SQL Server: basic concepts: 1. Database systems and SQL Server - 2. SQL Server management studio -- Pt. 2. Transact-SQL language: 3. SQL components - 4. Data definition language - 5. Simple queries - 6. Complex queries - 7. Modification of a table's contents - 8. Stored procedures and user-defined functions - 9. Indices and query optimization - 10. Views - 11. System catalog - 12. SQL Server security - 13. Triggers - 14. Transactions - 15. SQL Server system environment -- Pt. 3. SQL Server: System administration. 16. Overview of system administration - 17. Planning the installation and installing SQL Server - 18. Managing databases and database files - 19. Managing security - 20. Backup and recovery - 21. Automating system administration tasks - 22. Performance and tuning - 23. Data partitioning - 24. Data replication -- Pt. 4. Microsoft analysis services: 25. Data warehousing: an introduction - 26. Microsoft analysis services - 27. Business intelligence and SQL - 28. Microsoft reporting services -- Pt. 5. XML support: 29. Overview of XML - 30. SQL Server 2005 and XML.
Item type Current location Call number Copy number Status Notes Date due Barcode Remark
Main Collection TU External Storage-LCS
005.2768 PET (Browse shelf) 1 Available SOCIT,15008,03,GR 1001005746 Please fill up online form at https://taylorslibrary.taylors.edu.my/services/external_storage1

"Essential skills for database professionals"--Cover.

Includes index.

Pt. 1. SQL Server: basic concepts: 1. Database systems and SQL Server - 2. SQL Server management studio -- Pt. 2. Transact-SQL language: 3. SQL components - 4. Data definition language - 5. Simple queries - 6. Complex queries - 7. Modification of a table's contents - 8. Stored procedures and user-defined functions - 9. Indices and query optimization - 10. Views - 11. System catalog - 12. SQL Server security - 13. Triggers - 14. Transactions - 15. SQL Server system environment -- Pt. 3. SQL Server: System administration. 16. Overview of system administration - 17. Planning the installation and installing SQL Server - 18. Managing databases and database files - 19. Managing security - 20. Backup and recovery - 21. Automating system administration tasks - 22. Performance and tuning - 23. Data partitioning - 24. Data replication -- Pt. 4. Microsoft analysis services: 25. Data warehousing: an introduction - 26. Microsoft analysis services - 27. Business intelligence and SQL - 28. Microsoft reporting services -- Pt. 5. XML support: 29. Overview of XML - 30. SQL Server 2005 and XML.