Getting Started with SQL Server 2016 Administration
4.3 (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.
34 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Getting Started with SQL Server 2016 Administration to your Wishlist.

Add to Wishlist

Getting Started with SQL Server 2016 Administration

Configure, administer, and deploy a high-performance, highly available SQL Server
4.3 (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.
34 students enrolled
Created by Packt Publishing
Last updated 5/2017
English
Curiosity Sale
Current price: $10 Original price: $125 Discount: 92% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • How to install SQL Server
  • Login and user security
  • Creating user databases
  • Administering database objects
  • How to improve query performance
View Curriculum
Requirements
  • Some understanding of T-SQL would be helpful, but not mandatory.
Description

SQL Server DBAs enable efficient administration of its SQL Server solution to get breakthrough performance and top-notch security. This video 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. You will learn how to secure your SQL Server solution by implementing various authentication techniques. Finally, you'll ensure your database is always available and ready for any catastrophe.

This comprehensive tutorial is packed with real-world examples and tips to solve the trickiest of challenges. By the end of this course, you will have a solid foundation in all SQL Server administration concepts and will be able to implement them in a production environment.

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 an administrator, developer, or a DBA with some knowledge of SQL Server concepts who wants want to learn SQL Administration, this video is for you.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
31 Lectures
03:49:41
+
Installing SQL Server 2016
5 Lectures 28:40

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
+
Login and User Security
8 Lectures 48:04

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
+
Databases
5 Lectures 37:00

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
+
Administering Database Objects
7 Lectures 01:11:07

This video will explain what a user table is and how to create one.

Preview 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
+
Improving Query Performance
6 Lectures 44:50

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.

Preview 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
About the Instructor
Packt Publishing
3.9 Average rating
7,282 Reviews
52,051 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.