Proiecte implementate

Audience profile

This course is intended for IT Professionals who are already experienced in general Windows Server and Windows Client administration, and who want to learn more about using Windows PowerShell for administration.

No prior experience with any version of Windows PowerShell, or any scripting language, is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Exchange Server, SharePoint Server, SQL Server, System Center, and others.

Prerequisites

Experience with Windows networking technologies and implementation.
Experience with Windows Server administration, maintenance, and troubleshooting.
Experience with Windows Client administration, maintenance, and troubleshooting
Students who attend this training can meet the prerequisites by obtaining equivalent knowledge and skills through practical experience as a Windows system administrator.

No prerequisite courses are required.

About this course

This five-day, hands-on course will teach you to use Windows PowerShell for administering and automating administration of Windows based servers. Students will learn core scripting skills such as creating advanced functions, writing controller scripts, and handling script errors. Students will learn how to works with Windows PowerShell Workflow, the REST API and XML and JSON formatted data files, Students will also learn how to use new administration tools such Desired State Configuration (DSC) and Just Enough Administration (JEA) to configure and secure servers

Course Outline:

First 2 days :

Getting started with Windows PowerShell. This module will introduce you to Windows PowerShell and provide an overview of the product’s functionality. The module shows you how to open and configure the shell for use and how to run commands within the shell. The module also introduces the built-in Help system in Windows PowerShell.

Lessons

Overview and background of Windows PowerShell
Understanding command syntax
Finding commands

Cmdlets for administration. This module introduces you to the cmdlets commonly used for administration. While you can search for cmdlets each time you need to accomplish a task, it is more efficient to have at least a basic understanding of the cmdlets available for system administration.

Lessons

Active Directory administration cmdlets
Network configuration cmdlets
Other server administration cmdlets

Working with the Windows PowerShell pipeline. This module introduces the pipeline feature of Windows PowerShell. Although the pipeline feature is included in several command-line shells such as the command prompt in the Windows operating system, the pipeline feature in Windows PowerShell provides more complex, more flexible, and more capable functionalities compared to other shells. This module provides you with the skills and knowledge that will help you use the shell more effectively and efficiently.

Lessons

Understanding the pipeline
Selecting, sorting, and measuring objects
Filtering objects out of the pipeline
Enumerating objects in the pipeline
Sending pipeline data as output

Understanding how the pipeline works. This module shows you how Windows PowerShell passes objects from one command to another in the pipeline. The shell provides two techniques that you can use. Knowing how these techniques work, and which one will be used in a given scenario, lets you construct more useful and complex command lines.

Lessons

Passing the pipeline data
Advanced considerations for pipeline data

Using PSProviders and PSDrives. This module introduces the PSProviders and PSDrives adapters. A PSProvider is basically a Windows PowerShell adapter that makes some form of storage resemble a disk drive. A PSDrive is an actual connection to a form of storage. You can use these two adapters to work with various forms of storage by using the same commands and techniques that you use to manage the file system.

Lessons

Using PSProviders
Using PSDrives

Querying system information by using WMI and CIM. This module introduces you to two parallel technologies: Windows Management Instrumentation (WMI) and Common Information Model (CIM). Both these technologies provide local and remote access to a repository of management information including access to robust information available from the operating system, computer hardware, and installed software.

Lessons

Understanding WMI and CIM
Querying data by using WMI and CIM
Making changes with WMI/CIM

Working with variables, arrays, and hash tablesThis module provides you the skills and knowledge required to use variables, arrays, and hash tables in Windows PowerShell.

Lessons

Using variables.
Manipulating variables.
Manipulating arrays and hash tables.

Basic scripting. This module shows you how to package a Windows PowerShell command in a script. Scripts allow you to perform repetitive tasks and more complex tasks than cannot be accomplished in a single command.

Lessons

Introduction to scripting
Scripting constructs
Importing data from files

Advanced scripting. This module introduces you to more advanced techniques that you can use in scripts. These techniques includes gathering user input, reading input from files, documenting scripts with help information and error handling.

Lessons

Accepting user input
Overview of script documentation
Troubleshooting and error handling
Functions and modules

Administering Remote Computers. This module introduces you to the Windows PowerShell remoting technology that enables you to connect to one or more remote computers and instruct them to run commands on your behalf. Lessons

Using basic Windows PowerShell remoting
Using advanced Windows PowerShell remoting techniques
Using PSSessions

