Koolituse eesmärk:  Osalejad saavad baastadmised MikroTik RouterOS tarkvarast ja RouterBoard seadmetest. Lisaks oskused, kuidas osutada arvutivõrgus teenuseid kasutades selleks MikroTik riist- ja tarkvara.

Sihtrühm ja eelteadmised: Koolitus on suunatud arvutivõrkudega  töötavatele spetsialistidele, kes soovivad täiendavaid teadmisi arvutivõrkudest ja õppida kasutama MikroTik RouterOS võimalusi.

Koolitusel osalemise eelduseks on head baasteadmised arvutivõrkudest ja IP IPv4 protokollist, sh IP aadresside ning nende alamvõrkudeks jagamise oskused.

Õppevahendid: Koolitusele palume kaasa võtta oma Windows operatsioonisüsteemiga sülearvuti kuhu on eelnevalt installeeritud MS Edge, Google Chrome ning SSH klient (nt Putty).

Koolitusel osaleja saab L4/P1 litsentsi (kasutamiseks nt virtuaal serveris) ja ruuteri.

Arvutil peab olema nii WiFi kui ethenet võrguliides!

Laadige eelnevalt arvutisse all MikroTik Winbox ning veenduge, et see töötab. Winbox’i leiate aadressilt https://mikrotik.com/download

Veenduge, et teil on arvutis administraatori õigused ja saate muuta nii võrgu kui ka tulemüüri sätteid.
Soovikorral on võimalus rentida arvutit BCS koolituskeskusest.

Programm:

• Sissejuhatus MikroTik RouterBoard seadmete ja RouterOS tarvara kasutamisse;
• DHCP protokoll, klient ja server;
• Sildamise (Bridge & Switch) ülevaade;
• Marsruutimine, võrgulüüside seadistamine;
• Raadiovõrgud, erinevad töörežiimid: klient, pääsupunkt;
• Tulemüür, ülesehitus, planeerimine, reeglid, monitooring;
• QoS, Järjekorrad (Queue), liikluse prioriseerimine, kiiruste piiramine ja jagamine;
• Tunnelid, PPP, VPN kliendi ja serveri seadistamine, võrkude ühendamine;
• RouterOS tööriistad, logimine, montitooring;
• Sertifikaadi eksam (inglise keeles).

Õppemeetodid: Auditoorne töö klassikeskkonnas 27 tundi (sh praktilised harjutused koolikeskkonnas 17 tundi)

Hindamiskriteerium: Õpiväljundite saavutamist kontrollitakse läbi praktiliste harjutuste koolikeskkonnas ning eksamiga koolituse lõpus.

Koolituse lõpetamine: Koolituse lõpetaja saab MTCNA sertifikaadi, kui läbib koolituse lõpus toimuva eksami (registreerimiseks eksamile palume esitada pildiga dokument). Sertifikaat kehtib 3 aastat. Osalejatele, kes eksamit ei tee ning seega õpiväljundeid saavutanud ei ole väljastatakse soovi korral tõend koolitusel osalemisest.

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

0612 Andmebaaside ja võrgu disain ning haldus.

Lektori CV

Kliendi tagasiside:

“Koolitus millel osalesin ületas ootusi. Oli palju sisutihedam kui ootasin ja koolitaja oli väga tasemel infot edasi andma. Organiseeritud olid päevad väga sujuvalt ja 3 päeva möödusid hetkega.”

Koolituse eesmärgiks on anda teadmised lokaalvõrgu- ja internetiteenuste liitmisest hallatud süsteemiks, võrguteenuste rakendamisest, logimisest ja turbe rakendamisest. Kursus toimub praktiliste harjutuste vormis, koolitatavad seadistavad oma virtuaalse arvutivõrgu. Kursus põhineb vabavaral ja võimaldab kirjeldatavaid lahendusi koheselt rakendada.

Programm:

• Internetivõrgud ja lokaalvõrgud, võrkude aadressiruumid. Võrkude eraldamise vajadus. Marsruutimine.
• Marsruuter ja kommutaator, VLANi mõiste. VLANide rakendamine võrgu organiseerimiseks
• Võimalused õigustepõhiseks ligipääsuks. Tulemüür Netfilter. Lokaalvõrgu lahendus läbi puhverserveri Squid.
• Vajadus eristada külaliste võrku ja asutuse lokaalvõrku. Võrguhaldussüsteem Packetfence. “Tule-oma-seadmega”, ehk BYOD, NAC.
• Kaugligipääs lokaalvõrgule. VPN. OpenVPN rakendamine kaugligipääsuks. OpenVPN-i piiramine tulemüüris.
• Perimeetriteenused: kohalik veebiserver, sFTP server, mailiserver. DMZ kontseptsioon. DMZ rakendamine tulemüüris, teenuste seadistamine.
• Logimise kontseptsioon, võrguliikluse vaatlemine. Sissejuhatus võrguturvalisusesse.
• IPv6 – mis muutub IPv6 rakendamisel? Teenuste valmidus IPv6-ks, turvalisuskaalutlused.

