Alustava veebiarendaja koolitus

Kandideerimine on lõppenud! Tulemustest anname teada hiljemalt 14.08

Koolituse eesmärgiks on õpetada osalejaid looma ja arendama veebirakendusi. Koolitus on osaleja jaoks ideaalne esimene samm IKT sektori suunas. Koolituse läbinu omandab oskused, et asuda tööle veebirakenduste juuniorarendajana, front-end juuniorarendajana, IT-rakenduste administraatorina, IT-projektijuhtina või IT-nooremspetsialistina. (veel …)

Pythoni programmeerimise algkursus

4-päevase kursuse eesmärk on viia täiesti programmeerimisoskamatu osaleja programmeerimisalaste teadmiste tasemele, mis võimaldab tal mõista tarkvara arenduse põhimõisteid ning Pythoni keeles kodeeritud programme kujundada, kirjutada, siluda ja käivitada. (veel …)

Andmete importimine ja analüüsimine Power Query ja Pivot Tabel abil

Koolituse eesmärk: Osalejad saavad oskused, kuidas rakenduse Power Query abil saab erinevatest andmeallikatest andmeid importida, omavahel ühendada, korrastada ning lõpuks Pivot Table abil analüüsida.

Sihtgrupp: Koolitusele on oodatud kõik, kellel vajadus luua andmetest raporteid ja kokkuvõtteid ning saadud tulemusi võrrelda ja analüüsida. Koolitusel osalemine eeldab Exceli kasutuskogemust baastasemel.

Õppevahendid: Windows operatsioonisüsteemi arvuti. Soovikorral võib osaleja kasutada oma personaalset arvutit.

Programm:

Andmete importimine ja korrastamine Power Query abil:

  • Power Query töökeskkond
  • Andmete importimine erinevatest allikatest (veebilehelt, Exceli- ja tekstifailist, andmebaasist, kaustast, …)
  • Andmete korrastamine
    • Struktuuri korrastamine
    • Veergude tükeldamine ja ühendamine
    • Asendused
    • Filtrid
    • Unpivot
    • Tühjade lahtrite täitmine
    • Arvutusveeru loomine (M-funktsioonid)
  • Tabelite ühendamine päringute abil (ühendamis- ja liitmispäringud)
  • Päringute värskendamine (manuaalne ja automaatne)

Kokkuvõtete ja raportite koostamine liigendtabeliga Pivot Table

  • Millal ja milleks liigendtabelit kasutada
  • Liigendtabeli ehitus
    • Lihtsa liigendtabeli moodustamine
    • Nõuded algandmetele
    • Andmete valimine
    • Väljade lisamine raportisse
    • Raporti filtri kasutamine
    • Andmete uuendamine
    • Andmete sorteerimise võimalused liigendtabelis
    • Liigendtabeli puhvri jagamine teistele liigendtabelitele 
    • Liigendtabeli ümberpaigutus
  • Liigendtabeli kohandamine
    • Väljade grupeerimine
    • Visuaalsed muudatused raportis
    • Kokkuvõtte-funktsiooni valik raportis (SUM; COUNT; AVERAGE; STDEV jm)
    • Vahekokkuvõtete lisamine ja eemaldamine
    • Vahekokkuvõtete arvutusvõimalused (kumulatiivsed summad, protsendid…)
    • Uued arvutusväljad ja arvutusväärtused liigendtabelis (Calculated field, Calculated item)
    • Filtreerimise võimalused liigendtabelis (Slicer)
  • Andmete kuvamine liigendtabelis 
    • Väljade grupeerimine
    • Väljade ümberpaigutus raportis
    • Andmete sorteerimise võimalused liigendtabelis
    • Filtreerimise võimalused liigendtabelis
    • Liigendtabeli raporti andmete kuvamine diagrammina
    • Tingimusliku kujundamise kasutamine liigendtabelis
  • Eraldi paiknevate tabelite analüüs liigendtabeliga