Lab : Using basic remoting

Enabling remoting on the local computer
Performing one-to-one remoting
Performing one-to-many remoting

Lab : Using PSSessions

Using implicit remoting
Managing multiple computers

Using background jobs and scheduled jobs. This module provides information about the job features of Windows PowerShell. Jobs are an extension point in Windows PowerShell, and there are many different kinds of jobs. Each kind of job can work slightly differently, and has different capabilities.

Lessons

Using background jobs
Using scheduled jobs

Last 3 days :

Course 10962C: Advanced Automated Administration With Windows PowerShell

Course OutlineModule 1: Creating advanced functions This module explains how to parameterize a command into an advanced function.

Lessons

Converting a command into an advanced function
Creating a script module
Defining parameter attributes and input validation
Writing functions that accept pipeline input
Producing complex pipeline output
Documenting functions by using comment-based help
Supporting –WhatIf and -Confirm

Lab : Converting a command into an advanced function

Converting a command into an advanced function

Lab : Creating a script module

Creating a script module

Lab : Defining parameter attributes and input validation

Defining parameter attributes and input validation

Lab : Writing functions that accept pipeline input

Writing functions that accept pipeline input

Lab : Producing complex pipeline output

Producing complex pipeline output

Lab : Documenting functions by using comment-based help

Documenting functions by using comment-based help

Lab : Supporting –WhatIf and -Confirm

Supporting –WhatIf and -Confirm

After completing this module, students will be able to:

Convert a command into an advanced function.
Create a script module.
Define parameter attributes and input validation.
Write functions that accept pipeline input.
Produce complex pipeline output.
Document functions by using comment-based help.
Support -WhatIf and -Confirm.

Module 2: Using Microsoft .NET Framework and REST API in Windows PowerShell This module explains how to use Microsoft .NET Framework and REST API to supplement functionality that Windows PowerShell commands provide.

Lessons

Using Microsoft .NET Framework in Windows PowerShell
Using REST API in Windows PowerShell

Lab : Using Microsoft .NET Framework in Windows PowerShell

Using Microsoft .NET Framework in Windows PowerShell

Lab : Using REST API in Windows PowerShell

Using REST API in Windows PowerShell

After completing this module, students will be able to:

Use Microsoft .NET Framework in Windows PowerShell.
Use REST API in Windows PowerShell.

Module 3: Writing controller scriptsThis module explains how to combine advanced functions that perform a specific task and a controller script that provides a user interface or automates a business process.

Lessons

Introducing controller scripts
Writing controller scripts that display a user interface
Writing controller scripts that produce reports

Lab : Writing controller scripts

Writing controller scripts that display a user interface
Writing controller scripts that implement a text-based menu

Lab : Writing controller scripts that produce HTML reports

Writing functions to be used in the controller script
Writing a controller script that produces HTML reports

After completing this module, students will be able to:

Describe controller scripts.
Write controller scripts that display a user interface.
Write controller scripts that produce reports.

Module 4: Handling script errors. This module explains how to perform basic error handling in scripts. Lessons

Understanding error handling
Handling errors and timeouts in a script

Lab : Handling errors in a script

Handling errors in a script

After completing this module, students will be able to:

Describe error handling.
Handle errors and timeouts in a script.

Module 5: Using XML, JSON, and custom-formatted data. This module explains how to read, manipulate, and write data in XML and JSON format.

Lessons

Reading, manipulating, and writing XML-formatted data
Reading, manipulating, and writing JSON-formatted data
Reading and manipulating custom-formatted data

Lab : Reading, manipulating, and writing XML-formatted data

Testing the provided tools
Updating an XML inventory document

After completing this module, students will be able to:

Read, manipulate, and write XML-formatted data.
Read, manipulate, and write JSON-formatted data.
Read and manipulate custom-formatted data.

Module 6: Enhancing server management with Desired State Configuration and Just Enough Administration. This module explains how to write Desired State Configuration (DSC) configuration files, deploy those files to servers, and monitor servers’ configurations. This module also explains how to restrict administrative access with Just Enough Administration (JEA).

Lessons

Understanding Desired State Configuration
Creating and deploying a DSC configuration
Implementing Just Enough Administration

Lab : Creating and deploying a DSC configuration

Creating and deploying a DSC configuration

Lab : Configuring and using JEA