Sihtgrupp:

süsteemiadministraatorid, väike- ja suuremate võrkude hooldajad, huvilised. Osalemise eelduseks on algteadmised IP võrkudest ja algtasemel Linuxi tundmine.

Kursuse läbinu:

teab lokaalvõrgu ja marsruuditud võrgu erinevusi, tunneb tulemüüride ülesehituse printsiipe, oskab analüüsida erinevate võrguteenuste ja võrguklientide rolle, rakendada tulemüürireegelid vastavalt rollidele, eraldada võrke, organiseerida IP aadressruume, on saanud ülevaate IPv6 eripäradest, oskab kaaluda võrgu ja kliendi turvanõudeid teenuste ja rollide vaates.

Hinnas sisaldub:

• kohvipausid koolituskeskuses ja ühised lõunasöögid

Õppekavarühm: 0612 Andmebaaside ja võrgu disain ning haldus.

Lektori CV

Kliendi tagasisided:

„Põhjalik ja kvaliteetne koolitus oma ala professionaalilt.“

„Koolitus oli hästi korraldatud ning sisu läks kokku sellega mis oli kirjelduses mainitud“

Platform Engineering is critical in today’s tech landscape for enabling developer productivity, system resilience, and operational efficiency. This 2-day practical workshop covers key topics in platform engineering, including infrastructure as code, CI/CD pipelines, GitOps, Kubernetes, Crossplane, and automated deployment strategies. It’s designed for developers, DevOps engineers, and system administrators looking to build and manage robust platforms. The course includes hands-on exercises based on real-world scenarios, ensuring participants gain practical skills they can apply immediately. All participants will receive comprehensive materials, including cheat sheets, access to online slides, and code examples.

Who’s This For: developers, devops engineers, system administrators, software architects.

What’s Inside

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

Lecturer’s Linkedin

DevSecOps is the integration of security practices and principles into the DevOps process, with the aim of creating a more secure software development lifecycle. In this 2-day workshop, we will cover tips and tricks on how to increase security of software delivery supply chains and existing infrastructure.

What’s Inside

Day 1:

• Introduction to DevSecOps
  • Definition of DevSecOps; the role of security in DevOps
  • Introduction into threat modeling, attack surface, vulnerability and risk management
  • Overview of DevSecOps tools and practices
• Software supply chain security
  • Definition and importance of supply chain security
  • Supply chain elements: software packages/updates, CI/CD pipelines, external vendors, SaaS vendors
  • Software vendor management, compliance and regulatory requirements, incident response and recovery
  • Threats and risk management to supply chain security
  • Practical exercise: Conduct a supply chain risk assessment for a sample software product and develop a risk mitigation plan
  • Practical exercise: Develop an incident response plan for a supply chain security incident
• Software Bill of Materials (SBOM)
  • Definition and purpose of SBOM in supply chain security
  • Overview of SBOM formats (e.g. SPDX, CycloneDX)
  • SBOM generation tools (e.g. OWASP Dependency-Track)
  • Practical exercise: Generate an SBOM for a sample software product using a SBOM generation tool and analyze it to identify potential security risks.
• SIEM and log management
  • Introduction to security information and event management (SIEM)
  • SIEM components and architecture
  • Types of logs and log management
  • Log analysis and correlation
  • Real-time monitoring and alerting
  • Overview of popular SIEM tools (e.g. Splunk, ELK, LogRhythm)
  • Practical exercise: Install and configure a SIEM tool (ELK) and perform log analysis and correlation to identify potential security incidents.
• Container and Orchestrator Security
  • Overview of containers and containerization
  • Container security risks
  • Secure container deployment
  • Container orchestration security
  • Popular container security tools (e.g. Aqua, Sysdig, Twistlock)
  • Practical exercise: Build and deploy a containerized application using a secure container platform (e.g. Docker , Kubernetes) and apply container security best practices.

Day 2:

