Best SQL Server Admin Online Courses
#1 SQL Server Administration Part1
The following course will introduce to you the foundation of SQL Server Administration Part 1 as it’s practiced in the production real world situations. I have designed this course for the beginner but at the same time introduced elements that are practiced in the real world, so the student gains a faster understanding of the requirements in the production server. Anyone interested in understanding, configuring, managing or is responsible for SQL Server systems will benefit from this course. My first course T-SQL, while not mandatory, should be taken so you gain a better understanding of this course. All software, SQL Scripts and documentation is provided for you. All you need is a desire to learn and fullfill you future goals. These courses will give you that direction.
#2 SQL Server Administration Part 2
SQL Administration Part 2 will benefit the student by providing the necessary guide lines for enhancing SQL Server performance by utilizing indexes, reviewing DMVs for analysis, and setting up performance counters for gathering resource metrics; and also I will explain a handful of utilities to gather information about SQL Server internals, such as SQL Profiler, Database Tuning Advisor (DTA), Extended Events, SQL performance monitor, Activity monitor, and teach about partitions, creating contained database for recovery, reviewing SQL server logs and by installing SQL Server 2014 as the newer SQL version.The student will not only add to the knowledge gained bur SQL Administration Part 1, but get prepared for the next course SQL Administration Part 3 – the high availability solutions.
#3 SQL Server Administration Part 3
This SQL Server Administration Part 3 course is designed for the student who has already taken or is taking Part 1 and Part 2, which are prerequisite courses. This course will cover High Availability solutions such as log shipping, database mirroring, replication, peer to peer replication and always on availability group technologies. Upon completing this course, the student will be well versed in configuring, managing, and monitoring virtually all tasks that a SQL SBA does in his daily, weekly and monthly duties. The materials that the student will need such as documents and SQL scripts will be provided via a zip file that the student requests via email. Upon completion of this course, the student will have the training, education and knowledge that a college provides in their courses about SQL Server Administration.
Best SQL Server Admin Books:
#1 Microsoft SQL Server 2012 Step by Step: Micr SQL Serv 2012 Step _p1 (Step by Step Developer) by Patrick LeBlanc
#2 Professional Microsoft SQL Server 2012 Administration by Adam Jorgensen
#3 Learn SQL Server Administration in a Month of Lunches: Covers Microsoft SQL Server 2005-2014 by Don Jones
#4 Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463) by Tom Carpenter
#5 SQL Server 2017 Administration Inside Out by William Assaf
#6 Pro SQL Server Administration by Peter Carter