Study Learn Grow
SQL Server 2016 Advanced Security And Administration

SQL Server 2016 Advanced Security And Administration


Learn and implement advanced skills to be a SQL Server professional

Overview

Learn and implement advanced skills to be a SQL Server professional

SQL Server is a complex and feature rich platform that can requires knowledge and practice to extract optimum performance from an instance. This course will assist a database administrator in understanding the advanced security features that protect data within databases. You will also gain an advanced understanding in how to examine the activity on your system and better tune the database code to run efficiently.

In SQL Server 2016 Advanced Security and Administration, we go beyond the basics of managing and securing a SQL Server instance. This course will look at the complex world of encryption and how you can enable this to protect data at rest as well as inside the database. Learn about Always Encrypted, where the data is always protected outside of the client system. The course will show how Dynamic Data Masking and Row-Level Security can be used to ensure that your clients only view the data they should be allowed to view. Since performance is important to all clients, the course covers the ways in which an administrator can determine what activity is taking place on a database through Extended Events and how to analyse and improve performance of queries using execution plans and the Query Store.

In the end you will learn how to ensure predictable performance by analysing activity to find any performance problem, use detailed execution plans to tune query code, and use Query Store to prevent plan regressions.

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.

Course Information

This course will consist of explanations of each feature along with demonstrations that enable the viewer to understand how to use each feature

Learn to enable and administer Always Encrypted to secure data on the network and inside the database
Use Row-Level Security to selectively limit access to data by user
Configure Dynamic Data Masking to obfuscate data consistently in your applications
Enable encryption to protect data stored in SQL Server
Create Extended Event sessions that capture the activity on your database
Analyze activity on your system to troubleshoot issues your clients experience
Capture query execution plans to understand how the application is performing
Learn to read plans and tune the system based on the data clients need
Enable the Query Store to track query activity over time
Force query plans with the Query Store that can help ensure predictable performance

This video is for SQL Server administrators that want to go beyond the basics they have learned. Once you know how to create logins and users, add them to your database, create indexes, and ensure backups are running, this course is the next step in your education. Learn to use advanced security features to limit access to data and encrypt sensitive information. Learn to improve performance by capturing activity, reading execution plans, and forcing the best plans to be used.

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs