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.

Tööandjal on võimalik taotleda töötukassa toetust töötaja koolitamiseks 80% ulatuses. Loe lähemalt siit

Õppevahendid: Linuxi operatsioonisüsteemil toimiv arvuti

Programm:

Moodul 1 (08.03 – 10.03.2027)

• 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 (05.04 – 07.04.2027)

• 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

Moodul 3 (10.05 – 12.05.2027)

• 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 (ka tehisaru AI mõju) 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!“

Koolituse eesmärk: Osalejad saavad teadmised Linuxi teenustest, ressursijuhtimisest, seadistusmetoodikatest.  

Sihtrühm ja eelteadmised:Koolitusele on oodatud süsteemiadministraatorid, kelle tööülesannetele on lisandunud või lisandumas Linuxi serverite teenuste paigaldus ja haldus. Samuti on oodatud need, kes eelnevalt läbinud kursused Linuxi administreerimise algkursus 1 ja 2. 

Õppevahendid: Linuxi operatsioonisüsteemil toimiv arvuti

Programm:

• 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

Kursusel käsitletu on abiks eksamiks LPIC-2 202 valmistumisel (https://www.lpi.org/study-resources/lpic-2-202-exam-objectives/)

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

Lektori CV

Kliendi tagasisided:

„Koolitus kus osalesin oli hea lühike kuid sellegipoolest sai piisavalt praktilist kogemust.“

„Palju kasulikku ja huvitavat, asjalik koolitaja ja hea korraldus“

„Väga hea koolitus, annab palju praktilist teadmist.“

Power BI 3-day training introduces a powerful tool to help you make information-based decisions. Using Power BI data can be collected, organized, and merged into a data model. Also, it can be visualized and shared with company employees or the public web. The training also includes a practical workshop on the final day.

NEW! To meet the needs and expectations of our customers even better we have made the DAX functions, filtering options and bookmarks course part even more detailed – and all of that for better data analysis.

Target group and previous knowledge: The training is intended for anyone who wishes to acquire basic skills in using Power BI as a data analysis tool.
Participants should have experience using Microsoft Excel: they should understand data types; create and format basic tables; use basic functions (addition, subtraction, averages, etc.); and create charts to illustrate table data.

Learning tools: Computer with Windows operating system and Power BI Desktop app.

Programme:
Creating queries with Power Query

• Importing data from different sources
  • From the web
  • From the database
  • From text files
  • From Excel spreadsheets
  • From Facebook, Outlook…
• Joining tables
  • Merging tables
  • Taking data from a secondary table, i.e. linking tables
• Organizing data
  • Filtering and sorting
  • Setting headers
  • Joining and splitting columns
  • Defining data types
  • Making a standard table from Pivot table
  • Adding columns with calculations
• Updating and editing queries
• Functions in queries (“M”-functions)
  • Conditional sentences
  • Format conversion functionsTime functions
  • Text functions
  • Statistical functions

Visualize data on the Dashboard using Power BI Desktop

• Application installation
• Working environment
• Creating a data model
• Key performance indicators (KPIs)
  • Calculation of key figures and summaries
  • Calculating new measures with DAX functions – Even more thorough!
  • Tables and matrices
• Charts
  • Dynamic bar, line, pie charts
  • Geographic location charts
  • Set the location type
  • Points on the map
  • Regions
• Tables and matrices
• Filtering options – Even more thorough!
  • Slicers
  • Visual, page and report filters
  • Drill and its settings
• Importing custom visuals (new charts, images…)
• Design of visualization objects
  • Fonts, colours, adding and removing objects in graphics
  • Setting the scales
  • Adding dynamic lines
• Desktop sharing options
• Practical examples of Power BI solutions

Teaching methods: Participants can attend the training in the classroom or join online via Zoom. The total duration of the training is 24 hours, including 15 hours of practical exercises in the training environment.

Assessment method: practical exercise, independent work.

Assessment criteria: the achievement of learning outcomes is checked through independent practical work.

Graduation and certifications issued: The graduate of the training gets a certificate after completing all the independent 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.

Price includes: Coffee breaks at the training centre.

Curriculium group: 0611 Computer use.

The workshop gives you an opportunity to consolidate the knowledge and skills acquired during the MS Excel Advanced course by completing a variety of practical exercises at your own pace.
Each exercise includes sample files and instructions, and an experienced professional will be available in the classroom to provide guidance and assistance.
During the workshop, participants will gain access to sample files that can help them find solutions in future practical situations.

Target group and prerequisites: The training is intended for everyone who has already completed the MS Excel Advanced course, as well as those who have not yet attended the course but would like to independently find solutions to advanced-level MS Excel exercises.

Learning resources: Participants use their own computers during the workshop. Please let us know if you would like to use one of our computers.

Programme:
Topics covered in the exercises:

Creating tables

• Labelling worksheets
• Creating formulas using data from different worksheets
• Using absolute and relative references in formulas
• Creating text formulas
• Using functions (conditional, statistical and lookup functions)
• Setting restrictions for data entry (Data Validation)
• Advanced table formatting (Format Cells)
• Using Conditional Formatting
• Creating charts from different worksheets
• Using Goal Seek
• Protecting data

Analysing tables

• Freezing rows and columns
• Printing a large table
• Splitting and merging columns
• Sorting
• Filtering
• Subtotals
• Creating and modifying a PivotTable (from an Excel table)

Teaching methods: Classroom or online learning: 4 hours (including 4 hours of practical exercises in the learning environment).

Assessment method: Self-assessment.

Assessment criteria: Achievement of the learning outcomes is not assessed.

Completion of the training: Upon request, participants who complete the workshop will receive a certificate of attendance.

The price includes: Coffee breaks at the training centre.

Training objective: Upon completion of the training, the learner will be able to apply advanced MS Excel techniques and artificial intelligence capabilities to data analysis and the improvement of everyday work processes.
The training takes place in a classroom or online, where each learner has access to the Microsoft 365 environment.
Participants with a paid Microsoft 365 Copilot licence can actively complete the topics during the training. Participants without the relevant licence can follow the techniques demonstrated by the instructor.
The training does not include a paid licence.

Target group and prerequisites: The training is intended for people who use MS Excel in their daily work and wish to improve their knowledge and skills in data processing, analysis, and automation using MS Excel’s advanced features and AI tools.

Participants with a paid Microsoft 365 Copilot licence can actively complete the topics during the training. Participants without a licence can follow the techniques demonstrated by the instructor. The training does not include a paid licence.

Learning resources: A computer running the Windows operating system. Participants may use their own personal computer if they wish.

Programme: MS Copilot tools are used throughout the training to improve Excel workflows, analyse data, and automate tasks.

Topics covered during the training:
MS Excel formulas and functions

• formulas using data from different worksheets;
• absolute and relative cell references in formulas;
• text formulas;
• using functions: IF, SUMIF, AVERAGE, ROUND, VLOOKUP, TODAY, etc.;
• using Copilot to generate formulas and identify errors.

Formatting tables and visualising data

• advanced table formatting (Format Cells);
• copying formatting;
• conditional formatting (Conditional Formatting);
• creating charts from data located on different worksheets;
• using Copilot to create charts and visualisation ideas.

Data management

• setting restrictions on data entry (Data Validation);
• goal-oriented search (Goal Seek);
• protecting a file, worksheet, and table;
• Copilot recommendations for data management.

Table analysis

• freezing rows and columns;
• splitting and merging columns;
• sorting and filtering;
• subtotals;
• creating and modifying a PivotTable;
• using Copilot to interpret data analysis.

All participants who complete the training may, if they wish, attend an additional practical workshop day free of charge – WORKSHOP: Advanced MS Excel. See dates on the website www.bcskoolitus.ee

Learning methods: Participants can attend in the classroom or join the training via Zoom. The training comprises 16 hours, including 12 hours of practical exercises in the training environment.

Assessment method: Practical work in MS Excel and the use of Copilot tools to complete an assignment.

Assessment criteria:
The learner:

• uses Excel functions and formulas correctly;
• creates and formats a table;
• uses data analysis techniques;
• applies Copilot tools purposefully when completing the assignment;
• interprets the analysis results.

Completion requirements: A participant receives a certificate of achievement upon completing all practical exercises assigned during the training. Participants who have not achieved the learning outcomes may, upon request, receive a certificate of attendance.

The price includes: shared lunches and coffee breaks (lunch is not included on half-days)

For further training, we recommend: Power BI Basics Course.

Curriculium group: 0611 Computer use.

Power BI 3-day training introduces a powerful tool to help you make information-based decisions. Using Power BI data can be collected, organized, and merged into a data model. Also, it can be visualized and shared with company employees or the public web. The training also includes a practical workshop on the final day.

NEW! To meet the needs and expectations of our customers even better we have made the DAX functions, filtering options and bookmarks course part even more detailed – and all of that for better data analysis.

Target group and previous knowledge: The training is intended for anyone who wishes to acquire basic skills in using Power BI as a data analysis tool.
Participants should have experience using Microsoft Excel: they should understand data types; create and format basic tables; use basic functions (addition, subtraction, averages, etc.); and create charts to illustrate table data.

Learning tools: Computer with Windows operating system and Power BI Desktop app.

Programme:
Creating queries with Power Query

• Importing data from different sources
  • From the web
  • From the database
  • From text files
  • From Excel spreadsheets
  • From Facebook, Outlook…
• Joining tables
  • Merging tables
  • Taking data from a secondary table, i.e. linking tables
• Organizing data
  • Filtering and sorting
  • Setting headers
  • Joining and splitting columns
  • Defining data types
  • Making a standard table from Pivot table
  • Adding columns with calculations
• Updating and editing queries
• Functions in queries (“M”-functions)
  • Conditional sentences
  • Format conversion functionsTime functions
  • Text functions
  • Statistical functions

Visualize data on the Dashboard using Power BI Desktop

• Application installation
• Working environment
• Creating a data model
• Key performance indicators (KPIs)
  • Calculation of key figures and summaries
  • Calculating new measures with DAX functions – Even more thorough!
  • Tables and matrices
• Charts
  • Dynamic bar, line, pie charts
  • Geographic location charts
  • Set the location type
  • Points on the map
  • Regions
• Tables and matrices
• Filtering options – Even more thorough!
  • Slicers
  • Visual, page and report filters
  • Drill and its settings
• Importing custom visuals (new charts, images…)
• Design of visualization objects
  • Fonts, colours, adding and removing objects in graphics
  • Setting the scales
  • Adding dynamic lines
• Desktop sharing options
• Practical examples of Power BI solutions

Teaching methods: Participants can attend the training in the classroom or join online via Zoom. The total duration of the training is 24 hours, including 15 hours of practical exercises in the training environment.

Assessment method: practical exercise, independent work.

Assessment criteria: the achievement of learning outcomes is checked through independent practical work.

Graduation and certifications issued: The graduate of the training gets a certificate after completing all the independent 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.

Price includes: Coffee breaks at the training centre.

Curriculium group: 0611 Computer use.

Training objective: Upon completion of the training, the learner will be able to apply advanced MS Excel techniques and artificial intelligence capabilities to data analysis and the improvement of everyday work processes.
The training takes place in a classroom or online, where each learner has access to the Microsoft 365 environment.
Participants with a paid Microsoft 365 Copilot licence can actively complete the topics during the training. Participants without the relevant licence can follow the techniques demonstrated by the instructor.
The training does not include a paid licence.

Target group and prerequisites: The training is intended for people who use MS Excel in their daily work and wish to improve their knowledge and skills in data processing, analysis, and automation using MS Excel’s advanced features and AI tools.

Participants with a paid Microsoft 365 Copilot licence can actively complete the topics during the training. Participants without a licence can follow the techniques demonstrated by the instructor. The training does not include a paid licence.

Learning resources: A computer running the Windows operating system. Participants may use their own personal computer if they wish.

Programme: MS Copilot tools are used throughout the training to improve Excel workflows, analyse data, and automate tasks.

Topics covered during the training:
MS Excel formulas and functions

• formulas using data from different worksheets;
• absolute and relative cell references in formulas;
• text formulas;
• using functions: IF, SUMIF, AVERAGE, ROUND, VLOOKUP, TODAY, etc.;
• using Copilot to generate formulas and identify errors.

Formatting tables and visualising data

• advanced table formatting (Format Cells);
• copying formatting;
• conditional formatting (Conditional Formatting);
• creating charts from data located on different worksheets;
• using Copilot to create charts and visualisation ideas.

Data management

• setting restrictions on data entry (Data Validation);
• goal-oriented search (Goal Seek);
• protecting a file, worksheet, and table;
• Copilot recommendations for data management.

Table analysis

• freezing rows and columns;
• splitting and merging columns;
• sorting and filtering;
• subtotals;
• creating and modifying a PivotTable;
• using Copilot to interpret data analysis.

All participants who complete the training may, if they wish, attend an additional practical workshop day free of charge – WORKSHOP: Advanced MS Excel. See dates on the website www.bcskoolitus.ee

Learning methods: Participants can attend in the classroom or join the training via Zoom. The training comprises 16 hours, including 12 hours of practical exercises in the training environment.

Assessment method: Practical work in MS Excel and the use of Copilot tools to complete an assignment.

Assessment criteria:
The learner:

• uses Excel functions and formulas correctly;
• creates and formats a table;
• uses data analysis techniques;
• applies Copilot tools purposefully when completing the assignment;
• interprets the analysis results.

Completion requirements: A participant receives a certificate of achievement upon completing all practical exercises assigned during the training. Participants who have not achieved the learning outcomes may, upon request, receive a certificate of attendance.

The price includes: shared lunches and coffee breaks (lunch is not included on half-days)

For further training, we recommend: Power BI Basics Course.

Curriculium group: 0611 Computer use.

The workshop gives you an opportunity to consolidate the knowledge and skills acquired during the MS Excel Advanced course by completing a variety of practical exercises at your own pace.
Each exercise includes sample files and instructions, and an experienced professional will be available in the classroom to provide guidance and assistance.
During the workshop, participants will gain access to sample files that can help them find solutions in future practical situations.

Target group and prerequisites: The training is intended for everyone who has already completed the MS Excel Advanced course, as well as those who have not yet attended the course but would like to independently find solutions to advanced-level MS Excel exercises.

Learning resources: Participants use their own computers during the workshop. Please let us know if you would like to use one of our computers.

Programme:
Topics covered in the exercises:

Creating tables

• Labelling worksheets
• Creating formulas using data from different worksheets
• Using absolute and relative references in formulas
• Creating text formulas
• Using functions (conditional, statistical and lookup functions)
• Setting restrictions for data entry (Data Validation)
• Advanced table formatting (Format Cells)
• Using Conditional Formatting
• Creating charts from different worksheets
• Using Goal Seek
• Protecting data

Analysing tables

• Freezing rows and columns
• Printing a large table
• Splitting and merging columns
• Sorting
• Filtering
• Subtotals
• Creating and modifying a PivotTable (from an Excel table)

Teaching methods: Classroom or online learning: 4 hours (including 4 hours of practical exercises in the learning environment).

Assessment method: Self-assessment.

Assessment criteria: Achievement of the learning outcomes is not assessed.

Completion of the training: Upon request, participants who complete the workshop will receive a certificate of attendance.

The price includes: Coffee breaks at the training centre.

This course provides students with the knowledge and skills to create a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

Based on the Microsoft official Course DP-300T00-A: Implement scalable database solutions using Azure SQL – Training | Microsoft Learn

Related certification Microsoft Certified: Azure Database Administrator Associate

Target audience and prior knowledge (Prerequisites):  The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.

Teaching aids: Windows operating system computer. If desired, the participant can use their personal computer, which we ask you to inform the training company about.

Program:

• Plan and implement data platform resources
• Implement a secure environment for a database service
• Monitor and optimize operational resources in Azure SQL
• Optimize query performance in Azure SQL
• Automate database tasks for Azure SQL
• Plan and implement a high availability and disaster recovery environment

Learning methods: You can participate in the study by entering the classroom or joining the training through the online environment Ms Teams.
The volume of training is 32 hours incl. 15 hours of practical exercises in the training environment.

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.

The price includes:

• The opportunity to take one Microsoft certification exam of your choice within six months of completing the course.
• Access to DP-300T00 exercises through a official lab environment.
• Coffee breaks at the training center and shared lunches.

Curriculum group: 0612 Database and network design and management.