Koolituse eesmärgiks on anda 2 päeva jooksul teadmised Microsofti Entra ID põhise identiteedi- ja autentimissüsteemi seadistamise ja halduse olulisematest teemadest. Kursus toimub loengute ja praktiliste harjutuste vormis, koolitatavad seadistavad oma virtuaalse Entra ID keskkonna. Kursus põhineb 4-päevasel Microsofti SC-300 materjalide ja harjutuste komplektil, mille osalejad saavad oma kasutusse täies mahus.

Sihtrühm ja eelteadmised: Koolitusele on oodatud kõik MS Azure ja Microsoft 365 administraatorid. Samuti kõik, kes valmistuvad SC-300 ametlikuks eksamiks. Koolitusel osalemise eelduseks on mõningane kogemus Azure/Entra ID/MS 365 haldusvahenditega.

Õppevahendid: Internetiühenduse ja veebibrauseriga arvuti. Soovi korral võib osaleja kasutada oma personaalset arvutit.

Programm:

• Entra ID teenuse ülevaade ja identiteedihalduri roll.
• Entra ID algne seadistamine.
• Identiteetide loomine, seadistus ja haldus.
• Väliste identiteetide kasutamine ja haldus.
• Hübriididentiteedisüsteemi seadistamine ja haldus.
• MS Entra ID kontode kaitse MFA-ga.
• Kasutajate autentimismeetodite seadistamine.
• Tingimusliku ligipääsu plaanimine, juurutus ja haldus.

Koolitus põhineb Microsofti ametliku 4-päevase koolituse „Microsoft Identity and Access Administrator (SC-300)“  materjalidel, aga lühendatud kujul ning arvestades kohalike Eesti ettevõtete eripärasid ja vajadusi.

Õppemeetodid: Õppetöös saab osaleda klassiruumi tulles või liitudes koolitusega läbi Microsoft Teamsi. Koolituse maht on 16 tundi sh 8  tundi praktilisi harjutusi koolituskeskkonnas. Harjutused on mõeldud teemade kaupa õppetöö toetamiseks ja neid tehakse selleks spetsiaalselt ette valmistatud Microsoft 365 keskkonnas.

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.   Lisaks saavad lõpetanud virtuaalse aumärgi oma isiklikku Microsofti profiili õpirajale. Osalejatele, kes õpiväljundeid saavutanud ei ole väljastatakse soovi korral tõend koolitusel osalemise kohta.

Hind sisaldab:

• kohvipausid koolituskeskuses ja ühised lõunasöögid
• SC-300 täispika kursuse materjalid ja harjutused
• Vautšer ühe kehtiva Microsofti eksami tegemiseks

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

Lektori CV

In this workshop, you will look at the process of implementing a modern application with Azure services. The workshop will cover event sourcing and the Command and Query Responsibility Segregation (CQRS) pattern, data loading, data preparation, data transformation, data serving, anomaly detection, creation of a predictive maintenance model, and real-time scoring of a predictive maintenance model.

This workshop is intended for Cloud Architects and IT professionals who have architectural expertise of infrastructure and solutions design in cloud technologies and want to learn more about Azure and Azure services as described in the ‘About this Course’ and ‘At Course Completion’ areas. Those attending this workshop should also be experienced in other non-Microsoft cloud technologies, meet the course prerequisites, and want to cross-train on Azure.

Program: 

• Module 1: Whiteboard Design Session – Innovate and modernize apps with Data and AI
• Module 2: Hands-On Lab – Innovate and modernize apps with Data and AI

Prerequisites:

Workshop content presumes 300-level of architectural expertise of infrastructure and solutions design. We suggest students take this prerequisite prior to attending this workshop.

After completing this workshop, students will be able to:

• Capture Internet of Things (IoT) device data with Azure IoT Hub
• Process device data with Azure Stream Analytics
• Apply the Command and Query Responsibility Segregation (CQRS) pattern with Azure Functions

Learning methods: Practical exercise, independent work.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.

Price includes coffee breaks and lunch

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

In this workshop, you will work as a group to setup and configure a serverless architecture within Azure using a combination of Azure Functions, Logic Apps, Event Grid, Cosmos DB, and Azure Storage. The focus is on removing server management from the equation, breaking down the solution into smaller components that are individually scalable, and allowing the customer to only pay for what they use.

