This course provides delegates with the skills to install, administer and query a Microsoft SQL Server. This course is based on “Microsoft SQL Server 2012 A Beginners Guide” by Dušan Petkovic. It includes more material than can be covered in 5 days. This means chapters can be included and excluded as required.
The Chapters to consider as a starting point are marked with an asterisk (*)
Part I: Basic Concepts and Installation
* Chapter 1. Relational Database Systems: An Introduction
* Chapter 2. Planning the Installation and Installing SQL Server
* Chapter 3. SQL Server Management Studio
Part II: Transact-SQL Language
* Chapter 4. SQL Components
* Chapter 5. Data Definition Language
* Chapter 6. Queries
* Chapter 7. Modification of a Table’s Contents
* Chapter 8. Stored Procedures and User-Defined Functions
* Chapter 9. System Catalog
* Chapter 10. Indices
* Chapter 11. Views
* Chapter 12. Security System of the Database Engine
*Chapter 13. Concurrency Control
Chapter 14. Triggers
Part III: SQL Server: System Administration
* Chapter 15. System Environment of the Database Engine
* Chapter 16. Backup, Recovery, and System Availability
* Chapter 17. Automating System Administration Tasks
Chapter 18. Data Replication
Chapter 19. Query Optimizer
Chapter 20. Performance Tuning
Part IV: SQL Server and Business Intelligence
* Chapter 21. Business Intelligence: An Introduction
Chapter 22. SQL Server Analysis Services
Chapter 23. Business Intelligence and Transact-SQL
Chapter 24. SQL Server Reporting Services
Chapter 25. Optimizing Techniques for Relational Online Analytical Processing
Part V: Beyond Relational Data
Chapter 26. SQL Server and XML
Chapter 27. Spatial Data
Chapter 28. SQL Server Full-Text Search