Learn Secure Database Administration- MS SQL Server Security

Learn Secure Database Administration: MS SQL Server Security, available at $84.99, has an average rating of 4.4, with 30 lectures, 3 quizzes, based on 38 reviews, and has 219 subscribers.

You will learn about 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 This course is ideal for individuals who are DBAs or Database Developers in all levels or Business Intelligence Developers or Full Stack Software Developers or Software Developers who are related with databases or Data Scientists It is particularly useful for DBAs or Database Developers in all levels or Business Intelligence Developers or Full Stack Software Developers or Software Developers who are related with databases or Data Scientists.

Enroll now: Learn Secure Database Administration: MS SQL Server Security

Summary

Title: Learn Secure Database Administration: MS SQL Server Security

Price: $84.99

Average Rating: 4.4

Number of Lectures: 30

Number of Quizzes: 3

Number of Published Lectures: 30

Number of Published Quizzes: 3

Number of Curriculum Items: 35

Number of Published Curriculum Objects: 35

Original Price: $84.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

DBAs or Database Developers in all levels

Business Intelligence Developers

Full Stack Software Developers

Software Developers who are related with databases

Data Scientists

Target Audiences

DBAs or Database Developers in all levels

Business Intelligence Developers

Full Stack Software Developers

Software Developers who are related with databases

Data Scientists

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: About Your Trainer

Lecture 2: Overview

Lecture 3: Installation Decisions

Lecture 4: Installating Windows Server

Lecture 5: Installing Windows Server 2016

Lecture 6: Configuring Windows Server 2016

Chapter 2: Microsoft SQL Server Installation

Lecture 1: Installing .net framework 3.5

Lecture 2: SQL Server Installation Preparations

Lecture 3: SQL Server Installation

Chapter 3: Configuring Microsoft SQL Server

Lecture 1: MS SQL Server Configuration Overview

Lecture 2: SQL Server Configuration Manager

Lecture 3: SQL Server Accounts

Lecture 4: Managing Network Protocols

Lecture 5: Using Powershell To Manage Network Protocols

Lecture 6: Surface Area Configutation With sp_configure

Lecture 7: Surface Area Configuration With SSMS

Chapter 4: Hardening Microsoft SQL Server

Lecture 1: Surface Area Reduction Introduction

Lecture 2: Service Area Reduction

Lecture 3: Static and Dynamic Port Configurations

Lecture 4: Extended Protection with Channel and Service Blinding

Lecture 5: Hiding SQL Server Instance

Chapter 5: Policy Management

Lecture 1: Policy Based Managent Introduction

Lecture 2: Monitor xpcmdshell

Lecture 3: Preventative Policies

Lecture 4: Login Creation Preventative Policy

Lecture 5: Introduction to Service Account Security

Lecture 6: Service Account Security Practice

Lecture 7: SQL Assistant Tools

Lecture 8: Patching and Complience

Chapter 6: Lab Practices

Chapter 7: Closing

Lecture 1: Conclusion

Instructors

FeltSecure Labs
FeltSecure Labs: Cyber Security Courses with 10000+ Students

Rating Distribution

1 stars: 1 votes

2 stars: 3 votes

3 stars: 6 votes

4 stars: 7 votes

5 stars: 21 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!