Masterclass: Hacking and Securing SQL Server

Live Virtual Class – Super Intensive Remote Training with Labs!
(9:00am – 4:00pm CEST Monday to Friday)
3000 EUR 3500 EUR (net)
Early-bird offer valid till September 16th!

Register Now

Masterclass: Hacking and Securing SQL Server

This is an international Live Virtual Class where you will be able to share the learning experience with a group of IT pros from around the world without leaving your home or office! The class is taught fully remotely in English by CQURE Cybersecurity Experts. In order to ensure the highest quality and unique learning experience, the course is limited to 12 participants by default, or supported by an assistant instructor if the number of delegates exceeds 12. During this course, you will have the opportunity to go through CQURE’s custom lab exercises, interact with our world-renowned Expert and receive a lifelong certification after completing the course!

See the schedule of our all Live Virtual Classes

Upcoming Live Virtual Classes

Live Virtual Class Length Start Date Instructor
PAY & ENROLL 5 days-35h 07.10.2024 Damian Widera

Eligible for group discount? Click here

Loads of Knowledge

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.

To get more practice we offer three extra weeks of labs online!

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 is limited to 12 participants, so reserve your spot today!

This course is ideal for:

Enterprise administrators, infrastructure architects, security professionals, systems engineers, network administrators, IT professionals, security consultants and other people responsible for implementing network and perimeter security.

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.

Unique exercises:

The course has a form of an intense workshop where we make a deep dive inside the SQL Server. All exercises are based on SQL Server 2019 and Windows Server 2019. This course is based on practical knowledge from tons of successful projects, many years of real-world experience and no mercy for misconfigurations or insecure solutions! Remember that the labs will stay online for an extra three weeks so you may practice even more after the training is completed!

Platform and Technical Requirements:

To participate in the course you need a Stable internet connection. For best learning experience we also need you to have a webcam, headphones and a microphone. Open RDP port 3391 for the connection to the Lab environment is needed as well. We will setup a secure Zoom classroom for every day of the course – we will send you a safe link to join the conference by e-mail.

Certification:

After finishing the course, you will be granted a CQURE Certificate of Completion. Please note that after completing the course you will also be eligible for CPE points!

COURSE FORMULA

Remote Delivery

We are Experts in remote delivery. In the past year, we have organized over 200 days of trainings and we have tested many solutions. The experience remains the same as in the case of face-to-face trainings – a personalized, lab intense training with a lot of interaction between you and the instructor.

Virtual Labs

You will be granted a lab access for the duration of the training and a complementary access for additional 3 weeks after the training concludes with new challenging exercise instructions. With the extra self-study materials, you will be able to refresh your knowledge, acquire new skills and practically apply the techniques you have just learned.

Lifelong Certification

What is wonderful about our certification is that it is lifetime valid with no renewal fees – the technology changes, but fundamentals and attitude remain mostly the same. Our Virtual Certificates, which entitle you to collect CPE Points, are issued via Accredible.

COURSE SYLLABUS

Module 1

Hacking SQL Server Infrastructure

  1. Discovering SQL Server instances
  2. SQL injection using men in the middle
  3. Capturing SQL credentials using men in the middle
  4. Decrypting SQL Logins passwords
  5. Gaining access to SQL Server on compromised Windows Server

Module 2

SQL Server security baseline concepts

  1. Defining security objectives
  2. Configuring service accounts
  3. Auditing database permissions
  4. Implementing physical protection
  5. Configuring firewall
  6. Securing client-server communication

Module 3

SQL Server Instance security

  1. Limiting permissions
  2. Securing CLR
  3. Implementing protection for extended procedures
  4. Protecting linked servers (OPENROWSET)
  5. Securing by using policies
  6. Hiding instance metadata

Module 4

Managing Logins and Passwords

  1. Authentication options
  2. Implementing password policies
  3. Securing connection strings
  4. Customizing login / user authorization

Module 5

Encryption in SQL Server

  1. Key management
  2. Code and data encryption
  3. Managing certificates
  4. Transparent database encryption
  5. Encryption in HA and Disaster Recovery

Module 6

Protecting database backups

  1. Securing backup files
  2. Setting backup file passwords and encryption
  3. Handling keys and certificate backups
  4. Security considerations while restoring to another SQL Server instance

Module 7

Monitoring and auditing

  1. Login auditing options
  2. Data access auditing
  3. Data Manipulation Language custom auditing
  4. Policy-based management
  5. Forensics case study

Module 8

Securing other SQL Server services

  1. SQL Server Agent
  2. SQL Server Analysis Services
  3. SQL Server Reporting Services
  4. Azure SQL Database
Register Now

Click here to browse the modules:

YOUR TEACHER

Mike Jankowski-Lorek, Ph.d.

CQURE Director of Consulting, Cybersecurity Expert, Trainer

Mike Jankowski-Lorek is a solution architect, developer, data scientist and security expert with more than 18-years’ experience in the field. He designs and implements solutions for organization identity and access databases, network and security monitoring and management, mainly working in Microsoft ecosystem for medium to enterprise level organizations. Mike holds multiple certifications, especially security, database and software development related. He is one of core Experts at CQURE and holds a PhD in Computer Science.

Przemek Tomasik

Cybersecurity Expert

Przemek Tomasik is CQURE’s Cybersecurity Expert with over 18 years of IT experience, focusing the last decade on security and compliance. He has worked for financial, ecommerce, and hospitality industry in Fortune 500 companies. In 2017 he opened a new chapter in his IT career – educating in security. Thanks to his practical and current knowledge, he conducts training in an interesting and accessible way, focusing on current trends.

Damian Widera

Data Platform MVP, Software Engineer, Trainer

Damian is a software engineer with over 20 years of professional experience in all aspects of data platform development. He has participated in a number of projects in international environments and possesses practical knowledge of procedures and tools which are necessary for successful implementation of such projects.
Damian currently focuses on building solutions based on Microsoft Azure environment including complex database driven systems, machine learning, big data processing, tuning and optimization. As an experienced trainer, speaker and columnist, he is always eager to take part in new engagements.
In 2022, for the 14th time, he has been awarded Microsoft’s Data Platform MVP. In addition, he holds various Microsoft Certifications since 2004: Microsoft Certified Trainer, Solution Developer and Application Developer for .NET, Database Administrator, as well as Microsoft Certified Solutions Expert in Data Platform.

WHO IS IT FOR?

Audience

The course is perfect for enterprise administrators, infrastructure architects, security professionals, systems engineers, network administrators, IT professionals, security consultants.

Recommendations

We recommend good hands-on experience in administering Microsoft SQL Server infrastructure with least 2 years in the field.

Exercises

All exercises are based on SQL Server 2019 and Windows Server 2019.

“All of their classes are based on their real world experience with the products, not just the typical Official Curriculum style classes that teach you things for an exam, but that you never use. You’ll find that all of the material you’ll lrarn in the class will be used, at some point, in your security career.”

Jack Perry

Security Principal Consultant - Presido

“Totally professional, total great stuff, in-depth knowledge and a perfect Learning Atmosphere! I like it! Thanks so much for sharing your experience and knowledge!”

Martin Weber

CTO - IT.INNOVATION.4U

“I have attended CQURE’s training as someone who is not a security professional, but just an enthusiast, and I feel like I learned a A LOT. The whole training was loaded with information and nice demos of the latest technologies. On top of that — having an opportunity to ask and talk to professionals was priceless.”

Marek Chmel

SQL SERVER DBA - AT&T

×