SQL Server 2016 - Maintenance & Automation
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server 2016 - Maintenance & Automation to your Wishlist.

Add to Wishlist

SQL Server 2016 - Maintenance & Automation

Safeguard your business continuity and database with the help of Backup, Automation, and Disaster Recovery
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3 students enrolled
Created by Packt Publishing
Last updated 7/2017
English
Curiosity Sale
Current price: $10 Original price: $125 Discount: 92% off
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • Should have basic knowledge of SQL Server.
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.

About the Author

Steve Jones has been working with SQL Server since 1991. He has worked with all versions of SQL Server as a developer and DBA, in a variety of industries and companies. Over the last 25 years, he been greatly pleased with the enhancements and growth of the platform; he feels SQL Server is an outstanding database platform that is suited to a wide variety of needs and situations.

In 2001, Steve founded SQLServerCentral with Brian Knight, Andy Warren, and three other partners. In 2002, Steve left his job with PeopleSoft to manage SQLServerCentral as a full-time editor, publisher, and writer. Andy, Brian, and Steve continued to manage and grow SQLServerCentral until 2007 when it was sold to Redgate Software along with Database Weekly (then Database Daily). At that time Steve went on to work for Redgate and has continued his work with SQLServerCentral and Red Gate as a writer and speaker.

Steve regularly presents at SQL Saturday conferences and other technical events on career and technical topics, and enjoys meeting and interacting with the SQL Server community. He has been a presenter at //build/, the PASS Summit, Dev/IT Connections, VSLive, SQL Bits, SQL Intersection, and many user groups in the US.

Steve is a graduate of the University of Virginia. He has been awarded the title of Microsoft Data Platform MVP from 2008–2017 for his many contributions to the SQL Server community. Steve holds an MCSE from NT 4.0, an MSITPro in SQL Server, and numerous other MCP certifications in SQL Server.

Who is the target audience?
  • If you are a database analyst or database developer with basic knowledge of SQL Server, and you want to learn to maintain and automate your DBMS, then this is the video course you've been looking for!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
19 Lectures
02:29:53
+
Backup and Recovery
8 Lectures 50:20

This video gives an overview of our entire course

Preview 03:12

In this video, we will learn to build a backup strategy for your databases based on the needs of your organization.

Backup Strategy
09:21

In this video, we will perform a full database backup with the options necessary for your database.

Full Database Backups
09:53

In this video, we will perform a differential database backup.

Differential Database Backups
04:57

In this video, we will perform a transaction log backup of your database.

Transaction Log Backups
04:27

In this video, we will restore a backup file as a new database.

Basic Database Restores
07:32

In this video, we will restore a log backup to meet a more detailed RPO.

Restoring Transaction Logs
04:20

In this video, we will restore a transaction log to a point in time.

Restoring to a Point in Time
06:38
+
Server Automation
6 Lectures 45:15

In this video, we will configure SQL Server Agent to run on your instance.

Preview 08:53

In this video, we will add a job to your SQL Server Agent subsystem.

SQL Agent Jobs
10:38

In this video, we will learn to set schedules for SQL Server Agent jobs.

Job Schedules
06:06

In this video, we will set operators in your SQL Server instance.

Operators and Notifications
06:06

In this video, we will add event alerts to the SQL Server Agent system.

Alerts
06:32

In this video, we will configure and use Database Mail for your SQL Server instance.

Database Mail
07:00
+
High Availability and Disaster Recovery
5 Lectures 54:18

In this video, we will configure and failover a cluster.

Preview 10:25

In this video, we will administer an availability group.

Availability Groups
13:11

In this video, we will setup database mirroring.

Database Mirroring
11:10

In this video, we will setup log shipping between two instances.

Log Shipping
08:31

In this video, we will configure transactional replication between two databases.

Replication
11:01
About the Instructor
Packt Publishing
3.9 Average rating
7,282 Reviews
52,028 Students
616 Courses
Tech Knowledge in Motion

Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.

With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.

From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.

Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.