Learning Path: SQL: Up and Running with SQL Server 2016
5.0 (2 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.
24 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learning Path: SQL: Up and Running with SQL Server 2016 to your Wishlist.

Add to Wishlist

Learning Path: SQL: Up and Running with SQL Server 2016

Deep dive into administration, maintenance and automation
New
5.0 (2 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.
24 students enrolled
Created by Packt Publishing
Last updated 8/2017
English
Current price: $12 Original price: $200 Discount: 94% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Create user databases and how to administer it
  • Learn to improve query performance
  • 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 ‘AlwaysOn’ availability groups
  • Create operations and notifications based on server options
View Curriculum
Requirements
  • Basic knowledge of SQL Server
  • Some understanding of T-SQL would be helpful, but not mandatory
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. If you’re an administrator, developer or a DBA and want to learn SOL along with maintaining and automating your DBMS, then go for this Learning Path.

Packt’s Video Learning Paths are a series of individual video products put together in a logical and stepwise manner such that each video builds on the skills learned in the video before it.

The highlights of this Learning Path are:

  • Work with the latest features of the SQL Server 2016 release
  • A comprehensive, example-filled tutorial that helps you to master in SQL 2016

Let’s take a quick look at your learning journey. This Learning Path will teach you basic as well as advanced administration tasks for handling, managing, and monitoring your SQL Server 2016 efficiently. After setting up and configuring your virtual machine for SQL Server 2016, you will implement various techniques to improve query performance, create indexes, and perform activity monitoring. Learn how to secure your SQL Server solution by implementing various authentication techniques.

Develop a backup strategy and carry out full database backups as well as differential database backups. Next, 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 Learning Path, you will become an expert in SQL Server 2016.

Meet Your Expert:

We have combined the best works of the following esteemed author to ensure that your learning journey is smooth:

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 very pleased with the enhancements and growth of the platform. He feels that SQL Server is an outstanding database platform well-suited to a wide variety of needs and situations.

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.

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 U.S.

Who is the target audience?
  • This Learning Path is for administrators, developers, or DBAs with some knowledge of SQL Server concepts and who want to administer, maintain, and automate their DBMS.
Compare to Other SQL Server Courses
Curriculum For This Course
50 Lectures
06:19:34
+
Getting Started with SQL Server 2016 Administration
31 Lectures 03:49:41

This video will an overview of entire course

Preview 02:04

This video shows the hardware and software requirements for installing and running SQL Server. Security requirements for services accounts are also covered.
Requirements and Recommendations
04:09

This video will show how the viewer can install SQL Server using the GUI-based setup program.

Installing SQL Server from the GUI
09:20

This video will show how you can install SQL Server using the command-line setup program.
Installing SQL Server from the Command Line
04:04

This video will show how you can upgrade SQL Server.

Upgrading SQL Server
09:03

This video will describe the security model for SQL Server and how this protects the databases on the instance.

Preview 04:12

Learn what a server login is and how to create one along with the options available.

Server Logins
05:55

You will learn about the various built-in server rolls inside SQL Server.
Built-in Server Roles
03:30

You will learn how to create and manage user-defined server roles and assign logins to them.
User-Defined Server Roles
04:55

You will learn what a database user is and how this relates to logins. You will also learn to create one and test it.
Database Users
09:52

You will learn the types of database roles, what privileges each has, and how to add users.

Built-in Database Roles
04:26

You will look at the user-defined database roles, how to create them, and add users to each of them.
User-Defined Database Roles
09:53

You will look at how to manage object level permissions and assign them to a user or role.

Object Level Permissions
05:21

This video will explain what a user database is and how to create one.
Preview 05:38

You will learn how to create a user database and set options.

User Databases
06:22

You will learn how to create and alter FileGroups for user databases.
FileGroups
09:04

You will learn how to alter options for user databases.

Database Options
05:44

You will learn how to manage the size of files for user databases.

Database Space
10:12

This video will explain what a user table is and how to create one.
Tables
08:15

You will learn how to create a view.

Views
06:43

You will learn how to create, alter, and execute stored procedures.

Stored Procedures
08:22

You will understand the two types of user-defined functions.
User-Defined Functions
15:56

You will learn how to create an assembly and then create a user-defined function.
Assemblies
07:17

You will add a file group and file for In-Memory OLTP and create a memory-optimized table.
Durable Memory-Optimized Tables
15:18

You will create non-durable memory-optimized tables and stored procedures.

Non-Durable Memory-Optimized Tables
09:16

This video will explain what a row store index is and how this helps performance and data integrity and how it relates to Primary Keys and Foreign Keys.

Row Store Indexes
07:22

You will learn how to create a clustered index.

Clustered Indexes
06:27

You will learn how to create a nonclustered index.
Non-clustered Indexes
12:59

You will learn how to create a clustered columnstore index.

Columnstore Indexes
07:44

You will learn how to create a nonclustered columnstore index.
Nonclustered Columnstore Indexes
04:40

You will learn how to create an indexed view.
Indexed Views
05:38

Test Your Knowledge
6 questions
+
SQL Server 2016 – Maintenance and Automation
19 Lectures 02:29:53
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

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

SQL Server Agent
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

In this video, we will configure and failover a cluster.
Clustering
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

Test Your Knowledge
5 questions
About the Instructor
Packt Publishing
3.9 Average rating
8,274 Reviews
59,271 Students
687 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.