Õppemeetodid: Õppetöös saab osaleda klassiruumi tulles või liitudes koolitusega läbi veebikeskkonna Zoom. Koolituse maht on  9 tundi sh 6  tundi praktilisi harjutusi koolituskeskkonnas.
Veebikoolitusel saab osaleda  videokonverentsi keskkonnas Zoom. Koolituse keskkonda sisenemise link koos juhendiga saadetakse koolitusele registreerujatele enne koolitust. Hoolsa õpilasena pääsed „klassiruumi“ 15 min enne koolituse algust, et kõik vajalik (pilt, mikrofon ja vestlus) häälestada. Väga tervitatav on kahe ekraani kasutamise võimalus (kui ei ole, saab hakkama ka ühega). Koolituse käigus tehakse läbi praktilisi harjutusi, mis eeldab osaleja interaktiivset panustamist.
Hindamismeetod: Praktiliste harjutuste sooritamine.
Hindamiskriteerium: Õpiväljundite saavutamist hinnatakse koolituse ajal läbi viidud tagasisidestatud praktiliste harjutuste põhjal.
Koolituse lõpetamine: Koolituse lõpetaja saab tunnistuse kui sooritab kõik koolituse jooksul antud praktilised harjutused. Osalejatele, kes õpiväljundeid saavutanud ei ole väljastatakse soovi korral tõend koolitusel osalemise kohta.
Hind sisaldab:

  • Lõunat või kohvipausi (poole päeva puhul) koolituskeskuses
  • 2-nädalast e-õppe platvormi Skillaby kasutusõigust peale koolituse lõppu

Õppekavarühm: 0611 Arvutikasutus.

Lektori CV

Kliendi tagasiside:

“Koolituse sisu oli hästi üles ehitatud. Praktiline ja teoreetiline käsi-käes. Lihtne oli jälgida ja kaasa teha. Head praktilised ja asjalikud näited, mis reaalselt võivad tööalaselt ette tulla. Koolitaja suutis oma tarkusi hästi edasi anda. Väga meeldis ja tuleks kindlasti mõnele teisele IT alasele koolitusele BCSi veel.”

#NoEstimates- Deliveries on time

#NoEstimates is an approach to software development that arose from the observation that large amounts of time were spent over the years in estimating and improving those estimates, but we see no value from that investment. Indeed, according to scholars Conte, Dunmore and Shens [1] a good estimate is one that is within 25% of the actual cost, 75% of the time.

This is the same as saying: give us your money, we promise not lose more than 25% of it (with a 25% probability that we will lose a lot more). We don’t find that acceptable or productive for our industry. There must be better ways to manage software and product development.

In this workshop we will review and analyze why we do estimates and how we can improve software and product development while reducing the time and money invested in estimating.

[1] Paper referred to by Steve McConnell in his book: Software Estimation, Demystifying the Black Art

Programm:

  • Decision making frameworks for projects that do not require estimates
  • Investment models for software projects that do not require estimatesroject management (risk management, scope management, progress reporting, etc.) approaches that do not require estimates
  • The tools and arguments you need to prove the value of #NoEstimates to your boss
  • How to get started applying #NoEstimates right away
  • Where is #NoEstimates going and what are the likely changes to software development that will come next.

Target audience: 

  • Product Owners
  • Team leaders
  • Team members
  • Agile Coaches
  • Scrum Masters

More information:

  • Price includes coffee breaks and lunch
  • Read more about the course from here

 

Konfiguratsioonihaldussüsteemid Ansible, Chef ja Puppet

Kolmepäevase koolituse eesmärgiks on anda ülevaade ja praktilised kogemused konfiguratsioonihaldussüsteemidest. Vaadeldakse kolme erinevat platvormi (Ansible, Chef ja Puppet), millega saab hallata Windows, Linux ja Macintosh kliente ning servereid.

Koolitusel saab osaleda ka moodulite kaupa, keskenduses vaid just endale sobiva konfiguratsioonihaldussüsteemi õppimisele.  Igal päeval keskendutakse ühele konkreetsele konfiguratsioonihaldussüsteemile.

Sihtrühm ja eelteadmised: Koolitusele on oodatud kõik, kes soovivad juurutada klientide/serverite tsentraalset haldust ja seadistamist.

Vajalik on algtasemel Linuxi ja/või Windowsi kasutamise- ja admnistreerimiskogemus. Samuti algteadmised operatsioonisüsteemide ülesehitusest ja komponentidest.

Õppevahendid: Linuxi operatsioonisüsteemil toimiv arvuti.

