Microsoft SQL server 2008 : a beginner's guide /
Dusan Petkovic.
- New York : McGraw Hill, c2008.
- xxxiii, 709 p. : il., grafs., etc.
Pte. 1. Basic concepts and installation -- Cap. 1. Relational database systems - An Introduction -- 2. Planning the installation and installing SQL Server -- 3. SQL server management studio -- Pte. 2. Transact-SQL language -- Cap. 4 SQL components -- 5. Data definition language -- 6. Queries -- 7. Modification of a table's Contents -- 8. Stored procedures and user-defined functions -- 9. System catalog -- 10. Indices -- 11. Views -- 12. Security system of database engine -- 13. Concurrency control -- 14. Triggers -- Pte. 3. SQL server: System administration -- 15. System environment of database engine -- 16. Managing instances and maintaining databases -- 17. Backup and recovery -- 18. Automating system administration tasks -- 19. Data replication -- 20. Query optimizer -- 21. Performance tuning -- Pte. 4. Microsoft analysis services -- 22. Business intelligence: An introduction -- 23. Microsoft analysis services -- 24. Business intelligence and transact-SQL -- 25. Microsoft reporting services -- 26. Optimizing techniques for business intelligence -- Pte. 5. Beyond relational data -- 27. Overview of XML -- 28. SQL Server and XML -- 29. Introduction to spatial data.