SQL Server 2016 - Maintenance and Automation [Video]

Preview in Mapt

SQL Server 2016 - Maintenance and Automation [Video]

Steve Jones

1 customer reviews
Safeguard your business continuity and database with the help of Backup, Automation, and Disaster Recovery

Quick links: > What will you learn?> Table of content

Video
$5.00
RRP $124.99
Save 95%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$5.00
RRP $124.99

Frequently bought together


SQL Server 2016 - Maintenance and Automation [Video] Book Cover
SQL Server 2016 - Maintenance and Automation [Video]
$ 124.99
$ 5.00
SQL Server 2016 Advanced Security and Administration [Video] Book Cover
SQL Server 2016 Advanced Security and Administration [Video]
$ 124.99
$ 5.00
Buy 2 for $10.00
Save $239.98
Add to Cart

Video Details

ISBN 139781787281431
Course Length2 hours 30 minutes

Video Description

Microsoft SQL Server 2016 is considered the biggest leap in the data platform history of the Microsoft, in the ongoing era of Big Data and data science. Compared to its predecessors, SQL Server 2016 offers developers a unique opportunity to leverage the advanced features and build applications that are robust, scalable, and easy to administer.

In this video tutorial, you will start with diving into Backup and Recovery of your Database. Here, you will learn to develop a backup strategy and carry out full database backups as well as differential database backups. You will explore the different options for restoring your system logs, and how to restore your database’s state to a specified point in time. From there, you will move on to Automating your Server. You will learn to create tasks and jobs for your system, and also set up operations and notifications. You will also learn to configure alerts and database emails for sending messages to users. After that, you will dive right into High Availability and Disaster Recovery, where you will database mirroring, log shipping, and availability groups. Finally, you will explore the different types of server and data replication and how they are used.

By the end of this video tutorial, you will be well versed with automating and maintaining your own database using SQL Server.

Style and Approach

This video is a step-by-step guide that will help you understand and master the administration aspects of SQL Server 2016, with examples and use cases wherever required. Every topic is explained in a clear, easy to understand manner.

Table of Contents

Backup and Recovery
The Course Overview
Backup Strategy
Full Database Backups
Differential Database Backups
Transaction Log Backups
Basic Database Restores
Restoring Transaction Logs
Restoring to a Point in Time
Server Automation
SQL Server Agent
SQL Agent Jobs
Job Schedules
Operators and Notifications
Alerts
Database Mail
High Availability and Disaster Recovery
Clustering
Availability Groups
Database Mirroring
Log Shipping
Replication

What You Will Learn

  • Create a backup strategy and perform full and differential restores
  • Configure and use a database mail to send messages under server automation
  • Create full database backups and work with different actions
  • Install and configure ‘Always On’ availability groups
  • Create operations and notifications based on server options

Authors

Table of Contents

Backup and Recovery
The Course Overview
Backup Strategy
Full Database Backups
Differential Database Backups
Transaction Log Backups
Basic Database Restores
Restoring Transaction Logs
Restoring to a Point in Time
Server Automation
SQL Server Agent
SQL Agent Jobs
Job Schedules
Operators and Notifications
Alerts
Database Mail
High Availability and Disaster Recovery
Clustering
Availability Groups
Database Mirroring
Log Shipping
Replication

Video Details

ISBN 139781787281431
Course Length2 hours 30 minutes
Read More
From 1 reviews

Read More Reviews

Recommended for You

SQL Server 2016 Advanced Security and Administration [Video] Book Cover
SQL Server 2016 Advanced Security and Administration [Video]
$ 124.99
$ 5.00
Learn C# With Windows Forms and SQL Server [Video] Book Cover
Learn C# With Windows Forms and SQL Server [Video]
$ 98.99
$ 5.00
Server-Side Development with Kotlin and Spring Boot [Video] Book Cover
Server-Side Development with Kotlin and Spring Boot [Video]
$ 124.99
$ 5.00
ECMAScript 2016 and Beyond [Video] Book Cover
ECMAScript 2016 and Beyond [Video]
$ 124.99
$ 5.00
Deploying and Running Docker Containers [Video] Book Cover
Deploying and Running Docker Containers [Video]
$ 124.99
$ 5.00
Unity 2017 Game AI programming - Third Edition Book Cover
Unity 2017 Game AI programming - Third Edition
$ 39.99
$ 5.00