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

Kliendi tagasiside:

„Koolitusel oli seletatud korralikult ja ei olnud lihtsalt maha lugemine kuskilt. Sai palju proovida ja katsetada. Oli lahti seletatud olukorrad kus miski toimib ja kus kasutaks midagi muud tegelikult. Koolitus oli tore ja ei olnud igav kuulata.“

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!

„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 Koolituse ja IT Koolituse koolituskeskustes. 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!

Koolituse eesmärk: anda osalejale MS Exceli kasutamise oskused nii, et koolituse tulemusena oskab õppija luua arvutustabeleid, neid kujundada ja printida ning olemasolevaid andmetabeleid analüüsida.

(veel …)

As a Certified Scrum Product Owner® (CSPO®), you’ve been taught the Scrum terminology, ceremonies, and principles that enable you to fulfill 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.

To further enhance your knowledge and skills, the next step is achieving an Advanced Certified Scrum Product Owner™ (A-CSPO™) certification from Scrum Alliance®. This advanced offering is ideal for a Certified Scrum Product Owner who already has one year of experience working as a Product Owner on a Scrum team.

As a Product Owner, you know there are rarely enough hours in the day to do what really matters — building really 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.”

Who should take the course?

This course if for Certified Scrum Product Owners (CSPO) who are looking for the next level of growth.

• Managers who want to help your organization build fantastic products
• Product management and portfolio management professionals
• Project management professionals
• Business stakeholders
• UX and CX practitioners, and business analysts
• Product development team members
• Product Owners, Scrum Masters, and agile coaches

The Advanced Certified Scrum Product Owner (A-CSPO) workshop requires previous Scrum Product Owner knowledge and experience. All attendees must have the Certified Scrum Product Owner certification (CSPO) and with some practice prior to this workshop.

Course Content

• Product Essentials
  • Product basics
  • Product life cycle concept and corrsponding strategy
• Empathizing Customers and Users
  • Perform customer research
  • Interview and tips for insightful interview
• Advanced Product Assumption Validation
  • Cognitive biases and their impacts to 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 roadmapping and its development
  • Advanced product planning and forecasting
  • Release planning
• Advanced Product Backlog Management
  • Model and measure value for 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
  • 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

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

Lecturer’s LinkedIn

As a Certified ScrumMaster® (CSM®), you’ve been introduced to Scrum values, practices, and applications. You now have experienced also some successes and faced certain challenges working with Scrum at work. You probably also have felt the needs of advancing your skills and learning more practices to better support you teams, and your organization.

To further enhance your knowledge and skills, the next step is achieving an Advanced Certified ScrumMaster™ (A-CSM™) certification from Scrum Alliance®. Our advanced offering is ideal for a Certified ScrumMaster who has one or more years of work experience in that role.

Who should take this course?

This course is for:

• Certified ScrumMasters (CSM) who are looking to advance their agile coaching skills
• ScrumMasters who have Scrum experience for over one year
• ScrumMasters who understand real challenges working with Scrum
• People in supporting roles who want to better support their teams
• Individuals who want to develop themselves on the path of Agile Coach

The Advanced Certified ScrumMaster workshop requires previous Scrum knowledge and experience. All attendees must have the Certified ScrumMaster certification (CSM) and with practice prior to the Advanced Certified ScrumMaster (A-CSM) workshop.

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

• 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

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

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

Lecturer’s LinkedIn