• Secret Management
  • Definition of secrets and their importance in security
  • Types of secrets (e.g. passwords, API keys, certificates)
  • Best practices for secret management (e.g. encryption, rotation, access control)
  • Secret management tools (e.g. HashiCorp Vault, AWS Secrets Manager)
  • Integration of secret management in CI/CD pipelines
  • Practical exercise: Implement a simple secret management solution using a tool like HashiCorp Vault and integrate it into a CI/CD pipeline.
• Secure software development
  • Secure coding practices, secure software development lifecycle (SSDL) and threat modeling
  • Code scanners for security problems, integration of security scanners into CI/CD pipelines
  • Practical exercise: Develop a sample application and apply secure coding practices, perform threat modeling, and integrate security testing in a CI/CD pipeline.
• OWASP
  • Overview of the OWASP Top Ten security threats
  • A1: Injection flaws
  • A2: Broken authentication and session management
  • A3: Cross-site scripting (XSS)
  • A4: Security misconfigurations
  • A5: Insecure direct object references
  • A6: Cross-site request forgery (CSRF)
  • A7: Using components with known vulnerabilities
  • A8: Insufficient logging and monitoring
  • Other security risks
  • Practical exercise: Perform a hands-on assessment of a web application, identify and exploit at least one OWASP Top Ten vulnerability.

• Open-Source Security
  • Open-source software security risks
  • Vulnerability management in open-source software
  • Popular open-source security tools (e.g. OWASP Dependency-Check, SonarQube)
  • Practical exercise: Perform a hands-on assessment of an open-source software package using an open-source vulnerability scanner (e.g. OWASP Dependency-Check) and integrate static code analysis using an open-source tool (e.g. SonarQube).
• Version Control Security
  • Git commit signing and verification
  • Git permissions models
  • Practical exercise: Configure Git commit signing with GPG and sign and verify Git commits.

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

Lecturer’s Linkedin

This 3-day workshop focuses on solving challenges that organizations face when implementing DevOps initiatives. It introduces principles of DevOps and tools that help reach full automation of infrastructure provisioning and software delivery. Theoretical background as well as practical hands-on examples of tools like Ansible, Docker, AWS, Terraform, Kubernetes, Serverless and many others are given during this workshop.

Overview of the following tools will be given during the workshop:

• Bash|Capistrano|Sshoogr|Fabric
• Puppet|Chef
• VirtualBox
• Vagrant
• AWS EC2
• Jenkins
• Graphite
• LogStash
• Kibana/Grafana.

Coverage:

• Module 01: introduction to DevOps, infrastructure as code, immutable infrastructure, idempotence principle, delivery pipelines, GitOps
• Module 02: managing virtual/cloud resources with IaC, tooling overview, building first infrastructure configuration pipeline with Terraform
• Module 03: managing multi-cloud/multi-data-center resources with Terraform and Terraform modules
• Module 04: integrating with classic server provisioning tools like Ansible
• Module 05: dynamic inventories, network management, building complex infrastructure delivery pipelines, organizing team work
• Module 06: managing base machine images with Packer
• Module 07: introduction to containers and container management
• Module 08: building/publishing images, running containers with Docker
• Module 09: implementing complex use cases with Docker Compose
• Module 10: using Kubernetes to run container workloads
• Module 11: using Helm charts and Kubernetes operators
• Module 12: leveraging service mesh features with Linkerd
• Module 13: introduction to observability: logs, metrics, traces
• Module 14: configuring Prometheus jobs and exporters, creating Grafana data sources and dashboards
• Module 15: DevSecOps: integrating linters, security policy checkers, vulnerability scanners
• Module 16: leveraging managed FaaS: OpenFaaS, Kubeless and Serverless
• Module 17: implementing a chat bot for Slack for effective ChatOps
• Module 18: introduction to chaos engineering

Master the Scrum framework with the CSM program and acquire essential skills to excel as a ScrumMaster with the Advanced CSM program.

The ultimate ScrumMaster program contains two modules both ending with internationally recognized certifications – Certified ScrumMaster (CSM) and Advanced Certified ScrumMaster (A-CSM).

 If you’re ready to grow more agile and interested in becoming an expert in Scrum, The Ultimate ScrumMaster® program (CSM® + A-CSM®) is designed for you. You’ll learn the Scrum framework and gain a full understanding of team accountabilities, events, and artifacts as well as how to guide your team to apply Scrum.

Considered the gold standard of certification, the Scrum Alliance CSM + A-CSM course is an interactive and engaging learning experience. Taught by our passionate trainers with rich hands-on experience from the coaching trenches, our class is an excellent learning opportunity to help students start and boost their learning journey towards Agile and Scrum.

