Overview
Targeted towards SQL administrators and SQL developers, with little to no understanding of PowerShell, this three day course discusses the common SQL administrative tasks, and helps participants understand how they can get the most out of the expanding PowerShell SQL inter-operations.
What You'll Learn
- Examine and install modules
- Examine and understand SQL Server Cmdlets and SQL Server Management Objects
- Explore available cmdlets, understand and execute them
- Understand scheduling options
- Understand options for tracking performance metrics
- Understand and utilize SSAS, SSIS and SSRS
- Understand and utilize PowerShell and the PowerShell environment
- Understand how to control the output with formatting
- Understand and utilize loops – While, Do While, Do Until, For, ForEach
- Understand and utilize scripting, and discover the scripting pitfalls
- Understand the basics of script design
Curriculum
- Introduction
- Course Materials
- Facilities
- Prerequisites
- What We’ll Be Discussing
- Lab: Course Overview
- Successfully log into their virtual machine
- Have a full understanding of what the course intends to cover
- Examining Modules and Installing the SQLPS Module
- Examining SQL Server Cmdlets
- Discussing SQL Server Management Objects (SMO)
- Recent Updates
- Lab: PowerShell and SQL
- Installing the PowerShell SQL Module
- Examine and install modules.
- Examine and understand SQL Server Cmdlets.
- Understand SQL Server Management Objects (SMO).
- Understand recent updates.
- Examining SQL Information Retrieval
- Exploring Logins
- Adding Files and Filegroups
- Detach and Attach Databases
- Understanding Backup and Restore
- Examining Indexes
- Lab: SQL Administration with PowerShell
- SQL Server Instances
- Databases
- Tables
- Processes
- Features
- Jobs
- Logins
- Files and FileGroups
- Detach and Attach Databases
- Backup and Restore
- Indexes
- Retrieve SQL Server instance information
- Understand and create logins
- Understand how to add files and filegroups
- Understand how to detach and attach databases
- Understand how to backup and restore databases
- Understand how to reorganize/rebuild indexes
- Exploring Cmdlets
- Discussing Scheduling
- Understanding Performance Metrics
- Lab: Monitoring and Automation
- Explore available cmdlets
- Understand scheduling options
- Understand options for tracking performance metrics
- Examining SQL Server Analysis Services (SSAS)
- Exploring SQL Server Integration Services (SSIS)
- Utilizing SQL Server Reporting Services (SSRS)
- Lab: SSAS, SSIS, AND SSRS
- SSAS
- SSIS
- SSRS
- Understand and utilize SSAS
- Understand and utilize SSIS
- Understand and utilize SSRS
- Utilizing PowerShell
- The Pipeline
- Processing Data with Loops
- Scripting and Functions
- Lab: PowerShell 5.0 Basics
Who should attend
Anyone interested in the paradigm shifts necessary to enable organizational agility in today’s innovative business climate will find the Business Agility Foundations course compelling. The course is highly recommended for –
- Current and aspiring business agility leaders
- Business change agents
- Business leaders
- Business managers
- Value managers
- Product owners
- Product managers
- Anyone wanting a certification in ICAgile Business Agility Foundation (ICP-BAF)
- Anyone wanting to be an ICAgile Certified Expert in Business Agility
Prerequisites
Participants need to have experience as SQL administrators or developers. Some understanding of PowerShell would be beneficial.
