Koolituse eesmärk: Kolmepäevase praktilise koolituse tulemusel, saavad osalejad teadmised SQL päringukeele olemusest, dialektitest. Samuti praktilised oskused kasutada SQL funktsioone andmete puhastamiseks ja analüüsiks. Lisaks teadmised tehisaru (AI) olemusest ning kasutamisest SQL päringute kirjutamiseks.

Koolituse eduka läbimise korral on osalejal ettevalmistus  Hackerrank SQL Basic sertifikaat eksami sooritamiseks.

Sihtrühm ja eelteadmised: Koolitusele on oodatud kõik, kes soovivad arendada oma teadmisi ja oskusi andmebaasidest päringute tegemiseks. Osalejal peavad olema eelnevalt keskmised oskused arvuti käsitlemisel ning varasem kogemus andmete töötlemisega (nt Excel, Power BI, Tableau vms).

Õppevahendid: Arvuti, millel on õigused rakenduste installeerimiseks ja seadistamiseks. Kursuse käigus kasutatakse vabalt kättesaadavaid tarkvarasid: XAMPP ja Visual Studio Code.

Osalejal, kellel puudub vajalik õppevahend, on võimalus see BCS Koolituselt rentida. Palume sellest koolitusettevõtet eelnevalt teavitada.

Programm:
I koolituspäev 22.10.2026
Moodul 1 – Andmebaasid ja SQL päringukeel (2 ak h)

• Seminar, mis annab ülevaate andmebaaside ning SQL päringukeele olemusest, põhitõdedest ning kasutamise parimatest tavadest.

Moodul 2 – Kohaliku andmebaasi üles seadmine, sellega ühendumine ning andmete üles laadimine (2 ak h)

• Praktikum, mille käigus seatakse üles kohalik andmebaas ning laetakse üles andmed.

Moodul 3 – Andmete kvaliteedi kontroll ja puhastamine (5 ak h)

• Praktikum, mille käigus tehakse läbi terviklik andmete kvaliteedi kontrolli ja puhastamise protsess näidisandmestiku põhjal. Kasutatavad käsud: SELECT, DISTINCT, COUNT, MIN, MAX, AVG, LENGTH, CASE WHEN, CAST, ORDER BY, WHERE, CREATE TABLE.

II koolituspäev 23.10.2026
Moodul 4 – Andmeanalüüs (5 ak h)

• Seminar, mille käigus vaadatakse üle tabelite ühendamise loogika.
• Praktikum, mille käigus vastatakse küsimustele näidisandmestiku põhjal. Kasutatavad käsud: AVG, SUM, ROUND, GROUP BY, WITH (CTE), alampäringud.

Moodul 5 – Tehisaru (AI) tugi SQL päringute loomisel (4 ak h)

• Seminar, mille käigus tutvustatakse generatiivse tehisaru (AI) olemust, eri töövahendeid ning mudeleid.
• Praktikum, mille käigus kasutatakse tehisaru (AI) SQL päringute loomiseks ning tulemuste tõlgendamiseks.

III koolituspäev 29.10.2026
Moodul 6 – SQL – Case Study (9 ak h)

• Seminar, mille käigus osalejad saavad vastused vahepeal tekkinud küsimustele.
• Praktikum, mille käigus tehakse läbi terviklik andmete puhastamise ja andmeanalüüsi projekt.

Õppemeetodid: Õppetöös saab osaleda klassiruumi tulles või liitudes koolitusega läbi veebikeskkonna Zoom.

Koolituse maht on 27 akadeemilist tundi sh 7 akadeemilist seminari ning 20 akadeemilist tundi praktikumi.

Hindamismeetod: Praktiliste harjutuste sooritamine koolituse käigus.

Hindamiskriteerium: Õpiväljundite saavutamist hinnatakse koolituse ajal läbi viidud tagasisidestatud praktiliste harjutuste põhjal.

Koolituse lõpetamine: Koolituse lõpetaja saab tunnistuse, kui sooritab kõik koolituse jooksul antud praktilised harjutused.  Osalejatele, kes õpiväljundeid saavutanud ei ole, väljastatakse soovi korral tõend koolitusel osalemise kohta.

Hind sisaldab: Kohvipause koolituskeskuses ja ühiseid lõunasööke.