Whether you want to serve as a ScrumMaster, are adopting Scrum, or just need the tools to be more agile, our The Ultimate ScrumMaster® program is the right place to start. You’ll gain a solid understanding of Scrum and learn practical ways to apply it to your team and throughout your organization.

Our workshops give you hands-on skills that you can immediately apply in the real world and expand your career opportunities. Once you complete the course, you will have everything you need and more, to take and pass the CSM exam.

Scrum is applicable across industries and potentially cross-functional teams, so in addition to product development professionals, marketers, data scientists, HR representatives, and other professionals looking for a better way to solve complex problems are encouraged to attend.

The training will be beneficial to:

• ScrumMasters or ScrumMaster candidates
• Developers, testers, analysts, designers, and all members of product development teams
• Managers, and support staff who want to understand Scrum framework and ScrumMaster role through an in-depth hands-on workshop
• Anybody who wants to build an in-depth introduction to Agile and Scrum.

MODULE 1 – Certified ScrumMaster (CSM) 15 – 16.12.2025

Course Content

• What exactly is Agile?
  • Agile value. principles and mindset
  • Relationship between Agile and Scrum

• Product Backlog
  • Product goal
  • Product backlog and its characteristics 
  • Product backlog item (PBI) and its characteristics 
  • User Story concept and writing exercises 
  • Product Backlog refinement: a powerful vehicle for interactive and incremental development 

• Scrum Framework Overview 
  • Three accountabilities in Scrum 
  • Great anatomy of great ScrumMaster, Product Owner and Scrum Team
  • Scrum events in a nutshell
    • Everything in a Sprint
    • Sprint Planning: set the goal for the sprint
    • Sprint backlog and its characteristics
    • Sprint goal
    • Daily Scrum to inspect and adapt
    • The Sprint Review: valuable feedback and collaboration with stakeholders
    • Sprint Retrospective for continuous improvements
  • Different scenarios during the sprint

• Increment and its characteristics
  • Definition of Done (DoD)

• Experience Scrum framework
  • Using Scrum framework to build our in-class product

• Agile estimation and release planning
• Working with multiple teams
• ScrumMaster’s competence
  • Services to Product Owner, Development Team and Organization 
  • Introduction to Agile facilitation and Agile coaching 

• Next steps to be a great ScrumMaster 

What are the benefits of a Certified ScrumMaster® (CSM) certification? 

By earning a Certified ScrumMaster® certification you:

• Expand your career opportunities by staying relevant and marketable across all industry sectors by adopting Agile practices
• Demonstrate to employers and peers your attainment of core Scrum knowledge
• Learn the foundation of Scrum and the scope of the Certified ScrumMaster’s role from the best minds in Scrum
• Engage with a community of recognized Scrum experts who are committed to continuous improvement

As a CSM, you will be able to excel at work as a ScrumMaster or a Scrum team member. Through the certification workshop, you will gain an in-depth understanding of the Scrum framework, including roles, activities, and artifacts, and experience Scrum framework during the workshop. 

With your CSM certification, you will also have access to a 2-year membership with Scrum Alliance. Through this membership, you can join local user groups, and online social networks, gain access to deep discounts on gatherings, and additional member-only resources. In addition, CSMs can use a specially designed logo to highlight their credentials. 

About the exam 

Upon completion of the CSM workshop, you can take the online exam at any time at any location convenient to you, as long as there is a good internet connection. Once you start the exam, you have 60 minutes to complete 50 questions which are multiple choice questions. You will know the result immediately, and you need to have more than 37 questions answered correctly. 

If for any reason you didn’t pass the exam, you are most invited to reach out to us to schedule an individual session or a re-take of the CSM workshop, free of charge. However, we have not had students who need to use this option yet. But it is always an option available if needed. There are two free attempts with the CSM workshop you take with us. 

MODULE 2 – Advanced Certified ScrumMaster (A-CSM) 09 – 10.04.2026

Course Content

Coaching Concepts

