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.

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.

•   Despre proiect
•   Descriere curs Operator introducere, validare si prelucrare date
•   Descriere curs Lucrator in comert
•   Conditii de participare
•   Calendar cursuri
• Statistica 2014

« Înapoi

Proiect finantat prin programul: ICT PSP sixth call for proposals 2012, Thematic Network, ICT PSP Objective (and sub-objective) identifier: 5.3 Contribution of satellite systems to 100% EU broadband coverage.

« Înapoi