Seminar Details

Masterclass: Hacking and Securing SQL (sHSSQL)

ETC
sHSSQL
Hersteller-ID:
Prüfungs ID:
Dauer: 5 Tage
Preis: € 3.965.- exkl.MwST
Wissensgarantie: hier nicht automatisch anwendbar – bitte kontaktieren Sie Ihren Betreuer für Details

Info: This Lighthouse training is held in English!
Die Hacking und Securing SQL Server Masterclass aus der ETC Lighthouse Series!

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.
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 2016 and Windows Server 2016.

After the course you will be able to test and secure your SQL Server infrastructure and have knowledge for these topics:
  • Hacking SQL Server Infrastructure
  • SQL Server security baseline concepts
  • SQL Server Instance Security
  • Managing Logins and Passwords
  • Encryption in SQL Server
  • Protecting database backups
  • Monitoring and auditing
  • Securing other SQL Server services
 
  • SPECIAL! To get more practice we offer three extra weeks of labs online!

Alle Details einblenden

Zielgruppe

This course is a must-go for:
  • Database administrators, infrastructure architects, security professionals, system engineers, advanced database developer, IT professionals, security consultants and other people responsible for implementing databases security.

Vorkenntnisse

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

Schwerpunkte

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
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
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
Managing Logins and Passwords
  1. Authentication options
  2. Implementing password policies
  3. Securing connection strings
  4. Customizing login / user authorization
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
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
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
Securing other SQL Server services
  1. SQL Server Agent
  2. SQL Server Analysis Services
  3. SQL Server Reporting Services
  4. Azure SQL Database
Alle Details ausblenden

1 Termin wählen

Was ist:
ILT

Ihr Klassenraumtraining - mehr Infos zu Instructor Led Trainings bei ETC erhalten Sie HIER

vILT

Mehr Infos zu vILT erhalten Sie hier

Live

Ihr virtuelles Training - mehr Infos zu ETC>Live erhalten Sie HIER

Hybrid VBT

Mehr Infos zu VBTs erhalten Sie HIER

Hybrid MOOC

Mehr Infos zu MOOCs erhalten Sie HIER

Coached Learning

Mehr Infos zu Coached Learning erhalten Sie HIER

Hotseat

Mehr Infos zum ETC Hotseat erhalten Sie HIER

Info

zusätzliche Infos zum Seminartermin

Alle Preise exkl. Mwst.

2 Paket wählen

Masterclass: Hacking and Securing SQL

ETC Live

  • Virtual Training – aber live im Seminar
  • Keine Anfahrt ins Seminarzentrum notwendig
  • Seminarunterlagen, Teamwork, Labs 24/7
  • ETC>Live Support und Hotline
  • ETC-Services

 

€ 3.965.-
(€ 3.965.- p.P.)

Preis

  • Ihr ILT Seminar (Instructor Led Training)
  • Seminarunterlagen, Teamwork, Labs
  • Verpflegung vorort in einem der ETC Seminarzentren
  • Seminar-Services
€ 3.965.-
(€ 3.965.- p.P.)

Ihre Fragen zum Seminar

CHAT mit Experten ODER Rückruf anfordern

Kein passender Termin dabei? Mehr als 5 Personen? Firmentermin gewünscht?

Rufen sie uns an +43/1/533 17 77 - 99

Bewertungen

4 Bewertungen
Immer noch ein TopTrainer!
von
von
Sehr interessanter Kurs, Trainer war sehr gut
von
Sehr guter und informativer Kurs. Der Trainer war sehr kompetent.
von