• Coaching stances
• Key coaching skills and their application
• Tactics of coaching at the individual, Scrum Team and organization level
• Agile coaching
  • Agile Facilitation
    • Divergent and Convergent Thinking
    • Facilitation techniques to navigate through the Groan Zone and Divergent and Convergent phases
    • Decision making
  • A deeper dive into Lean, Agile, Scrum and Kanban
    • Flow efficiency
    • Further enhancement of Scrum
    • Kanban in a nutshell for organization improvement
  • Services to developers
    • Self-Organization and Team Dynamics
    • Key attributes of effective teams
    • Coaching for high-performing teams
    • Agile engineering practices
  • Services to Product Owner
    • The services around Product Vision and Strategy
    • The mindset and tools for a fantastic product
    • Tools to bring customer needs into Product Backlog
    • Product Backlog Refinement tactics
    • The collaboration and its enhancement with the Development Team
  • Services to Organization
    • Impediment Removal and its tactics & strategies
    • Leadership team coaching
    • Agile scaling approaches and principles
    • Introducing new ideas
    • Tactics for organizational improvements
  • Personal Development
    • Coaching practices for personal growth actions
    • Pivotal conversation
    • The art of giving feedback
    • How to work with conflicts
    • ScrumMaster as Servant Leader

What are the benefits of an Advanced Certified ScrumMaster® certification?

By earning an Advanced Certified ScrumMaster® certification you:

• Build on your foundational knowledge with enhanced implementation skills.
• Distinguish yourself in the global marketplace.
• Stand out in your industry as an advanced member of the globally recognized Scrum Alliance community.
• Show advanced value to your employer (or potential employer) as a highly trained Agile professional.

Assessment method:
The achievement of learning outcomes is assessed on the basis of feedback-based practical exercises carried out during the training.

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.

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

Lecturer’s LinkedIn

Cultivate vital skills in agile product ownership through Scrum practices via the CSPO program, and elevate agile product ownership through advanced product discovery, strategy and roadmap, product prioritisation, stakeholder management and more via the Advanced CSPO program.

The Ultimate Agile Product Ownership program contains two modules both ending with the unique separate certification.

Product owners have a unique and demanding role on agile teams.

A product owner decides what the team will create next to deliver more value to the customer. In The Ultimate Agile Product Ownership program (CSPO® + A-CSPO® ) class, you’ll learn the framework, principles, and values that make scrum work, plus key skills and tools you need to be effective.

You will discover how to juggle multiple stakeholders’ needs, get hands-on practice creating a product vision, and learn new ways to get to know your customers so that you can choose the right next piece of value to bring to market for them.

What are the benefits of The Ultimate Agile Product Ownership program?

By earning a Certified ScrumMaster® certification you:

• Learn the foundation of Scrum and the scope of the Certified Scrum Product Owner’s role from the best minds in Scrum.
• Demonstrate to employers and peers your attainment of core Scrum knowledge.
• Expand your career opportunities by staying relevant and marketable across all industry sectors adopting Agile practices.
• Engage with a community of recognized Scrum experts who are committed to continuous improvement.

As a CSPO, you will be able to fulfil the role of Product Owner on a Scrum team. You will also have access to a 2-year membership with Scrum Alliance. Through this membership, you can join local user groups, and online social networks, and gain access to deep discounts on gatherings, and additional member-only resources. In addition, CSPOs can use a specially designed logo to highlight their credentials.

Who should take the course?

Anyone who enjoys (or wants to become more familiar with) the business side of projects can benefit from participating in The Ultimate Agile Product Ownership program (CSPO + A-CSPO).

CSPOs decide what the team will create, ordering the work to ensure that the most valuable, impactful products reach customers at a regular cadence.

The training will be beneficial to:

• Product owners or product owner candidates;
• Product and portfolio managers;
• Business representatives;
• Business experts;
• Executives, managers, and support staff who are interested in improving product development through an in-depth hands-on workshop;
• Anyone curious about how to enhance products;

MODULE 1 – Certified Scrum Product Owner (CSPO) 09 – 10.12.2025

Course content: 

• Understanding Customers and Users
  • Why product discovery
  • Segmenting customers and users
  • Creating a shared understanding of customer needs
  • Prioritizing conflicting customers’ needs
  • Persona concepts and application
• Validating Product Assumptions
  • How to validate within Scrum Framework
  • Validation methods and selection
• Product Purpose and Strategy
  • Create and describe Product Vision
  • Product Strategy
  • Roadmap and Release planning
• Prioritization
  • Define and measure the value for products
  • Models and techniques for prioritizing product features
• Product Backlog and Product Goal
  • Product backlog and its characteristics
  • Product Backlog Item (PBI) and its characteristics
  • User Stories
  • Product Backlog Refinement – a powerful vehicle
    • when, why and how
    • Methods for slicing larger needs into smaller product backlog items
• Scrum Framework Introduction
  • Scrum framework overview
  • How to benefit from Scrum framework to build a fantastic product
  • Agile estimation and release planning