Configuring and using JEA

After completing this module, students will be able to:

Understand DSC.
Create and deploy a DSC configuration.
Implement JEA.

Module 7: Analyzing and debugging scripts This module explains how to use native Windows PowerShell features to analyze and debug existing scripts. Lessons

Debugging in Windows PowerShell
Analyzing and debugging an existing script

Lab : Analyzing and debugging an existing script

Analyzing and debugging an existing script

After completing this module, students will be able to:

Debug in Windows PowerShell.
Analyze and debug an existing script.

Module 8: Understanding Windows PowerShell Workflow This module explains the features of the Windows PowerShell Workflow technology. Lessons

Understanding Windows PowerShell Workflow

Lab : Creating and running a Windows PowerShell Workflow

Creating and running a Windows PowerShell Workflow

After completing this course, students will be able to:

Describe the functionality of Windows PowerShell and use it to run and find basic commands.
Identify and run cmdlets for server administration.
Work with Windows PowerShell pipeline.
Describe the techniques Windows PowerShell pipeline uses.
Use PSProviders and PSDrives to work with other forms of storage.
Query system information by using WMI and CIM.
Work with variables, arrays, and hash tables.
Write basic scripts in Windows PowerShell.
Write advanced scripts in Windows PowerShell.
Administer remote computers.
Use background jobs and scheduled jobs.
Use advanced Windows PowerShell techniques.
Create advanced functions.
Use Microsoft .NET Framework and REST API in Windows PowerShell.
Write controller scripts.
Handle script errors.
Use XML, JSON, and custom formatted data.
Enhance server management with Desired State Configuration and Just Enough Administration.
Analyse and debug scripts
Understand Windows PowerShell workflow.

This course do not have official certification

Participanţi

Cursul este recomandat celor care doresc să utilizeze tehnicile VBA la nivel avansat din Excel, precum și comenzi VBA din alte programe Office.

Cunoştinţe şi abilităţi iniţiale

Participarea la acest curs presupune parcurgerea cursului de Macro-uri și VBA în Excel sau cunoștințe similare.

Prezentarea cursului

Cursul are durata de 24 de ore şi se desfăşoară după modelul interactiv, cu modele si studii de caz aplicabile în activitatea curentă a unei companii.

Cursul abordează următoarele teme:

Interacțiunea cu alte aplicații Office

Automatizarea lucrului cu Microsoft Outlook din Excel

Utilizarea obiectelor din Outlook
Trimiterea mesajelor din Excel
Adăugarea de evenimente dintr-o listă Excel în Calendar
Adăugarea de task-uri din Excel

Automatizarea lucrului cu Microsoft PowerPoint din Excel

Utilizarea obiectelor din PowerPoint
Automatizarea creării unei prezentări PowerPoint din VBA (slide-uri, text, grafice, date)

Interacțiunea cu pagini Web

Aducerea datelor din paginile Web în Excel
Completarea automată a paginilor Web cu date din Excel

Importul datelor din fișiere externe în Excel

Importul din fișiere text, csv
Importul dintr-o bază de date

Dezvoltarea aplicațiilor Excel

Crearea și utilizarea Add-Ins
Crearea unui ribbon particularizat

Abilităţi ce vor fi dobândite

Participanţii îşi vor însuşi cunoştinţele avansate de lucru cu programarea VBA pentru Excel.

Certified Agile Service Manager (CASM)

Duration: 2 Days Course

Code: GKCASM

Overview:
This course provides an introduction to Agile Service Management, the application, and integration of agile thinking into service management
processes and process design projects. Agile thinking improves IT’s effectiveness and efficiency and enables IT to continue to deliver value in
the face of changing requirements.
As Dev and Ops have been working in parallel with Dev focused on Agile/Scrum and Ops focused on ITSM/ITIL, this course strives to bring
together individual achievements to deliver full business value. The course cross-pollinates Agile and ITSM practices to support end-to-end
Agile Service Management so Dev starts to manage services instead of products and Ops and ITSM become more agile by scaling to “just
enough” process leading to improved flow of work and time to value.
Agile Service Management helps IT to meet customer requirements faster, improve the collaboration between Dev and Ops, overcome
constraints in process workflows by taking an iterative approach to process design that will improve the velocity of process improvement teams
to get more done.
This course positions learners to successfully complete the Certified Agile Service Manager exam.

