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

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

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

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

Koolituse eesmärgiks on arendada teadmisi mahukamate materjalide ja raamatute küljendamiseks.

Programm:

• Programmi seadistused
• Indesign CC versiooni uuendused
• Tööd kiirendavad nipid
• Interaktiivne PDF
• PDF vormid
• Publishing Online
• Data merge
• Mahuka dokumendi küljendamine
  • Pages, Master, Layers
  • Lehtede numeratsioon, sektsioonid, päised/jalused
  • Info sissetoomine – Place (Word, Excel, PDF, Photoshop, Illustrator)
    • Import options, Style mapping
    • Anchored objects
  • Tekstistiilid – (Paragraph, Character)
    • Nested styles
  • Sisukorra loomine ja kujundamine
  • Objektistiilid
  • Lahtri- ja tabelistiilid
  • Joonealused- ja ristviited
• Raamatuloend (Book)
  • Raamatu dokumentide sünkroniseerimine
  • Raamatu numereerimine
  • Sisukord
  • Indeksid

Koolitusel saab osaleda nii klassis kui ka veebi teel.

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.

Õppemeetodid: Praktiline harjutus, iseseisev töö

Hindamismeetod: Iseseisvate tööde sooritamine.

Hindamiskriteerium: Õpiväljundite saavutamist kontrollitakse läbi iseseisva praktilise töö.

Hind sisaldab kohvipause koolituskeskuses.

This four-day instructor-led course teaches IT Pros how to deploy and configure Active Directory Domain Services (AD DS) in a distributed environment, how to implement Group Policy, how to perform backup and restore, and how to monitor and troubleshoot Active Directory–related issues with Windows Server 2016. Additionally, this course teaches how to deploy other Active Directory server roles such as Active Directory Federation Services (AD FS) and Active Directory Certificate Services (AD CS).

Target audience: This course is primarily intended for existing IT professionals who have some AD DS knowledge and experience and who aim to develop knowledge about identity and access technologies in Windows Server 2016. This would typically include:

• AD DS administrators who are looking to train in identity and access technologies with Windows Server 2012 or Windows Server 2016.
• System or infrastructure administrators with general AD DS experience and knowledge who are looking to cross-train in core and advanced identity and access technologies in Windows Server 2012 or Windows Server 2016.

The secondary audience for this course includes IT professionals who are looking to consolidate their knowledge about AD DS and related technologies, in addition to IT professionals who want to prepare for the 70-742 exam.

Programm:

• Module 1: Installing and configuring domain controllers
• Module 2: Managing objects in AD DS
• Module 3: Advanced AD DS infrastructure management
• Module 4: Implementing and administering AD DS sites and replication
• Module 5: Implementing Group Policy
• Module 6: Managing user settings with Group Policy
• Module 7: Securing Active Directory Domain Services
• Module 8: Deploying and managing AD CS
• Module 9: Deploying and managing certificates
• Module 10: Implementing and administering AD FS
• Module 11: Implementing and administering AD RMS
• Module 12: Implementing AD DS synchronization with Microsoft Azure AD
• Module 13: Monitoring, managing, and recovering AD DS

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
• Free Microsoft certification exam within the period of 6 months after finishing the course

This course covers three central elements of Microsoft 365 enterprise administration – Microsoft 365 security management, Microsoft 365 compliance management, and Microsoft 365 device management. In Microsoft 365 security management, you will examine all the common types of threat vectors and data breaches facing organizations today, and you will learn how Microsoft 365’s security solutions address these security threats. You will be introduced to the Microsoft Secure Score, as well as to Azure Active Directory Identity Protection. You will then learn how to manage the Microsoft 365 security services, including Exchange Online Protection, Advanced Threat Protection, Safe Attachments, and Safe Links. Finally, you will be introduced to the various reports that monitor your security health. You will then transition from security services to threat intelligence; specifically, using the Security Dashboard and Advanced Threat Analytics to stay ahead of potential security breaches. With your Microsoft 365 security components now firmly in place, you will examine the key components of Microsoft 365 compliance management. This begins with an overview of all key aspects of data governance, including data archiving and retention, Information Rights Management, Secure Multipurpose Internet Mail Extension (S/MIME), Office 365 message encryption, and data loss prevention (DLP). You will then delve deeper into archiving and retention, paying particular attention to in-place records management in SharePoint, archiving and retention in Exchange, and Retention policies in the Security and Compliance Center. Now that you understand the key aspects of data governance, you will examine how to implement them, including the building of ethical walls in Exchange Online, creating DLP policies from built-in templates, creating custom DLP policies, creating DLP policies to protect documents, and creating policy tips. You will then focus on managing data governance in Microsoft 365, including managing retention in email, troubleshooting retention policies and policy tips that fail, as well as troubleshooting sensitive data. You will then learn how to implement Azure Information Protection and Windows Information Protection. You will conclude this section by learning how to manage search and investigation, including searching for content in the Security and Compliance Center, auditing log investigations, and managing advanced eDiscovery. The course concludes with an in-depth examination of Microsoft 365 device management. You will begin by planning for various aspects of device management, including preparing your Windows 10 devices for co-management. You will learn how to transition from Configuration Manager to Intune, and you will be introduced to the Microsoft Store for Business and Mobile Application Management. At this point, you will transition from planning to implementing device management; specifically, your Windows 10 deployment strategy. This includes learning how to implement Windows Autopilot, Windows Analytics, and Mobile Device Management (MDM). When examining MDM, you will learn how to deploy it, how to enroll devices to MDM, and how to manage device compliance.