Õppekavarühm: 0613 Tarkvara ja rakenduste arendus ning analüüs

Hands-on Hacking Advanced (HOHA) is a follow-up course to our Hands-on Hacking Essentials (HOHE)training.

Target audience: System administrators, information security specialists and -managers and any other IT personnel that is not afraid of the shell or command prompt.

Pre-requisites : Prior HOHE participation is required to take this course to ensure minimum same level of participants.

Training methods: Trainers will engage participants with lectures, live attack demonstrations and practical examples followed by individual hands-on exercise scenarios. Training is interactive,
practical, and besides active participation also full of attack stories that help to change the perspective and understanding of real life security threats.

Ideology of this training: The main differences between hacking and penetration testing are the intent and (imposed) limitations. Therefore, the idea behind this training is to see practical
information security from the attacker’s or “opposing team’s” point of view and to deliver first-hand experience or running attacks. Everyone will walk through the phases of an attack until successfully owning various systems and services. There are plenty of attack scenarios to play through and to complete scored objectives. Since the expected participants’ skill and experience level is varying to a large degree, we cover a mix of *nix and Windows world and focus on explaining key concepts and on showing real attacks even to those who have never compiled or launched any exploits before.

Training objectives: During the 3 days hands-on training experience the participants should build upon HOHE training in understanding of current attacker tool-sets, attack types and methods. By experiencing the attacker mindset and point of view via hands-on exercises the participants will use Tuoni C2 and other tools from a Red Teaming perspective in order to understand what it takes in terms of individual skills to be a red team member.

Intended outcome: During the 3 day hands-on training experience the participants should form a good understanding of current attacker tool-set, attack types and methods. By experiencing the
attacker mindset and point of view via hands-on exercises the participants not only will gain much higher appreciation for attack threats, but will be much more alert and better prepared for their own IT systems defense.

Day 1

Warm-up scenario – Introduction to C2 frameworks using Tuoni. Learn to create and deliver client-side attacks that are not recognized as malicious neither by the user nor various security
products. Examples of common initial access vectors. Since all participants are expected to have completed our HOHE (Hands-on Hacking Essentials) course, we pick up speed fast and there is no time for much “spoon feeding”.

Mission: Your mission, should you choose to accept it, is to help a victim of ransomware attack. From the darknet ransomware site you discover that there is an actual company offering ransomware as SaaS and you dig deeper…

Iron Argon Development – a company “Network Takeover ” scenario of fully patched and properly configured networks. After initial reconnaissance of the target domain and public facing services we gain an initial foothold by sending phishing e-mail. Using in memory execution of different tools we gather information from infected workstation and set up persistence.

Day 2

Iron Argon Development – a company “Network Takeover ” scenario (continues)
Explanation of common .NET offensive tools for enumeration. Using Python and Tuoni API we enhance our C2 user experience. Explanation of kerberoasting. Side mission to recover domain accounts passwords from kerberoasted hashes with Hashcat. Enumeration of AD using Bloodhound. Discovering next targets and potential attack paths from Bloodhound. Lateral movement using different tunneling and C2 features inside the organization network. Bypassing applocker restrictions to execute our malware.

Day 3

Iron Argon Development – a company “Network Takeover ” scenario (continues)
We continue moving around inside the network, elevating our privileges using common misconfiguration. We steal kerberos ticket from the owned system and implant it into memory to
gain more access inside the domain. ADCS misconfigurations are common and Iron Argon Development network is not an exception here. We abuse ADCS misconfiguration to gain even more
access inside the domain and then laterally move with new permissions inside the isolated development network segment relaying our C2 traffic via SMB beacon. Side mission to take over other
servers including source code repository and backdoor the ransomware.

Mission ending
Having obtained the ransomware binary, we reverse engineer it and discover a decryption key for the victims. We finish the course with the final feedback round, re-iterate what we learned in the process and ask your opinion of the course to continuously improve the content and learning experience.

Delivery: We can deliver on-site at group pricing anywhere in the world where good broadband connection is available. Ask us for the group pricing or for times and locations of our public courses.

More information: read from here.

Service Hardening is about configuring services to reduce their attack surface. By combining various low priority configuration issues, an attacker may be able to gain access and even elevate in a system without leaving much traces behind. Training focuses on practices that can be applied to almost any service – without modifying the program code.

