SQL Server 2016 Administration SQL Security with Hands-On (Udemy.com)

Get advanced skills to be a SQL Server professional and hardening Microsoft SQL Server securing SQL+ SQL Server login

Created by: Zulqarnain Hayat

Produced in 2021

icon
What you will learn

  • securing the Microsoft SQL Server

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100

icon
Course Description

Make sure your network's SQL Servers are secure, using best practices for physical, instance, network, and file system security. In this course we introduces basics like SQL Server securables, principals, logins, users, and roles. Then learn how SQL Server checks permissions and use that information to create accounts and assign logins and roles. Last also will explains common network security risks and steps you can take to secure network protocols.
The following topics are covered:
  1. Understanding security best practices
  2. Managing logins and users
  3. Understanding how SQL Server checks permissions
  4. Creating and assigning logins and roles
  5. Securing SQL on the network
  6. How to Configuring encryption
    1. Encryption overview
    2. Implement cell-level encryption
    3. Configure transparent data encryption
    4. implement always Encryption
    5. implement backup encryption
    6. Configure encryption for connections
Who this course is for:
  • Database Administrator, Database developer

icon
Instructor Details

placeholder

I have done Master in Computer science (IT) and additionally I have more than 14 years of professional experience UNIX administration, Oracle database administration with different flavors (Solaris, Linux, Oracle Linux, Red Hat) and working as role Database specialist.I have completed command over following functions and skills.
Key Skills:
Oracle Database Administration
MS SQL Server Administrations
MYSQL/MariaDB Administration
Sun Solaris Administration (Certified)
Linux Administration (Red Hat ,CENTOS,UBUNTU)
Oracle Application Server Administration
Banner UDC technology stack DBA track
Application Administration (LAMP,LEMP)
Oracle EBS Administration
Oracle Database Administration (RAC, Data Guard)
Oracle Business Intelligence Administration
Hyperion /ESBASE/WEB LOGIC
Windows Server Administration
Oracle Data Warehouse Builder
SQL Server Administration
Project Management
Problem solving skills and approach
Systems audit and control
Oracle OAM 11G,OSSO 10G EBS R12
Data Center Design and Implementation
VMware Infr

icon
More courses by Zulqarnain Hayat

Learning IT Help Desk Basics

$11.99

icon
Reviews

4.7

19 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

Tiene mucha experiencia para mi fue perfecto

great!!!!!!!!!!!!!!!

Amazing Experience and valuable

It covers plenty of useful info steps by steps with demo..... Thank you sir Keep it up.

Enjoyed with Experienced instructor, in depth explanation, very easy to understand and relate to real hands-on demo, simply an amazing course, fantastic course Hayat.Thanks

Excellent!! what i was expected. thanks

if you want to learn about securing database, that course is truly the best course for you

informative and concise.

Expected and very clear

Great so far

Great delivery

very informative about MSSQL 2016 security advance features like encryption