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