Overview
This two-day course equips participants with the required knowledge and skills essential for successfully using PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012. The course also helps participants understand how to manage the daily and the scheduled maintenance tasks. The course chiefly focuses on the administration of the database engine, including optional exercises on Analysis Services (SSAS) and Integration Services (SSIS). Participants of this course would need to have experience administering SQL Servers and using PowerShell.
What You'll Learn
- Install and configure SQL Server and all its components using PowerShell
- Manage day-to-day and SQL Server administration with PowerShell
- Maintain the SQL Server environment using PowerShell scripting and programming options
Curriculum
- Module Objectives
- Install SQL Server
- Configure Database Settings
- Configure SQL Server Settings
- Configure SQL Server Policy-Based Management
- Review
- Lab: Configuring SQL Server with PowerShell
- Module Objectives
- Managing Users and Roles
- Managing Database Performance
- Managing Database Availability
- Managing SQL Server Features
- Review
- Lab: Administering SQL Servers with PowerShell
- Module Objectives
- Managing Backups and Restores
- Maintaining Database Integrity and Performance
- Monitoring and Auditing
- Task Automation
- Generating Reports
- Review
- Lab: Maintaining SQL Servers with PowerShell
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
