Automating Scripting PowerShell Trainings

PowerShell, a widely used tool automation language of the Microsoft ecosystem

PowerShell is Microsoft’s flagship scripting language and automation shell, designed to pilot and automate the full Microsoft stack: Windows Server, Active Directory, Microsoft 365, Azure, SQL Server, SharePoint, Exchange, as well as third-party products (VMware, Citrix, AWS, etc.) via their modules. The language now comes in two versions: Windows PowerShell 5.1 (historically integrated into Windows) and PowerShell 7 (cross-platform, based on .NET, recommended for new scripts). PowerShell has become an essential standard for systems administrators, Microsoft 365 engineers, Azure engineers, SQL Server DBAs and DevOps profiles working on Microsoft environments.

Beyond the interactive shell, PowerShell industrialises administration via advanced scripting: functions, modules, pipelines, structured error handling, parameter binding, input validation, advanced functions, comment-based help, and toolmaking. Toolmaking means producing reusable tools (custom cmdlets, signed modules, internal PowerShell Gallery repos) that IT teams can share and evolve. Governance modules include Desired State Configuration (DSC) for declarative server configuration, Azure Automation for cloud orchestration, and the SQL Server module (SqlServer) for database administration and auditing. The AZ-040 (Automating Administration with PowerShell) ecosystem is the Microsoft reference certification validating these skills.

In French-speaking Switzerland, automation through PowerShell is expected in most systems administrator, Microsoft 365 engineer, Azure engineer, SQL Server DBA, DevOps engineer and infrastructure consultant job descriptions. Geneva private banks, Lake Geneva international organisations, fiduciary firms, cantonal administrations, university hospitals, insurance and industrial companies use PowerShell to automate Microsoft 365 user provisioning, Exchange mailbox creation, Azure deployment, Active Directory auditing, SQL Server backups, and repetitive IT tasks. ITTA offers a training catalogue professionals.

Following recognised PowerShell training opens access to highly demanded skills: Active Directory automation, Microsoft 365 and Exchange automation, Azure automation, DSC and server configuration, SQL Server integration, automated monitoring and reporting, governance of internal scripts. Whether you start in scripting or structure PowerShell toolsets shared at enterprise scale, our PowerShell training in Geneva and Lausanne covers the full path.

The ITTA PowerShell Automation catalogue

Windows PowerShell Scripting and Toolmaking (55039)

The Windows PowerShell Scripting and Toolmaking (55039) training is the official Microsoft 55039 course, dedicated to advanced PowerShell scripting and toolmaking. The programme covers language basics (cmdlets, pipeline, variables, types), control structures, functions and advanced functions, parameter binding and validation, structured error handling (try/catch, ErrorActionPreference), PowerShell modules, toolmaking best practices, custom cmdlet creation, script signing, packaging, and internal sharing best practices via PowerShell Gallery or private repos. The training targets systems administrators, Microsoft 365 and Azure engineers, DevOps profiles and anyone regularly producing automation scripts.

PowerShell for SQL Server Administrators (55069)

The PowerShell for SQL Server Administrators (55069) training is the official Microsoft 55069 course, dedicated to SQL Server automation with PowerShell. The programme addresses the SqlServer module, database manipulations (creation, backup, restore, attach/detach), instance and permission auditing, automation of recurring DBA operations, integration with SQL Agent, instance health report production, T-SQL script deployment management via PowerShell, and multi-instance task orchestration. The training targets SQL Server DBAs, data engineers and all profiles administering a SQL Server fleet at scale.

DSC and declarative configuration

Desired State Configuration (DSC) is the PowerShell extension allowing description of a server’s desired state (roles, services, configuration) in declarative form, and letting PowerShell apply and maintain that state over time. DSC is used to standardise Windows server builds in production, in banking, hospital or cantonal environments. DSC best practices are addressed in the 55039 training and complemented in our Azure Automation training.

Azure Automation and hybrid cloud

On the cloud side, Azure Automation enables running PowerShell runbooks in Azure to orchestrate cloud operations (provisioning, scaling, patching, governance). PowerShell 7 is cross-platform and also runs on Linux, which opens the way to Windows/Linux hybrid DevOps scenarios. The AZ-040 (Automating Administration with PowerShell) certification validates these skills and is referenced in the Microsoft Azure sub-publisher of our catalogue.

Building your PowerShell path

For administrators starting in PowerShell, the 55039 (Scripting and Toolmaking) training is the fundamental entry point. For SQL Server DBAs wanting to industrialise their operations, the 55069 training is dedicated. For cloud profiles, AZ-040 (Microsoft Azure sub-publisher) extends the path on the Azure Automation side. Our pedagogical team guides you according to your role (sysadmin, cloud engineer, DBA, DevOps engineer).

Featured courses in this catalogue

Here is a selection of reference training courses in this catalogue, accessible directly:

• Windows PowerShell Scripting and Toolmaking (55039)
• PowerShell for SQL Server Administrators (55069)

PowerShell Automation and the publisher ecosystem at ITTA

PowerShell Automation fits into the complete Microsoft ecosystem. The root Microsoft publisher regroups all Microsoft technologies. The sub-publisher Microsoft Azure covers AZ-040 (Automating Administration with PowerShell) and Azure Automation runbooks. On the cross-publisher side, Ansible is the other cross-cutting automation language widely used in French-speaking Switzerland, complementary to PowerShell in Windows/Linux hybrid environments. Our pedagogical team builds you a coherent path according to your target.

PowerShell trends in 2026

PowerShell evolves with several structuring axes in 2026. PowerShell 7 (cross-platform, based on .NET) establishes itself as the target version for new developments, coexisting with Windows PowerShell 5.1 for legacy. Microsoft 365 automation (Microsoft.Graph, ExchangeOnlineManagement, MicrosoftTeams modules) becomes a standard for M365 admin teams. Azure Automation and Azure Functions PowerShell are regularly used to orchestrate the cloud. Script security (mandatory signing, restricted execution, Just Enough Administration JEA) is increasingly framed. DevOps best practices (Git versioning, Pester tests, CI/CD) are expected on the toolmaking side. Our pedagogical content regularly integrates these evolutions to remain aligned with current practices.

PowerShell training in Geneva, Lausanne and online

All our PowerShell courses are available on-site in our Geneva and Lausanne centres, as well as in interactive virtual classroom with a certified trainers live. Our sessions are organised in 5-week cycles. Each session includes hands-on labs on PowerShell 7 and Windows PowerShell, Active Directory administration scripts to write, functions and modules to build, custom cmdlets to package, SQL Server manipulations (backup, restore, audit), and concrete cases inspired by automation projects in banking, administration and industry. Customised corporate training is also possible at your premises, in Geneva, Lausanne, Vaud and across French-speaking Switzerland, with a programme adapted to your IS (Microsoft 365, Azure, SQL Server, on-premises AD).

Why choose ITTA

ITTA offers a training catalogue. Our PowerShell trainers are certified systems administrators, Microsoft 365 engineers, Azure engineers and SQL Server DBAs active with Swiss and international clients, covering PowerShell 7, Windows PowerShell 5.1, toolmaking, DSC, Azure Automation, SQL Server integration and AZ-040. The PowerShell Automation catalogue regroups 55039 and 55069. Our pedagogical team supports you in choosing the path, identifying prerequisites (Windows administration, basic programming notions, technical English reading) and identifying funding solutions adapted to your professional situation.

Our pedagogical approach favours learning by doing, with scripts to write from the first hours, functions to build, modules to package, concrete Active Directory, Microsoft 365, Exchange, SQL Server and Azure automation cases, and red-thread projects inspired by real needs (account provisioning, permission audit, instance health report). Each session combines training time, applied exercises and exchanges with the trainer, allowing each participant to progress at their own pace and leave with skills directly usable in their professional context.

Our training is aimed at varied audiences: systems administrators, Microsoft 365 engineers, Azure engineers, SQL Server DBAs, DevOps engineers, infrastructure consultants, security profiles automating audit, IT teams industrialising operations. Our pedagogical team adapts the content to the participants’ context.

FAQ

Does PowerShell 7 replace Windows PowerShell 5.1?

PowerShell 7 is the target version for new developments. Windows PowerShell 5.1 remains installed by default on Windows for historical compatibility reasons and is used by some legacy modules. In practice, many organisations in French-speaking Switzerland use both in parallel. The 55039 training covers both versions and migration best practices. Our pedagogical team helps you size your strategy.

Do I need to know programming to follow PowerShell Scripting and Toolmaking?

Windows administration habits and algorithmic logic notions greatly facilitate the training. PowerShell is deliberately accessible to systems administrators without development experience, but toolmaking (creating modules, advanced functions) requires structuring code like a developer. Our pedagogical team checks your prerequisites and adapts the pace.

Is the AZ-040 Azure training complementary to 55039?

Yes, AZ-040 (Automating Administration with PowerShell) is the official Microsoft certification validating Azure and hybrid automation with PowerShell. It relies on scripting fundamentals covered by 55039 and adds the Azure Automation, runbooks, Az.* modules and cloud orchestration dimension. AZ-040 is referenced in the Microsoft Azure sub-publisher of our catalogue.

Are your PowerShell courses available for companies?

Yes, the full PowerShell Automation catalogue is available in-house, in Geneva, Lausanne and in virtual classroom, with a programme adapted to your IS (Microsoft 365, Azure, SQL Server, on-premises AD, third-party integrations) and your constraints (script security, JEA, signing, GDPR/nFADP compliance). Our team builds the specifications with you and organises sessions according to your calendar.