Audience
This course is intended for IT Professionals who administer and maintain SQL Server databases. No prior experience is presumed.
This class is 70% hands-on, 30% lecture.
Software Needed on Each Student PC
* Windows Server 2008, 2008 R2 or Windows 7 Enterprise, with at least 4GB RAM
* SQL Server 2014
Course Completion: After completing this course, students will be able to:
* Install and configure SQL Server 2014
* Upgrading from older versions like 2005/2008/R2 to 2014
* Backup and restore databases
* Manage security
* Managing indexes and finding performance bottlenecks
* Automate administrative tasks.
* Replicate data between SQL Server instances.
* Maintain high availability.[log-shipping, Mirroring]
* SQL Server 2014 Clustering implentation/administration
* Impletementing AlwaysOn and administering AlwaysOn groups
* Data Compression, Resource Governor, Central Management Servers
* User defined Server roles, Contained Databases, Column store indexes
* Performance tuning using Profiler, DTA & System monitor