This workshop is intended for Cloud Architects and IT professionals who have architectural expertise of infrastructure and solutions design in cloud technologies and want to learn more about Azure and Azure services as described in the “Summary” and “Skills gained” areas. Those attending this workshop should also be experienced in other non-Microsoft cloud technologies, meet the course prerequisites, and want to cross-train on Azure.

Program:

• Module 1: Whiteboard Design Session – Migrating SQL databases to Azure
• Module 2: Hands-On lab – Migrating SQL databases to Azure

After completing this workshop, students will be able to:

• Design a cloud migration solution for business-critical applications and databases.

Learning methods: Practical exercise, independent work.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.

Price includes coffee breaks and lunch

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

This course provides students with the knowledge and skills to administer 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.

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.

Program:

• Module 1: The Role of the Azure Database Administrator
• Module 2: Plan and Implement Data Platform Resources
• Module 3: Implement a Secure Environment
• Module 4: Monitor and Optimize Operational Resources
• Module 5: Optimize Query Performance
• Module 6: Automation of Tasks
• Module 7: Plan and Implement a High Availability and Disaster Recovery Environment

Prerequisites:

Successful Azure Database Administrators start this role with professional experience in database management and technical knowledge of cloud technologies.

Specifically:

• Working with, maintaining, and developing with SQL Server
• Experience with Azure, such as deploying and managing resources

After completing this course, students will be able to:

• Plan, deploy and configure Azure SQL offerings
• Monitor database performance and tune a database and queries for optimum performance
• Plan and configure a High Availability Solution

Learning methods: Practical exercise, independent work.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.

Price includes coffee breaks and lunch

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

This course will enable the students to understand Azure SQL Database, and educate the students on what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database.

The primary audience for this course is database developers who plan to migrate their MySQL or Postgres DB workloads to Azure SQL DB. The secondary audience for this course is MySQL/Postgres administrators to raise awareness of the features and benefits of Azure SQL DB.

Program:

• Module 1: Migrate to Azure SQL DB for MySQL & PostgreSQL
• Module 2: Migrate on-premises MySQL to Azure SQL DB for MySQL
• Module 3: Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL

Prerequisites:

Successful students start this role with a fundamental knowledge of cloud computing concepts and experience with open source relational database management systems.
Specifically:

• Working with PostgreSQL and/or MySQL
• Using backup and recovery techniques with open source data
• SQL administration

After completing this course, students will be able to:

• Migrate on-premises MySQL to Azure SQL DB for MySQL
• Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL

Learning methods: Practical exercise, independent work.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.

Price includes coffee breaks and lunch

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

This course will teach the students what is Cosmos DB and how you can migrate MongoDB and Cassandra workloads to Cosmos DB.

The primary audience for this course is database developers who plan to migrate their MongoDB or Cassandra DB workloads to Azure using Cosmos DB.

Program:

• Module 1: Building Globally Distributed Applications with Cosmos DB

• Module 2: Migrate MongoDB Workloads to Cosmos DB
• Module 3: Migrate Cassandra DB Workloads to Cosmos DB

Prerequisites:

Successful students start this role with a fundamental knowledge of cloud computing concepts and professional experience in configuring NoSQL applications.

Specifically:

The fundamental concepts of partitioning, replication, and resource governance for building and configuring scalable NoSQL applications that are agnostic of Cosmos DB API.
Experience with Azure, such as deploying and managing resources

After completing this course, students will be able to:

• Building Globally Distributed Applications with Cosmos DB
• Migrate MongoDB Workloads to Cosmos DB
• Migrate Cassandra DB Workloads to Cosmos DB

Learning methods: Practical exercise, independent work.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.

Price includes

Coffee breaks and lunch

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

This course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.

Program:

• Module 1: Getting Started with Transact-SQL

• Module 2: Sorting and Filtering Query Results
• Module 3: Using Joins and Subqueries
• Module 4: Using Built-in Functions
• Module 5: Modifying Data

After completing this course, students will be able to:

• Use SQL Server query tools
• Write SELECT statements to retrieve columns from one or more tables
• Sort and filter selected data
• Use built-in functions to returned data values
• Create groups of data and aggregate the results
• Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE

Learning methods: Practical exercise, independent work.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.

Price includes

Coffee breaks and lunch

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

Lecturer’s Linkedin