Participants will understand what threat hunting is, be utterly convinced of the need for it, know what infrastructure is required to facilitate it, and be able to start doing it with confidence within their own organizations.

(veel …)

During the 2 day hands-on course experience the participants should form a good understanding of current attacker tool-set, attack types and methods. By experiencing the attacker mindset and point of view via hands-onexercises the participants not only will gain much higher appreciation for attack threats, but will be much more alert and better prepared for their own IT systems defence and security testing.

(veel …)

Web Application Security (WAS) is an eye-opening practical security course for anyone involved with development, testing and upkeeping of web applications on a daily basis.

Training days: 9-10 & 16-17 November 2026

Training duration: a total of 4 days of highly practical information heavily mixed with hands-on labs: two days of Server-Side attacks (directly attacking the server itself) and two days of Client-Side attacks (attacks that incorporate the victim’s browser).

Target audience: WebApp deve8lopers, testers, QA, maintainers, team leads, project leads, web server or hosting providers / administrators, information security specialists and managers.

Teaching aids: Any operating system computer with permissions to install and configure applications.

Server-Side attacks module (2 days):

• Security, security related terminology
• Factors for calculating risk
• Information sources
• The HTTP protocol and communication, using intercepting proxies
• Web application architectures – REST vs “oldschool”
• Building a defense (user input, input validation, encoding, sanitization, defense layers)
• Authentication (passwords and hashes; rules, common misunderstandings and mythsrelated to passwords)
• Authorization (lacking access controls)
• Unintended information leakage (using search engines, metadata from files)
• Business logic issues
• SQL injection – detection, query and database structure identification, blind and partially blind attacks, incorrect defenses and bypasses
• Command injection
• Web server configuration issues
• Path traversal
• File inclusion attacks (LFI, LFI2RCE)
• File upload and processing (bypassing incorrect defenses, ZIP and XML features)
• Server-Side Request Forgery (SSRF)
• XML eXternal Entity (XXE)

Client-Side attacks module (2 days):

• Browser security policies and terminology
• Cross-Site Script (XSS) – what it is and what it is not
• Web Content Injection attacks (HTML injection, JavaScript injection)
• URL encoding, URL manipulation
• Referrer, Referrer-Policy
• Content Execution Attacks
• Web Content Execution from uploaded files (HTML, XMl, SVG)
• Serving files, Content-Disposition header
• Using 3rd party content
• HTTP response headers (Content-Security-Policy (CSP), X-Content-Type-Options, StrictTransport-Security)
• Browser storages
• Cookies, setup and parameter nuances
• Web Storage API
• Session, session hijacking and session fixation attacks
• Client-Side Request Forgery attacks
• Cross-Origin Resource Sharing (CORS), CORS-safelisted and pre-flight requests, related headers
• UI Redress Attacks (ClickJacking)

Training methods: Our course employs a dynamic blend of theoretical concepts and hands-on application. Through interactive lectures, engaging discussions, and immersive labs, participants actively experience web application security. Everyone, regardless of their background, will successfully complete the labs, either independently or with guidance from our expert instructors. By placing you in the attacker’s shoes within our dedicated lab environment, we transform theoretical knowledge into practical skills. Instructors leverage real-world case studies and storytelling from penetration tests to provide a vivid and relatable learning experience. This approach ensures that participants not only grasp the intricacies of security principles but also gain the practical know-how to navigate and secure real-world scenarios.

Ideology of this training: At the core of our course is the belief that understanding the offensive side is paramount to effective defense. The “Attack to Defend” motto encapsulates this ideology, emphasizing the importance of practical knowledge. We go beyond traditional approaches, challenging outdated terms and providing insights into cutting-edge techniques. The course is designed not just to teach security principles but to instill a proactive mindset, empowering you to anticipate and thwart potential threats.

Intended outcome: By the end of this course, participants will possess the expertise to architect inherently secure software, integrating robust defense mechanisms seamlessly into the development process.Security will be ingrained as a proactive element, enabling participants to identify vulnerabilities early and build resilient applications from the ground up. Whether you’re a security enthusiast, developer, or IT professional, this program equips you to confidently create digital landscapes where security is not an addition but an integral part of the development lifecycle.

Graduation Criteria: A graduate of the training receives a certificate if he performs all the practical exercises given during the training.  Participants who have not achieved the learning outcomes will be issued a certificate of participation in the training upon request.