Program: 

• Module 1: Introduction to Microsoft 365 Security Metrics
• Module 2: Managing Your Microsoft 365 Security Services
• Module 3: Microsoft 365 Threat Intelligence
• Module 4: Introduction to Data Governance in Microsoft 365
• Module 5: Archiving and Retention in Microsoft 365
• Module 6: Implementing Data Governance in Microsoft 365 Intelligence
• Module 7: Managing Data Governance in Microsoft 365
• Module 8: Managing Search and Investigations
• Module 9: Planning for Device Management
• Module 10: Planning Your Windows 10 Deployment Strategy
• Module 11: Implementing Mobile Device Management

Target audience: This course is designed for persons who are aspiring to the Microsoft 365 Enterprise Admin role and have completed one of the Microsoft 365 role-based administrator certification paths.

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.
• Free Microsoft certification exam within the period of 6 months after finishing the course.

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

Lektori CV

Register to the workshop HERE!

Getting started with Ansible Engine and Ansible Tower for Linux automation

What is Ansible, how does it work in the command line – and where does Ansible Tower fit it?

This workshop teaches the bits you need to know by using Ansible Automation on your own. In the second half we will focus on Ansible Tower and show where it fits in – and when and why you absolutely need it when you automate more and more.

This workshop is intended for people who want to learn the details of Ansible Automation including Ansible Tower, understand how they work and how they can be used to automate tasks. In addition, the instructor will provide information on the differentiation between the upstream project and the product offering from Red Hat.

Agenda

Introduction to Ansible

• Running Ad-hoc Commands
• Writing Your First Playbook
• Using Variables, Conditionals, Handlers and Loops
• Building Templates
• Roles

Introduction to Ansible Tower

• Inventories
• Credentials
• Ad-Hoc commands
• Projects
• Job Templates
• Using the Survey Feature
• Role Based Access Control
• Workflows

HANDS ON LAB

The exercises are self-explanatory and guide the participants through the entire lab. All concepts are explained when they are introduced.

Participating in the RedHat workshop is free. 

Red Hat Ansible automation for Enterprise Linux workshop is supported by BCS Koolitus, Arrow ECS and Santa Monica Networks / Elisa Eesti AS. 

This three-day course is intended primarily for IT Professionals who have experience with managing an on-premises Windows Server environment. Its purpose is to prepare professionals for planning, implementing, and managing environments that include Azure IaaS-hosted Windows Server-based workloads. The course covers how to leverage the hybrid capabilities of Azure, how to migrate virtual and physical server workloads to Azure IaaS, and how to manage and secure Azure VMs running Windows Server 2019.

This course is intended for IT Professionals who manage on-premises Windows Server environments and want to use Azure to manage server workloads and secure virtual machines that are running on Windows Server 2019. Secondarily, this course benefits any role that involves administrative and operational tasks targeting Microsoft Azure Infrastructure as a Service (IaaS) workloads.

Program:

• Module 1: Introducing Azure Hybrid IaaS with Windows Server 2019
• Module 2: Implementing identity in hybrid scenarios
• Module 3: Facilitating hybrid management and operational monitoring in hybrid scenarios
• Module 4: Implementing security solutions in hybrid scenarios
• Module 5: Implementing file services in hybrid scenarios
• Module 6: Deploying and configuring Azure VMs
• Module 7: Managing and maintaining Azure VMs
• Module 8: Planning and implementing migration and recovery services in hybrid scenarios

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

This course provides foundational knowledge on the considerations and benefits of adopting cloud services and the Software as a Service (SaaS) cloud model, with a specific focus on Microsoft 365 cloud service offerings. You will begin by learning about cloud fundamentals, including an overview of cloud computing and specifically Microsoft cloud services. You will be introduced to Microsoft Azure, and you will examine the differences between Microsoft 365 and Office 365. You will then perform an in-depth review of Microsoft 365, including a comparison of Microsoft on-premises services versus Microsoft 365 cloud services, a review of enterprise mobility in Microsoft 365, and an analysis of how Microsoft 365 services provide collaboration. The course then analyzes how security, compliance, privacy, and trust are handled in Microsoft 365, and it concludes with a review of Microsoft 365 subscriptions, licenses, billing, and support.

This course is designed for Business Decision Makers and IT Professionals who aspire to deploy cloud services in their organization, or who are simply looking to acquire foundational knowledge on cloud fundamentals. This includes the considerations and benefits of adopting cloud services in general and the Software as a Service (SaaS) cloud model specifically, with a general focus on Microsoft 365 cloud service offerings.

Program:

• Module 1: Cloud concepts
• Module 2: Microsoft 365 productivity and teamwork capabilities
• Module 3: Microsoft 365 business management capabilities
• Module 4: Microsoft 365 security and compliance
• Module 5: Microsoft 365 Licensing and support

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
• Free Microsoft certification exam within the period of 6 months after finishing the course

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

Lektori CV