Programm:
1. moodul – Ansible

  • Konfiguratsioonihaldussüsteemidest üldiselt. Seadistuste unifitseerimine, deklaratiivsed keeled
  • Ansible paigaldus, võimalikud lähterepod ja meetodid
  • Ansible ad-hoc käsud. Ansible moodulid.
  • Ansible playbook
  • Kasutaja ja tema rekvisiidid, tarkvara installatsioon, tarkvara teenusena
  • Template (põhi), selle väärtustamine
  • Muutujad ja nende väärtustamine ja prioriteedid  Ansible-s.
  • Ansible Collection kui struktureeritud komplekt haldusjuhendeid. Valmis-collection-id, oma collectioni loomine
  • Turbekomplektid, operatsioonisüsteemi turvamine etteantud kriteeriumite järgi, STIG

2. moodul – Chef

  • Klient-server konfiguratsioonihaldussüsteemi ülesehitus. Tsentraalse serveri eelised ja puudused
  • Sertifikaadipõhine autent, selle rakendamine Chefi keskkonnas
  • Chef Solo, push-põhine lähenemine Chef puhul
  • Chef-i kasutamine Vagranti abil
  • Chefi rakendamisest pilves. Hosted Chef
  • Chef serveri installatsioon
  • Chef kliendi installatsioon
  • Chefi süntaks, Cookbookid
  • Chefi keelendid, muutujad
  • Rakenduse ülesehitamine Chefi põhjal
  • Chef Automate kui etteantud template-dega haldusvahend

3. moodul – Puppet

  • Puppet kui klient-server süsteem
  • Puppet DSL (Domain Specific Language) Ülesehitus, operatsiooni pealiskiht kui konfiguratsiooni unifitseerimise alus, keele komponendid
  • Puppeti moodulid
  • Puppeti kliendi installatsioon, kliendi komponentide vaade puppeti keeles (windows + linux)
  • Puppet ja operatsioonisüsteemi profileerimine (Facter)
  • Puppetserveri installatsioon, klientide lisamine ja eemaldamine
  • Standardiseeritud konfiguratsiooni struktuur – võimalikud eri keskkonnad Live/Test/Dev
  • Puppetforge
  • Hiera kui puppeti konfiguratsioonide infokogum

Õppemeetodid: Auditoorne töö klassi- või veebikeskkonnas 24 tundi (sh praktilised harjutused koolikeskkonnas 15 tundi).

Hindamismeetod: Praktiliste tööde sooritamine koolituskeskkonnas.

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;
  • Mooduli kaupa koolitusel osalemise soovist tuleb teavitada registreerumisel koolitusasutust.

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

Lektori CV

Kliendi tagasiside:

„Koolituse toimumiskoht on hästi ligi pääsetav. Tehnika on hea. Hind taskukohane. Lektor oskas piisavalt näiteid tuua ning tegi teema selgeks“

Certified Scrum Master Course (CSM)

If you’re ready to grow more agile with Scrum, our Certified ScrumMaster® (CSM®) course is designed for you. You’ll learn the Scrum framework and gain an 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 course is an interactive and engaging learning experience. Taught by our passionate trainers with rich hands-on experience from the coaching trenches, our CSM 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 Certified ScrumMaster® (CSM®) course is the right place to start. You’ll gain a solid understanding of Scrum and learn practical ways to apply it on your team and throughout your organization.

Our CSM workshop gives 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.

Who should take the course?

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, 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 on Agile and Scrum.

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® certification?

By earning a Certified ScrumMaster® certification you:

  • Expand your career opportunities by staying relevant and marketable across all industry sectors 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, 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 reasons that 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 CSM workshop, free of charge. Though, 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.

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

Lecturer’s LinkedIn