• Summary of Product Ownership
  • Core competencies of a product owner
  • Key benefits of Product Ownership
  • Differentiating outcome and output
  • Collaboration with stakeholders
  • Collaboration with developers
  • Working with multiple Scrum teams
• Next steps to be a great Product Owner

MODULE 2 – Advanced Certified Scrum Product Owner (A-CSPO) 09 – 10.03.2026

As a Certified Scrum Product Owner® (CSPO®), you’ve been taught the Scrum terminology, ceremonies, and principles that enable you to fulfil the role of Product Owner on a Scrum team. You’re focused on maximizing business value and prioritization and understand how to do the best possible job to satisfy key stakeholders. One of your priorities should be your own success! Becoming Agile is a lifelong journey and incorporating Scrum values and Agile principles into your world of work takes diligence, patience, and a commitment to continuous improvement.

Now, to further enhance your knowledge and skills, the next step is achieving an Advanced Certified Scrum Product Owner™ (A-CSPO™) certification from Scrum Alliance®.

All attendees of this module must have the Certified Scrum Product Owner certification (CSPO) and some practice prior to this workshop.

Course content:

• Product Essentials
  • Product basics
  • Product life cycle concept and corresponding strategy
• Empathizing Customers and Users
  • Perform customer research
  • Interview and tips for an insightful interview
• Advanced Product Assumption Validation
  • Cognitive biases and their impacts on product
  • Hypothesis Driven Development (HDD)
  • Compare different HDD approaches
  • Incorporating HdD into Scrum framework
  • Develop HDD and design validation plans
• Advanced Purpose and Strategy
  • Developing product vision and strategies
  • Advanced road mapping and its development
  • Advanced product planning and forecasting
  • Release planning
• Advanced Product Backlog Management
  • Model and measure the value for a product
  • Advanced Product Backlog Ordering
  • Linking Product Backlog Ordering to product Strategy
  • Enhancement of slicing user story techniques
• Product Owner Core Competencies
  • Skills, capabilities, and practices of a Product Owner
  • A mindset of a Product Owner
    • Maximizing outcome and minimizing output
  • Facilitation skills of a Product Owner
  • Advanced stakeholder collaboration
    • Identify stakeholders and key stakeholder groups
    • Stakeholder management techniques
    • Collaboration methods and decision-making with stakeholders
  • Advanced Development Team collaboration
    • Define technical debts
    • Technical practices to help improve quality and ways of working
    • Practice value maximization per sprint
  • Collaboration with multiple development
    • Recognize scaling manifestos
    • List scaling frameworks
    • Working with dependencies

• Next steps for product owners

As a Product Owner, you know there are rarely enough hours in the day to do what really matters — building great products for your customers and end users. With our new role-specific educational program, you’ll learn specific tools and techniques so you can truly deliver the business value that matters. You’ll gain new skills and deepen your knowledge in these areas, and most importantly, you’ll learn how to say “yes” to your career by saying “no.”

Assessment method:
The achievement of learning outcomes is assessed on the basis of feedback-based practical exercises carried out during the training.

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.

Õppekavarühm: 0413 Juhtimine ja haldus

Lecturer’s LinkedIn

See neljapäevane kursus annab õpilastele teadmised ja oskused Microsoft SQL Server 2022 andmebaasi haldamiseks. Kursus keskendub SQL Server 2022 tootefunktsioonide ja andmebaasi haldamisega seotud tööriistade kasutamise õpetamisele. Antud kursus sobib ka  neile, kes on huvitatud SQL Serveri vanemate versioonide õppimisest alates aastast 2014. Kursus hõlmab SQL Server 2022 uusi funktsioone, aga ka SQL Serveri andmeplatvormi olulisi võimalusi.

