Masterclass: Hacking and Securing Microsoft SQL Server 2019 Eğitimi

  • Eğitim Tipi: Virtual Classroom
  • Süre: 5 Gün
  • Bu eğitimi kendi kurumunuzda planlayabilirsiniz. Bize Ulaşın!
En Yakın Tarih

09 Mayıs 2021

5 Gün

In this workshop you will analyze, learn and practice critical tasks for implementing highly secure SQL Server infrastructure. We’ll start with identifying security needs regarding database servers and look at the most common attack types and use them on ‘out of the box’ installation. In simple words we will hack our systems! 


Then we will discuss impact of system and network security on databases server. Next, we will go through every layer of protection offered by SQL Server with lots of real-life examples and hands on labs. At the end we will look at the monitoring and auditing our infrastructure to detect threats and react to them. Additionally, we’ll play with security of other SQL Services and Azure SQL Databases. Our goal is to show and teach you how to protect your precious data in SQL Server environment and how database security mechanisms work. After the course you will be able to test and secure your SQL Server infrastructure. And to get more practice we offer three extra weeks of labs online!


 We want you to leave the class with scripts, checklists and practical, ready-to-use knowledge of how to hack, test and secure your SQL Server infrastructure! 


This course is a must-go for database administrators, IT professionals and security officers dealing with database servers. Delivered by highly skilled SQL and database enthusiast with practical knowledge, multiple successful projects, many years of real-world experience and great teaching skills. The course has a form of intense workshop where we make a deep dive inside the SQL Server. All exercises are based on SQL Server 2019 and Windows Server 2019.

To attend this training you should have good hands-on experience in administering Microsoft SQL Server infrastructure. At least 2 years in the field is recommended.

Database administrators, infrastructure architects, security professionals, system engineers, advanced database developer, IT professionals, security consultants and other people responsible for implementing databases security.

Module 1 Hacking SQL Server Infrastructure 

a) Discovering SQL Server instances 

b) SQL injection using men in the middle 

c) Capturing SQL credentials using men in the middle 

d) Decrypting SQL Logins passwords 

e) Gaining access to SQL Server on compromised Windows Server 


Module 2: SQL Server security baseline concepts 

a) Defining security objectives 

b) Configuring service accounts 

c) Auditing database permissions 

d) Implementing physical protection 

e) Configuring firewall 

f) Securing client-server communication 


Module 3: SQL Server Instance security 

a) Limiting permissions 

b) Securing CLR 

c) Implementing protection for extended procedures 

d) Protecting linked servers (OPENROWSET) 

e) Securing by using policies 

f) Hiding instance metadata 


Module 4: Managing Logins and Passwords 

a) Authentication options 

b) Implementing password policies 

c) Securing connection strings Customizing login / user authorization 


Module 5: Encryption in SQL Server 

a) Key management 

b) Code and data encryption 

c) Managing certificates 

d) Transparent database encryption 

e) Encryption in HA and Disaster Recovery



Eğitimlerle ilgili bilgi almak ve diğer tüm sorularınız için bize ulaşın!

Yakın tarihte açılacak eğitimler

Sınıf eğitimlerimizi İstanbul, Ankara ve Londra ofislerimizde düzenlemekteyiz. Kurumunuza özel eğitimleri ise, dilediğiniz tarih ve lokasyonda organize edebiliriz.

09 Mayıs 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
22 Mayıs 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
05 Haziran 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
21 Haziran 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
03 Temmuz 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
19 Temmuz 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
06 Ağustos 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
17 Ağustos 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
11 Eylül 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
25 Eylül 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
16 Ekim 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
19 Ekim 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
02 Kasım 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
21 Kasım 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
01 Aralık 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra
18 Aralık 2021
5 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
İstanbul, Ankara, Londra