fbpx
cybersecurity
education
€ EUR
  • $ USD
  • € EUR
  • #course
  • #livevirtualclass

Hacking and Securing SQL Server

Live Virtual Class - Super Intensive Remote Training with Labs!
October 7, 2024, 9:00 am
Days
Hours
Min.
Sec.

During this 5-day course in 35 hours of super intensive training you will analyze, learn, and practice critical tasks for implementing highly secure SQL Server infrastructure. Moreover, you will be able to:

    • get the highest quality and unique learning experience – the class is limited to 12 participants by default
    • get the opportunity to interact with our world-renowned Experts
    • go through CQURE’s custom lab exercises and practice them after the course
    • receive a lifelong certification after completing the course!

 

(9:00am – 4:00pm CEST/CET Monday to Friday)

Early-bird offer valid till September 2nd!

3500

/Lowest price within 30 days €3000 (net)

Why this course?

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.

This is an international Live Virtual Class so 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!

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.

This is an international Live Virtual Class so 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!

Pricing plan

We offer you pricing plan designed and adjusted to your specific needs and budget. Buy now or book your spot and pay later.

Course timeline

  • 1. Before the course

    You will receive a Student Guide with instruction on how to prepare for the training, information regarding all the technical requirements and your own individual login credentials to the virtual environment.

  • 2. During the course

    You will be able to exercise and review all learned content on an ongoing basis.

  • 3. After the course

    You will receive a Certificate of Completion, all the materials which have been created and presented by the trainer as well as an access to our community on the Discord server.

Course benefits

How our lessons look like

  • Loads of Knowledge
  • Implementation workshop
  • Course materials
  • Unique exercises
  • Social & Network
  • Certification

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!

Implementation workshop

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..

Course materials

During the course you will be provided with a bunch of materials such as lab exercises, presentations, intriguing articles and useful tools to make your tasks a little bit easier!

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!

Social & Network

You will be granted access to our closed Discord community server where you will be able to share your thoughts with other IT specialists.

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 syllabus

This Live Virtual Class consists of 8 Modules on Hacking and Securing SQL Server. They include essential theory combined with individual practice during the exercises as well as loads of hands-on tools and real-case scenarios.

  • 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

Who is it for?

This is an advanced course on Hacking and Securing SQL Server for Cybersecurity Specialists.

Audience

The course is perfect for enterprise administrators, infrastructure architects, security professionals, systems engineers, network administrators, IT professionals, security consultants. We recommend good hands-on experience in administering Microsoft SQL Server infrastructure with least 2 years in the field.

Platform and Technical Requirements

To participate in the course you need a Stable internet connection. For the 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.

Exercises

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!

How to persuade your manager that this course is meaningful?

Investing in knowledge is one of the most worthy investment not only for us, but also for our environment. Learning new skills and insights in terms of cybersecurity may benefit with gaining awareness and as a result, may prevent falling a victim to cyber threats in the future.

Protects the Company

You will be the valuable element in regards to company’s safety – knowing about potential threats and ways of avoiding them may be incredibly useful in a daily company life.

Improves Employees skills

Not only your company will gain a specialist in terms of cybersecurity, but also you will unlock the door for expanding your skills horizon even further.

Boosts customer confidence

Completed course with personal certification may be the perfect advantage when it comes to business.

Helps comply with regulations

Knowledge is power—it helps navigate through complex regulatory landscapes. Keeping up-to-date with the latest cybersecurity regulations and standards ensures your company remains compliant, thus avoiding costly penalties and reputational damage.

Saves money in the long run

Who would have want to pay regularly for help in case of emergency data leakage in a company? It’s much better to educate the employees and prevent any cybersecurity risks.

Prepares for emerging threats

After our course, you will be educated in the possible threats and you will identify any suspicious activity online with ease.

Register now and learn from the best!

During this 35-hour super intensive training you will gain crucial cybersecurity knowledge and skills in terms of Hacking and Securing SQL Server. Moreover, you will be able to:

  • get the highest quality and unique learning experience
  • get the opportunity to interact with our world-renowned Experts
  • go through CQURE’s custom lab exercises and practice them after the course

Your Experts

This course is delivered by one of the greatest, world-renowned Cybersecurity Experts with practical knowledge from tons of successful projects, many years of real-world experience, great teaching skills and no mercy for misconfigurations or insecure solutions.

Mike

Jankowski-Lorek, Ph.D.

Director of Consulting, Cybersecurity Expert, MCT

Cybersecurity Expert, solution architect, consultant, penetration tester, and developer with more than 20 years of experience in the field. Mike holds multiple certifications, in security, database and software development. He also holds a Ph.D. in Computer Science.

Damian

Widera

Data Platform MVP, MCT, Software Engineer, Cybersecurity Expert

Software engineer with over 20 years of professional experience in all aspects of data platform development. In 2022, for the 14th time, he has been awarded Microsoft’s Data Platform MVP. He holds various Microsoft Certifications since 2004.

How can we help you?

Suggested searches

    Search history

      Popular searches:

      Not sure what course to look for?

      Mobile Newsletter Form