Database administration with Microsoft SQL Server 2016 (MOC#20764, MOC#20765) (veebi- ja klassikoolitusena)

This four-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Prerequisites:

  • Working knowledge of relational databases.
  • Working knowledge of Transact-SQL.
  • Some experience with database design.
  • This course is NOT recommended to junior developers.

Program:

  • Module 1: SQL Server Security
  • Module 2: Assigning Server and Database Roles
  • Module 3: Protecting Data with Encryption and Auditing
  • Module 4: Backing up SQL Server Databases
  • Module 5: Restoring SQL Server 2016 Databases
  • Module 6: Automating SQL Server Management
  • Module 7: Configuring Security for SQL Server Agent
  • Module 8: Introduction to managing SQL Server by using PowerShell
  • Module 9: Tracing Access to SQL Server with Extended events
  • Module 10: Importing and Exporting Data
  • Module 11: SQL Server 2016 Components
  • Module 12: Installing SQL Server 2016
  • Module 13: Upgrading SQL Server to SQL Server 2016
  • Module 14: Working with Databases
  • Module 15: Performing Database Maintenance
  • Module 16: Database Storage Options
  • Module 17: Planning to Deploy SQL Server on Microsoft Azure
  • Module 18: Migrating databases to Azure SQL Database
  • Module 19: Deploying SQL Server on a Microsoft Azure Virtual Machine
  • Module 20: Managing databases in the Cloud

Target audience:The primary audience for this course is individuals who administer and maintain SQL Server databases. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
Learning methods: Practical exercise.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.

Veebikoolitusel saab osaleda  videokonverentsi keskkonnas Zoom. Koolituse keskkonda sisenemise link koos juhendiga saadetakse koolitusele registreerujatele enne koolitust. Hoolsa õpilasena pääsed „klassiruumi“ 15 min enne koolituse algust, et kõik vajalik (pilt, mikrofon ja vestlus) häälestada. Väga tervitatav on kahe ekraani kasutamise võimalus (kui ei ole, saab hakkama ka ühega). Koolituse käigus tehakse läbi praktilisi harjutusi, mis eeldab osaleja interaktiivset panustamist.

More information:

  • Free Microsoft certification exam within the period of 6 months after finishing the course

Microsoft Cloud Workshop – Hybrid Identity

About Workshop: In this workshop, you will learn to setup and configure a hybrid identity solution that integrates an existing on-premises identity solution with Azure. You will learn how to secure the virtual network by deploying a network virtual appliance and configure firewall rules and route tables. Additionally, you will set up access to the virtual network with a jump box and a site-to-site VPN connection.

Audience Profile: 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 Workshop’ and ‘At Workshop 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.

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

New! Effective Coding Principles and Patterns in Java (Online)

Do you want to write code that is easy to read and test? Develop real-world Java applications that are easy to maintain? Move fast without compromising quality?

Then this course is for you.

During this intensive and practical 2-day workshop, you will learn how to develop modern, clean, and maintainable applications using the latest Java best practices. This is not a trivial Java 15 course for complete beginners. Here you’ll learn real-world stuff from class design and unit testing to large-scale architecture, controlling quality, and getting out of technical debt.

Program:

  • Effective code design
  • Effective functions
  • Effective class design
  • Effective service layer
  • Effective packaging
  • Effective persistence
  • Effective validation
  • Effective testing
  • Effective resilience

Target audience: Java developers, architects and team leaders eager to improve their Java coding, design and architecture skills.

More information:

  • You earn a Certificate of Accomplishment after completing an exam. Use it to boost your CV and LinkedIn profile.
  • Read more about the course from here

 

NEW! Efficient Remote Meetings & Collaboration (Online)

The goal of the education is to provide you with tools, tips, techniques and skills that will help you host more engaging and more focused online meetings and collaborative workshops. You will be able to apply what you learn in different situations, such as department town halls, sync meetings, creative workshops, planning sessions, retrospectives and training sessions.

During this training, which itself is given online, you will learn how to facilitate remote meetings with high presence, engagement and that result in concrete outcomes. You will learn, and get to practice tools, skills, a variety of workshop formats, techniques and tips that will improve your online collaboration with your colleagues and team members.

After the training you will be able to apply what you’ve learned…

  • as the moderator in the short sync meeting
  • as a facilitator of a workshop or planning exercise
  • as a facilitator of a retrospective
  • as a host of a wider company presentation

Training topics: 

  • Different online collaboration tools and when they are useful
  • Tips and techniques applicable when moderating short small meetings
  • Tips and techniques applicable when facilitating team workshops
  • Tips and techniques applicable when hosting presentations for a wider audience
  • How to facilitate engaging meetings with remote participants
  • How to prepare before the workshop
  • How to work with structure and clarity to raise focus
  • How to launch and frame the meeting to increase presence and engagement
  • Different workshop formats that are suitable for online collaboration
  • Different methods and techniques for decision making
  • Closure of meetings to maximize commitment and clarity on what happens next

Target audience: Work with remote team members (if current circumstances dictate you to work from home) and want to learn how to raise engagement, focus and structure into the video meetings you host or facilitate. You may have a role as Manager, Scrum Master, Project Manager, Product Owner or Educator.

More information:

  • Read more about the course from here