Kursus on välja töötatud Microsofti ametliku „pärandkursuse/ legacy course“ (MOC#20462) põhjal.

Antud kursusega ei ole seotud ühtegi ametlikku Microsofti eksamit ega sertifikaati. Koolituse läbinud saavad BCS-i tunnistuse.

Eeltingimused:

• Põhiteadmised Microsoft Windowsi operatsioonisüsteemist ja selle põhifunktsioonidest
• Tööalased teadmised Transact-SQL-ist
• Relatsiooniliste andmebaaside tööalased teadmised
• Mõned kogemused andmebaasi kujundamisega
• Varasemad programmeerimisoskused pole vajalikud

Programm:

Moodul 1: sissejuhatus SQL Server 2022 andmebaasi administreerimisse

Moodul 2: SQL Server 2022 installimine ja konfigureerimine

Moodul 3: töö andmebaaside ja salvestusruumiga

Moodul 4: Varundusstrateegia kavandamine ja rakendamine

Moodul 5: SQL Server 2022 andmebaaside taastamine

Moodul 6: Andmete importimine ja eksportimine

Moodul 7: SQL Server 2022 monitoorimine

Moodul 8: SQL serveri tegevuse jälgimine

Moodul 9: SQL serveri turvalisuse haldamine

Moodul 10: Andmetele juurdepääsu kontrollimine ja andmete krüpteerimine

Moodul 11: andmebaasi igapäevane hooldus

Moodul 12: SQL Server 2022 halduse automatiseerimine

Moodul 13: SQL Server 2022 jälgimine teatiste abil (alerts and notifications)

Õppemeetodid: Praktiline harjutus.

Hindamismeetodid: Iseseisvate tööde tegemine koolituse käigus.

Hindamisvorm: Praktilised ülesanded asjakohastel teemadel.

Hind sisaldab: 

• Kohvipausid ja lõunasöök
• Tasuta 1 vabalt valitud Microsofti sertifitseerimiseksam 6 kuu jooksul pärast kursuse lõpetamist

Lecturer’s Linkedin

Kliendi tagasiside:

“Väga hea koolitus. Koolitaja oli oma ala tegija ja oskas rääkida  arusaadavalt ja tuua näiteid ka väljaspoolt koolitusmaterjale.”

Koolituse eesmärk: Läbi kolme erineva mooduli õpivad osalejad põhjalikult kasutama Linuxi operatsioonisüsteemi ja rakendama selle peamisi teenuseid, ressursse ning seadistusmetoodikaid.

Sihtrühm ja eelteadmised: Koolitusele on oodatud kõik, kes soovivad täiendada teadmisi operatsioonisüsteemidest, omandada võimekust Linuxi seadistamiseks ja on tuttavad operatsioonisüsteemide kasutamisega. Samuti need, kes soovivad alustada karjääri IT-spetsialistina  ja omavad algtasemel Linuxi kasutamiskogemust.

Õppevahendid: Linuxi operatsioonisüsteemil toimiv arvuti

Programm:

Moodul 1 (25.02 – 27.02.2026)

• Linux kui operatsioonisüsteem, Linuxi ajalugu, distributsioonid;
• installeerimine: kõik vajalik installeerimiseks: kettavormingud, kettajaotiste tegemine, baaskomplekt tarkvarast;
• vahendid: lisainfo allikad, töö käsureal, kest (shell), skriptid, utiliidid, konfigureerimisvahendid;
• tarkvara installeerimine, uuendamine: DEB, RPM ja tar paketid, repositooriumid, turvauuendused
• kasutajate haldamine: kasutaja mõiste, kasutajate loomine, keskkonna konfigureerimine, eriprivileegide jagamine, PAM autentimismoodulid;
• algkäivitusprotseduur: grub. SysV-init ja systemd. käivitumisskriptid, töötasemed;
• failisüsteemide haldamine: failisüsteemi ehitus, viidad, pääsuõigused, uue failisüsteemi loomine, monteerimine (mount), kontroll, kvootide määramine;
• protsesside haldamine: ülevaate saamine, protsesside tapmine, prioriteedid, cron ja at teenus;
• logimise konfigureerimine ja jälgimine;
• varundamine;

Moodul 2 (23.03 – 25.03.2026)

• Linuxipõhine taristu;
• läbiproovitud ja turvaline füüsiline kiht – tarkvaraline RAID, dünaamiline partitsioneerimine LVM abil;
• uus ja põnev füüsilisel kihil – failisüsteemid BTRFS ja ZFS;
• võrk virtualiseerimiskeskkonnas – sillaga või maskeerimisega;
• kernelipõhine virtualiseerimine QEMU / KVM, käsurida, graafilised vahendid, QEMU failiformaadid;
• füüsilisest virtuaalseks: LXC konteinerid, konteinerite manipuleerimine;
• Diskless-töökohtadega tsentraalselt hallatav võrk LTSP;
• tsentraalsed konfiguratsioonihaldussüsteemid – Chef, Puppet, Ansible.
• praktiline serveriseadistamine Puppeti abil

Moodul 3 (20.04 – 22.04.2026)

• võrgu seadistamine;
• DHCP teenuse seadistamine (ISC DHCP server, dnsmasq);
• domeenikontrolleri seadistamine (Samba)
• Failiserveri seadistamine (NFS, SMB)
• Võrgust alglaadimine (PXE, LTSP)
• Veebiserveri konfimine (Apache, Nginx veebiserver)
• PAM autentimismoodulid, LDAP autentimine
• E-postiteenuse seadistamine (Postfix/ Dovecot)
• Marsruutimise seadistamine, tulemüür
• Secure Shell seadistamine, avaliku võtmega autentimine
• Kaugligipääsud – OpenVPN, IPsec
• Esmane turvaskaneerimine ja ründetõrje (nmap, fail2ban)
• Skriptimine – Bash
• Tarkvara paigaldamine lähtekoodist

Turvaküsimusi käsitletakse jooksvalt iga teema juures.

Koolitus on loodud LPI ametliku programmi põhjal.

Õppemeetodid: Auditoorne töö klassi- või veebikeskkonnas 72 tundi (sh praktilised harjutused koolikeskkonnas 45 tundi)

Hindamismeetod: Praktiliste tööde sooritamine klassis

Hindamiskriteerium: Õpiväljundite saavutamist kontrollitakse läbi praktiliste harjutuste koolikeskkonnas

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

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

Õppekavarühm: 0612 Andmebaaside ja võrgu disain ning haldus.

Kliendi tagasiside:

Kliendi tagasiside:

“Tänan BCS!  Korralduse ja koolituse kvaliteet on väga kõrgel tasemel. Kursuse sisu oli mahukas ja hea. On hea meel, et on olemas koolituse materjalid ja saan kordamisel vaadata. Koolituse päevakava ja selle käsitlemine on tipptase ja hästi tehtud. Kursuse moodulite sisu on hea, mis on läbi põimitud harjutustega. See tõepoolest annab hea aluse algteadmistele ja hiljem süvenenud teadmiste õppimisele. Selline õpivorm sobis mulle väga koos praktiliste harjutustega. Koolitaja kohta on lisada ainult kiidusõnad.”

Koolituse eesmärk: Osalejad saavad  teadmised Linuxi /systemd rakendamisest virtualiseerimise vaatenurgast. Samuti esmased teadmised konfiguratsioonihaldusvahenditest (kasutajate/tarkvara tsentraalne haldus).

Sihtrühm ja eelteadmised: Koolitusele on oodatud linuxi kasutajaoskustega süsteemiadministraatorid, kelle tööülesannetele on lisandunud virtualiseerimine ja platvormihaldus. Samuti on oodatud need, kes eelnevalt läbinud kursused “Linux põhikursus” ja “Linux edasijõudnutele”

Õppevahendid: Linuxi operatsioonisüsteemil toimiv arvuti

Programm:

• Linuxipõhine taristu; 
• läbiproovitud ja turvaline füüsiline kiht – tarkvaraline RAID, dünaamiline partitsioneerimine LVM abil; 
• uus ja põnev füüsilisel kihil – failisüsteemid BTRFS ja ZFS; 
• võrk virtualiseerimiskeskkonnas – sillaga või maskeerimisega; 
• kernelipõhine virtualiseerimine QEMU / KVM, käsurida, graafilised vahendid, QEMU failiformaadid; 
• füüsilisest virtuaalseks: LXC konteinerid, konteinerite manipuleerimine; 
• Diskless-töökohtadega tsentraalselt hallatav võrk LTSP; 
• tsentraalsed konfiguratsioonihaldussüsteemid – Chef, Puppet, Ansible;
• praktiline serveriseadistamine Puppeti abil

Turvaküsimusi käsitletakse jooksvalt iga teema juures.

Kursusel õpitav on toeks eksamitel: LPIC-2 201, LPIC-3 300 ja 304

Õppemeetodid: Auditoorne töö klassi- või veebikeskkonnas 24 tundi (sh praktilised harjutused koolikeskkonnas 15 tundi)
Hindamismeetod:Praktiliste tööde sooritamine klassis
Hindamiskriteerium: Õpiväljundite saavutamist kontrollitakse läbi praktiliste harjutuste koolikeskkonnas

Koolituse lõpetamine: Koolituse lõpetaja saab tunnistuse kui sooritab kõik koolituse jooksul antud praktilised harjutused.

Hind sisaldab: 

• Kohvipause koolituskeskuses ja ühiseid lõunasööke 

Õppekavarühm: 0612 Andmebaaside ja võrgu disain ning haldus.

Lektori CV

Kliendi tagasiside:

„Koolitaja oskas vastata kõigile küsimustele ja aidata lahendada probleeme, mis tallegi paistsid esmakordsed olevat. Ülikõva!“