Learn Secure Database Administration: MS SQL Server Security

Name: Learn Secure Database Administration: MS SQL Server Security
Rating: 4.2 (38 reviews)

Installing, configuring and hardening Microsoft SQL Server

Created byFeltSecure Labs

Last updated 12/2017

English

What you'll learn

Learn how to install Microsoft Windows Server
Prepare Microsoft Windows Server environment for MS SQL Database installation
Learn how to install Microsoft MS SQL Database from scratch
Installation decisions before building the RDBMS
Learn how to use Microsoft SQL Server Configuration Manager
Learn how to use Microsoft SQL Server Management Studio
Configure SQL Server in a secure way
Learn hardening Microsoft SQL Server
Surface Area Configuration & Reduction
Policy Based Management with Microsoft SQL Server
Using Powershell to configure SQL Server

Course content

7 sections • 30 lectures • 3h 22m total length

About Your Trainer1:31
Overview5:44
Installation Decisions4:14
While designing your database system, you have to determine the most appropriate hardware according to your needs and requirements. Virtualization, CPU sockets and cores, Memory size are the factors to be considered in. Then you need to select the appropriate Operating System and its edition and select the appropriate Edition of SQL Server;
Installating Windows Server3:02
For any database system, you have to install a server operating system to your server. This can be Linux-based or Windows-based. We choose Windows Server for this process.
After installing Windows Server, we will install ADDS (Active Directory Domain Services) for a domain-controller and we will create a domain
Installing Windows Server 201611:56
In this lesson we will

Install Windows Server 2016
Install Guest Additions
Configuring Windows Server 20169:17
In this lesson we will
Install Active Directory Domain services
Install DNS
Promote server to a domain controller
Add a new forest (higher layer of a domain. 1 or more domains can be under 1 forest)

Installing .net framework 3.52:25

In this lesson, you're going to learn how to install .Net framework 3.5 on Windows Server 2016.
SQL Server Installation Preparations11:00

In this lesson, you're going to learn how to install sql server from scratch. This is important because you will be able practice the security configurations and hardening procedures on SQL server, if you follow along.
SQL Server Installation13:48
In this lecture we will install
Management tools
Database engine services
Named instance.
SQl Server agent
SQL Server Browser
Quiz - 1

MS SQL Server Configuration Overview1:19
SQL Server Configuration Manager is a tool

to manage services associated with the SQL Server
to configure the network protocols used by SQL Server
to manage the network connectivity configuration from SQL Server client computers
SQL Server Configuration Manager3:53

In this lesson, you're going to learn how to configure SQL server with the SSCM
SQL Server Accounts5:19
VirtualAccounts
Managed Service Accounts
Group Managed Service Accounts
Managing Network Protocols4:15

In this lecture, you will practice configuring sql server network configurations, such as forcing encryption, hiding instance etc
Using Powershell To Manage Network Protocols5:49

In this lecture, you will how to leverage powershell to configure network settings of the sql server
Surface Area Configutation With sp_configure12:02
In this lecture we will focus on the top factors for securing your SQL Server instance and its hosted databases
Surface Area Configuration With SSMS4:50
In this part, you will learn another way to update configuration options using SSMS, sql server management studio
Quiz - 2

Surface Area Reduction Introduction5:30

SQL Server is a popular target for hackers, so your data is at risk of being intentionally compromised. In addition, your data is also at risk of being accidentally compromised. You can minimize these risks by hardening SQL Server, which involves reducing its surface area and other security measures.
Service Area Reduction8:31
In this lecture, you learn how to install required services on your sql server, or disable such features if you don't need them
Static and Dynamic Port Configurations9:00
In this lecture, you will learn
Setting a dynamic port
Setting a static port
Allowing a static port through firewall
Allowing a dynamic port
Extended Protection with Channel and Service Blinding7:06
In this lecture, you will learn how to install a certificate on the sql server in order to enable channel binding
Hiding SQL Server Instance1:57
In this lecture, you will learn how to hide an instance of the database Engine in SQL Server by using SQL Server Configuration Manager
Quiz - 3

Policy Based Managent Introduction1:48
Monitor xpcmdshell11:18

In this lecture, you will learn how to create a new policy to log the changes of a configuration. Specifically, you will create a policy for xp_cmdshell procedure
Preventative Policies6:08
Login Creation Preventative Policy4:08

The idea behind this policy is, if you try to create a new login on SQL server, this condition will detect this. And then the policy will prevent this happening.
Introduction to Service Account Security1:56
Service Account Security Practice8:39

In this topic, you will learn how to create a managed service account to run SQL server jobs with limited permissions
SQL Assistant Tools11:02
In this lecture we will install
Baseline Security Analyzer
Open Management Studio
Patching and Complience2:57

Requirements

Basic understanding of IT systems
Basic understanding of how relational database management systems work
Computer Science background or job experience on IT is a plus
Some database management experience is a huge plus

Description

Database management is so essential and critical for the enterprises but making it secure is more crucial than that. MS SQL Server is one of the most popular commercial RDBMSs recently.

In this course, MS SQL database management concepts will be explained with security in mind

All crucial security measures will be explained throughout the course and will be implemented during the hands-on practice labs.

With a hands-on style, we'll cover topics such as

Preparing a windows server for secure installation,
MS SQL server configuration
Surface area reduction with sp_configure,
Extended protection against luring attacks and spoofing attacks,
Static and dynamic port configurations,
Channel and service binding techniques,
Hiding SQL instance
Policy based management and preventative policy examples
Patching and compliance
And many more best practices in this domain.

We will also have 2 lab assignments about creating a table name policy and a powershell proxy job on MS SQL Server, which we will solve the problems together.

By the end of the course, you'll know how to install and manage secure MS SQL server with confidence, which gives you the skills to prevent data leakages even if the cyber attacks can bypass other security mechanisms in place.

Who this course is for:

DBAs or Database Developers in all levels
Business Intelligence Developers
Full Stack Software Developers
Software Developers who are related with databases
Data Scientists

Learn Secure Database Administration: MS SQL Server Security

What you'll learn

Explore related topics

Course content

Introduction6 lectures • 36min

Microsoft SQL Server Installation3 lectures • 27min

Configuring Microsoft SQL Server7 lectures • 37min

Hardening Microsoft SQL Server5 lectures • 32min

Policy Management8 lectures • 48min

Lab Practices0

Closing1 lecture • 4min

Requirements

Description

Who this course is for: