Microsoft PowerShell

 

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

EXCEL VBA – nivel avansat

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.

 

Proiectul “PRIN CALIFICARE ÎN PAS CU PIAȚA MUNCII”

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.

Proiectul "Dezvoltarea şi optimizarea activităţilor companiei S.C. ETA2U S.R.L. prin implementarea unui sistem informatic de business 2 business" - SMIS 46884

Proiectul "Creșterea eficienței economice a S.C. ETA2U S.R.L. prin extinderea unui sistem ERP"

SABER - Satellite Broadband for European Regions

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

 

 

 

Acest site folosește cookie-uri. Navigând în continuare, îți exprimi acordul asupra folosirii cookie-urilor. Mai multe detalii