Administration Training

See All Scheduled Courses

Intertech delivers a full series of Administration training courses. Our Administration training courses are instructor-led and can be taken in a classroom setting or live online. See more details of our course offerings below the course listings.

Course Finder

Return To Top
Filter Options
close

Training Category

  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See more Adobe Categories
  • See more Adobe Categories
  • See more Adobe Categories
  • See more Agile | Scrum Categories
  • See more Agile | Scrum Categories
  • See more Citrix Categories
  • See more EC Council Categories
  • See more F5 Categories
  • See more IBM Categories
  • See more IBM Categories
  • See more ITIL Categories
  • See more Java Categories
  • See more Java Categories
  • See more Java Categories
  • See more Java Categories
  • See more Linux Categories
  • See more Linux Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Open Source Categories
  • See more Open Source Categories
  • See more Open Source Categories
  • See more Oracle Categories
  • See more Oracle Categories
  • See more Programming Categories
  • See more Programming Categories
  • See more Software Testing Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more XML Categories
  • See more XML Categories

Scheduled Classes


Date

  • X
  • X
  • Please ensure that the End Date is greater than or equal to the Start Date.
  • Please ensure that the End Date is greater than the present Date.

Delivery

Location

- of results

Free Resources

Quick Start: Learn DAX Basics in 30 Minutes

Free eBook: High Availability Solutions

SQL Server for Developers - 50+ Page Whitepaper

MORE ON ADMINISTRATION TRAINING

SQL Server Administration training begins with an exploration of the SQL Server architecture, this covers various editions of SQL Server, before proceeding to instruction on installation. Students learn the importance of planning and then the mechanics of installing SQL Server, as well as analysis services and PowerPivot for SharePoint. Instructors explain burning in the system, post-install configuration and uninstalling SQL Server. For those considering upgrading to later versions, instructors review best practices: pre-upgrade steps and tools, backward compatibility, SQL Server components considerations and post-upgrade checks.
 
Students in our SQL Server Administration training course learn how to manage and troubleshoot the database engine. This includes a review of the configuration and administration tools and troubleshooting tools. Instructors describe the management studio and monitoring processes in T-SQL, before moving on to multiserver management, trace flags and getting help from support.
 
Another important topic in our SQL Server Administration training is automating SQL server. From maintenance plans and automating SQL Server with SQL Server agent to SQL Server agent security and configuring SQL Server agent, students learn every aspect of this important topic.
 
Change management. Configuring the server for optimal performance and optimizing the server also are covered in Intertech’s SQL Server Administration training. Likewise, students review all aspects of monitoring the SQL Server: choosing the appropriate tools, monitoring events with dynamic views and functions, monitoring logs, and more. They also learn about performance tuning T-SQL and physical query processing.
 
Indexing the database is another key topic in our SQL Server Administration training. This generally includes noteworthy index-related features in SQL Server, partitioned tables and indexes, index maintenance, improving query performance with indexes, and database tuning advisor. Intertech instructors then move on to replication models and implementation. Clustering SQL Server is given equal time, including such topics as upgrading SQL Server clustering, getting prepared for clustering, clustering Microsoft Distributed Transaction Coordinator, managing and monitoring the cluster and troubleshooting cluster problems.
 
No SQL Server Administration training would be complete without a thorough overview of backup and recovery. Our course covers types of failures, making plans, backup and restore, preparing for recovery, developing and executing a backup plan, managing backups, backup and restore performance, performing recovery and archiving data.
 
Likewise, students in our SQL Server Administration training course receive instruction in SQL Server log shipping processes: deployment scenarios, architecture, system requirements, deploying, monitoring and troubleshooting and so on. They also learn the intricacies of database mirroring. As the course progresses, there is a detailed discussion of integration services administration and performance tuning, SQL Server reporting services administration and SharePoint integration. Intertech SQL Server Administration instructors also cover SQL Azure administration and configuration, including administering SQL Azure, working with SQL Azure and what’s missing in SQL Azure.
 
 
 

Looking for Different Training?