Curriculum group: 0612 Database and network design and management.

More information read from here.

This five-day, fast-paced course provides comprehensive training to install, configure, and manage a VMware NSX® environment. This course covers key features and functionality offered in the NSX 4.0.0.1 and NSX 4.0.1 releases, including the overall infrastructure, logical switching, logical routing, networking and security services, firewalls and advanced threat prevention, and more.

Prerequisites:

• Good understanding of TCP/IP services and protocols
• Knowledge and working experience of computer networking, including switching and routing technologies (L2 through L3) and L2 through L7 firewall
• Knowledge and working experience with VMware vSphere® environments
• Knowledge and working experience with Kubernetes or VMware vSphere® with VMware Tanzu® environments

Program:

• Course Introduction
• VMware Virtual Cloud Network and VMware NSX
• Preparing the NSX Infrastructure
• NSX Logical Switching
• NSX Logical Routing
• NSX Bridging
• NSX Firewalls
• NSX Advanced Threat Prevention
• NSX Services
• NSX User and Role Management
• NSX Federation

Target audience: Experienced security administrators or network administrators
Learning methods: Practical exercise, independent work.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.

More information:

• Read more about the course from here.

Õppekavarühm: 0613 Tarkvara ja rakenduste arendus ning analüüs.

Lecturer’s Linkedin

This five-day training course provides you with the knowledge, skills, and abilities to achieve competence in troubleshooting the VMware vSphere® 8 environment. This course increases your skill level and competence in using the command-line interface, VMware vSphere® Client™, log files, and other tools to analyze and solve problems.

Program:

• • Introduction to Troubleshooting
  • Troubleshooting Tools
  • Troubleshooting Virtual Networking
  • Troubleshooting Storage
  • Troubleshooting vSphere Clusters
  • Troubleshooting Virtual Machines
  • Troubleshooting vCenter Server and ESXi

By the end of the course, you should be able to meet the following objectives:

• Describe troubleshooting principles and procedures
• Use the vSphere Client, the command line, and log files to configure, diagnose, and correct problems in vSphere
• Explain the key vSphere log files from troubleshooting perspective
• Describe the benefits and capabilities of VMware Skyline
• Identify the networking issues by examining the reported symptoms, and troubleshoot the reported problems
• Identify the storage issues by examining the reported symptoms, and troubleshoot the reported problems
• Troubleshoot vSphere cluster failure scenarios and analyze possible causes
• Diagnose common VMware vSphere® High Availability (vSphere HA) problems and provide solutions
• Trouble virtual machine problems, including migration problems, snapshot problems, and connectivity problems
• Identify VMware ESXi™ host and VMware vCenter Server® problems, analyze failure scenarios, and find resolutions
• Troubleshoot performance problems with vSphere components

More information:

• Read more about the course here.

Õppekavarühm: 0613 Tarkvara ja rakenduste arendus ning analüüs.

Lecturer’s Linkedin

This five-day course teaches you advanced skills for configuring and maintaining a highly available and scalable virtual infrastructure. Through a mix of lecture and hands-on labs, you configure and optimize the VMware vSphere 8 features that build a foundation for a truly scalable infrastructure. You also discuss when and where these features have the greatest effect. Attend this course to deepen your understanding of vSphere and learn how its advanced features and controls can benefit your organization.

(veel …)

This five-day course features intensive hands-on training that focuses on installing, configuring, and managing VMware vSphere® 8, which includes VMware ESXi™ 8 and VMware vCenter Server® 8. This course prepares you to administer a vSphere infrastructure for an organization of any size.
This course is the foundation for most of the other VMware technologies in the software-defined data center.

Program:

• Course Introduction
• vSphere and Virtualization Overview
• Installing and Configuring ESXi
• Deploying and Configuring vCenter
• Configuring vSphere Networking
• Configuring vSphere Storage
• Deploying Virtual Machines
• Managing Virtual Machines
• Deploying and Configuring vSphere Clusters
• Managing the vSphere Lifecycle

Target audience:  System administrators, system engineers.
Learning methods: Practical exercise, independent work.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.

More information:

• Read more about the class from here

Õppekavarühm: 0613 Tarkvara ja rakenduste arendus ning analüüs.

Lecturer’s Linkedin