Target Audience:
The target audience for the CASM course is
- Anyone interested in learning about Agile and Scrum from a products and process perspective
- Process owners and process designers
- Developers who are interested in helping make processes more agile
- Managers who are looking to bridge multiple practices into a DevOps environment
- Employees and managers responsible for designing, re-engineering or improving process
- Consultants guiding their clients through process improvement and DevOps initiatives
- Internal and external suppliers Process stakeholders

Objectives:
COURSE OBJECTIVES

Agile thinking and values into service management
The learning objectives for Certified Agile Service Manager Scrum roles, artifacts, and events as it applies to both products and
(CASM) include an understanding of: processes
What does it mean to “be agile?” The two aspects of Agile Service Management:
The Agile Manifesto, its core values, and principles Agile Process Improvement–ensuring processes are lean and
deliver “just enough” control
Agile concepts and practices including ITSM, Kanban, Lean and
DevOps Agile Process Design–applying Agile practices to process design
projects
Learn about SCRUM from a product and process perspective

Prerequisites:
Completion of pre-class assignment
Familiarity with IT service management processes and ITIL is
recommended

Agile Project Management - Foundation and Practitioner

Duration: 5 Days Course

Code: AGILEPMFP

Overview:
Agile approaches such as eXtreme Programming, Scrum and Lean Software Development are becoming increasingly mainstream. They
describe how to successfully deliver in complex situations when requirements and possible solutions are subject to continuous change; but
they stop short of describing a full project lifecycle with defined Phases, Work Products, Roles and Responsibilities. This course covers how to
operate in such an agile fashion within an overall project framework which is accredited as a stable-mate to PRINCE2 and based on the DSDM
Agile Project Framework (DSDM APF) approach. Through practical experience of the agile style of working, case studies and example
scenarios from a highly experienced trainer, it provides delegates with an understanding of how the Agile Project Management process can
enable planning, management and control for predictable Agile project deliveries.

Target Audience:
The course is aimed at Project Managers and others involved in Project Management who want to understand how to apply agile approaches
within an overall project management lifecycle framework.

Testing and Certification:

Agile Project Management Foundation exam
Simple multiple choice exam – 40-minute exam
50 questions, pass mark is 25 (50%)
Taken at the end of Day 2 of training
Agile Project Management Practitioner exam
Complex multiple choice – Objective Test – 2.5-hour exam
Open book exam (reference to Agile PM Handbook allowed)
Four questions worth 20 marks each (80 marks), pass mark is 40
(50%)
Pre-requisite for Agile PM Practitioner:
Agile Project Management Foundation (or DSDM Astern
Foundation) certificate
DSDM Advanced Practitioner certificate
Taken at the end of Day 5 of training

Management of Risk

Duration: 5 Days Course

Code: MOR

Overview:
This 5 day course is designed to provide a coherent and logical solution to the problem of implementing a risk management framework within
an organisation. It is designed to be adjustable to allow you to tailor your approach to risk according to your organisations's needs.
There is a significant quantity of homework to be completed during the course so delegates are advised to make allowances for this in their
plans for the week.

Target Audience:
Risk forms a part of the everyday running of any business or organisation, therefore, the study of its anticipation and management is relevant
for all individuals and organisations wishing to develop their awareness in this area.

Objectives:
Upon completion of this course, delegates will have a greater Better management at all levels through improved decision making
understanding of the advantages of risk management within an
organisation, such as: Reduced waste and fraud, and better value for money
Increased certainty and fewer surprises Innovation
Better service delivery Management of contingent and maintenance activities.
More effective management of change
More efficient use of resources

Prerequisites:

Delegates are required to meet the following pre-requisites: There are no official Pre-Requisites for this course.

Testing and Certification

This course prepares delegates for the following exam(s): The M_o_R ® Foundation Exam is taken on Day Three, and the
M_o_R® Practitioner Exam is taken on Day Five of this course.

Exams are included in the course fee.

Proiect cofinanţat din Fondul Social European prin Programul Operaţional Sectorial Dezvoltarea Resurselor Umane 2007-2013 - Investeşte în oameni! Axa prioritară 2 „Corelarea învăţării pe tot parcursul vieţii cu piaţa muncii” / Domeniul major de intervenţie 2.3 „Acces şi participare la formare profesională continuă”, contract POSDRU/164/2.3/S/134528.