Introduction to Advanced SQL Server Management (1 day)


SQL Server is Microsoft's primary database management tool. This course is designed to take you through a critical aspect of SQL Server Administration, with just the right amount of depth, within one day.

The course is most suitable for those that need to gain an introductory-level understanding of advanced SQL Server management topics including the use of Resource Governor, Policy Based Management, and Replication. An introduction to SQL Servers' High Avability options is also provided. While not essential to complete the labs (as full detailed instructions are provided), some knowledge of T-SQL would be helpful.

While our courses are based on SQL Server 2017, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.

 CITY DATES COURSE PRICE EARLY BIRD PRICE
On-demand Please contact us

DAY 1 AD217 INTRODUCING RESOURCE GOVERNOR CONCEPTS
Introducing Resource Governance Requirements
Alternatives to Resource Governor
Introducing Resource Governor
LAB: Introducing Resource Governor Concepts
DAY 1 AD218 INTRODUCING REPLICATION CONCEPTS
Introducing Publications, Distribution, and Subscriptions
Introducing Transactional, Snapshot, and Peer-to-Peer Replication
Introducing Merge Replication
LAB: Introducing Replication Concepts
DAY 1 AD219 INTRODUCING POLICY BASED MANAGEMENT AND DATA COLLECTION CONCEPTS
Introducing Policy Management Requirements
Alternatives to Policy Based Management
Introducing Policy Based Management
Introducing Data Collection
Introducing Policy Based Management and Data Collection Concepts
DAY 1 AD220 INTRODUCING HIGH AVAILABILITY CONCEPTS
Defining High Availability
Introducing Log Shipping
Introducing Database Mirroring
Introducing Failover Clustering
Introducing Availability Groups
LAB: Introducing High Availability Concepts