In this course, students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure. They will explore the roles, tasks, and responsibilities in the world of data. The students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure. They will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure. Students will explore the processing options available for building data analytics solutions in Azure. They will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.

Prerequisites
Prerequisite certification is not required before taking this course. Successful Azure Data Fundamentals students start with some basic awareness of computing and Internet concepts, and an interest in extracting insights from data.

Specifically:

• Experience using a web browser, such as Microsoft Edge.
• Familiarity with basic data-related concepts, such as working with tables of data in a spreadsheet and visualizing data using charts.
• A willingness to learn through hands-on exploration.

Program:

• Module 1: Explore core data concepts
• Module 2: Explore relational data in Azure
• Module 3: Explore non-relational data in Azure
• Module 4: Explore modern data warehouse analytics in Azure

Target audience: The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.

Learning methods: Practical exercise.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.

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

Lecturer’s Linkedin

In this course, the students will explore the objectives of data platform modernization and how it is suitable for given business requirements. They will also explore each stage of the data platform modernization process and define what tasks are involved at each stage, such as the assessment and planning phase. Students will also learn the available migration tools and how they are suitable for each stage of the data migration process. The student will learn how to migrate to the three target platforms for SQL based workloads; Azure Virtual Machines, Azure SQL Databases and Azure SQL Database Managed Instances. The student will learn the benefits and limitations of each target platform and how they can be used to fulfil both business and technical requirements for modern SQL workloads. The student will explore the changes that may need to be made to existing SQL based applications, so that they can make best use of modern data platforms in Azure.

Target audience: The audience for this course is data professionals and data architects who want to learn about migrating data platform technologies that exist on Microsoft Azure and how existing SQL based workloads can be migrated and modernized. The secondary audience for this course is individuals who manage data platforms or develop applications that deliver content from the existing data platform technologies.

Program:

• Module 1: Introducing Data Platform Modernization
• Module 2: Choose the right tools for Data Migration
• Module 3: Migrating SQL Workloads to Azure Virtual Machines
• Module 4: Migrate SQL Workloads to Azure SQL Databases
• Module 5: Migrate SQL Workloads to Azure SQL Database Managed Instance

Prerequisites:

Successful students start this role with a fundamental knowledge of cloud computing concepts and professional experience in implementing SQL solutions.

Specifically:

• Working with and maintaining SQL workloads
• Experience with Azure, such as deploying and managing resources

Learning methods: Practical exercise, independent work.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.

Price includes:

Coffee breaks and lunch.

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

„Vali IT!“ on täiskasvanute ümberõppeprogramm, mille eesmärgiks on anda osalejatele tarkvaraarendaja algoskused.

„Vali IT!  programmis osalejad läbivad 6-nädalase täismahus õppe (5 päeva nädalas, 8 tundi päevas) BCS Koolitus koolituskeskuses. Sellele järgneb 8-nädalane (40 tööpäeva, 8 tundi päevas) praktika ettevõtetes. Kokku kestab „Vali IT!“ programmis õpe ligi 3,5 kuud.

Sihtgrupp: „Vali IT!“ kursusele on oodatud osalema väljaspool IT erialasid juba kõrghariduse omandanud inimesi. Koolitusele kandideerijal peab olema kõrgharidus või kui olete õpingud katkestanud, siis peab olema läbitud vähemalt pool õppekavast. Kes on katkestanud õpingud selliselt, et õppekavalt eksmatrikuleerimine on toimunud vähemalt neli (4) aastat tagasi arvestatuna 7. august 2016 ning läbitud on vähemalt 50% õppekava mahust, millele olid immatrikuleeritud. Kandidaat peab omama vähemalt 3-aastast  soovitavalt kõrghariduse keerukuse ametis töötamise kogemust, v.a. IT- haridust nõudval ametikohal töötamise kogemus. Teie töökogemus on oluline kandideerimisel, kui hindame teie kogemuste väärtust ja sobivust tarkvaraarenduses.

Programm: Täpsem koolituskava asub siin. 

Õppemeetodid: Praktiline harjutus, iseseisev töö

Hindamismeetod: Iseseisvate tööde sooritamine.

Hindamiskriteerium: Õpiväljundite saavutamine selgitatakse välja koolituse jooksul osalejatele antavate iseseisvate praktiliste töödega.

REGISTREERIMINE KOOLITUSELE SIIN!