Cisco Training Courses

Insoft has been serving IT community with official Cisco training offering since 2010. Find all the relevant information on Cisco training on this page.

View More

Cisco Certifications

Experience a blended learning approach that combines the best of instructor-led training and self-paced e-learning to help you prepare for your certification exam.

View More

Cisco Learning Credits

Cisco Learning Credits (CLCs) are prepaid training vouchers redeemed directly with Cisco that make planning for your success easier when purchasing Cisco products and services.

Have CLCs and want to redeem them?

Cisco Continuing Education

The Cisco Continuing Education Program offers all active certification holders flexible options to recertify by completing a variety of eligible training items.

View More

Cisco Digital Learning

Certified employees are VALUED assets. Explore Cisco official Digital Learning Library to educate yourself through recorded sessions.

Browse CDLL Catalogue

Cisco Business Enablement

The Cisco Business Enablement Partner Program focuses on sharpening the business skills of Cisco Channel Partners and customers.

View More

Fortinet Technical Certifications

The Fortinet Network Security Expert (NSE) program is an eight-level training and certification program to teach engineers of their network security for Fortinet FW skills and experience.

View More

Fortinet Technical Courses

Insoft is recognised as Fortinet Authorized Training Center in selected locations across EMEA.

View More

Official ATC Status

Check our ATC Status across selected countries in Europe.

View More

Fortinet Services Packages

Insoft Services has developed a specific solution to streamline and simplify the process of installing or migrating to Fortinet Products.

Browse Packages

Prepforce Bootcamp

The only comprehensive source available today to prepare for Fortinet NSE 8 certification globally.

View More

Microsoft Training

Insoft Services provides Microsoft training in EMEAR. We offer Microsoft technical training and certification courses that are led by world-class instructors.

View More

Technical Training

The evolution of Extreme Networks Technical Training provides a comprehensive progressive pathway from Associate to Professional accreditation.

View More

ATP Accreditation

As an authorised training partner (ATP), Insoft Services ensures that you receive the highest standards of education available.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

Our Mission: Provide an expert set of modern & leading edge Network Automation skills to the market through professional services.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

We help organisations to deploy Software-Defined Networking (SDN) solutions, such as Cisco DNA. Besides, our team has extensive experience in integrating Cisco DNA Center with third-party systems.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

About Us

Our training portfolio includes a wide range of IT training from IP providers, including Cisco, Extreme Networks, Fortinet, Microsoft, to name a few, in EMEA.

View More

PowerShell for SQL Administration

X

Contact Us

We would love to hear from you. Please complete this form to pre-book or request further information about our delivery options.

Subscribe

I'd like to receive emails with the latest updates and promotions from Insoft.

Data Protection & Privacy

I hereby allow Insoft Ltd. to contact me on this topic. Further, I authorise Insoft Ltd. processing, using collecting and storing my personal data for the purpose of these activities. All your data will be protected and secured as outlined in our privacy policy.


PowerShell for SQL Administration

Enroll Now
PowerShell for SQL Administration
Duration
1 Days
Delivery
(Online and onsite)
Price
Price Upon Request

This course is intended for SQL administrators with little or basic knowledge of PowerShell. The course centers on SQL administrative tasks that are commonly used, and provides the basic understanding needed for administrators to utilize the expanding PowerShell SQL interoperations.

TThe course concludes with a copy of course 752552 PowerShell 5.0 Basics.

  • Examine and install modules.
  • Examine and understand SQL Server Cmdlets.
  • Understand SQL Server Management Objects (SMO).
  • Understand recent updates.
  • 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.
  • Explore available cmdlets.
  • Understand scheduling options.
  • Understand options for tracking performance metrics.
  • Understand and utilize SSAS.
  • Understand and utilize SSIS.
  • Understand and utilize SSRS.
  • Understand the evolution of PowerShell.
  • Understand and utilize the PowerShell environment.
  • Understand and utilize the all-important Help System.
  • Understand and utilize PowerShell.
  • Understand and utilize working with the file system.
  • Understand and utilize parameters.
  • Understand and utilize user-defined variables.
  • Understand and utilize arrays.
  • Understand and utilize hash tables.
  • Understand and execute cmdlets.
  • Understand and utilize the pipeline.
  • Understand how to control the output with formatting.
  • Understand background jobs.
  • Understand aliases.
  • Understand and utilize loops.
  • Understand and utilize While loops.
  • Understand and utilize Do While loops.
  • Understand and utilize Do Until loops.
  • Understand and utilize For loops.
  • Understand and utilize ForEach loops.
  • Understand altering loop execution.
  • Understand and utilize scripting.
  • Understand functions and filters.
  • Understand the basics of script design.
  • Understand scripting pitfalls.

Module 1: Course Overview

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We’ll Be Discussing

Lab 1: Course Overview

  • None

After completing this module, students will be able to:

  • Successfully log into their virtual machine.
  • Have a full understanding of what the course intends to cover.

 

Module 2: PowerShell and SQL

In this module, we will be discussing SQL Server Cmdlets and SQL Server Management Objects. In addition, we will look at modules and the process to install the SQLPS Module.

Lessons

  • Examining Modules and Installing the SQLPS Module
  • Examining SQL Server Cmdlets
  • Discussing SQL Server Management Objects (SMO)
  • Recent Updates – July 2016

Lab 1: PowerShell and SQL

  • Installing the PowerShell SQL Module

After completing this module, students will be able to:

  • Examine and install modules.
  • Examine and understand SQL Server Cmdlets.
  • Understand SQL Server Management Objects (SMO).
  • Understand recent updates.

 

Module 3: SQL Administration with PowerShell

In this module, we will examine ways of retrieving information pertaining to the SQL Server instance installed, and look at ways of accomplishing many other management and administrative tasks that can be quickly and efficiently tackled with PowerShell.

Lessons

  • Examining SQL Information Retrieval
  • Exploring Logins
  • Adding Files and Filegroups
  • Detach and Attach Databases
  • Understanding Backup and Restore
  • Examining Indexes

Lab 1: SQL Administration with PowerShell

  • SQL Server Instances
  • Databases
  • Tables
  • Processes
  • Features
  • Jobs
  • Logins
  • Files and FileGroups
  • Detach and Attach Databases
  • Backup and Restore
  • Indexes

After completing this module, students will be able to:

  • 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.

 

Module 4: Monitoring and Automation

In this module, we will examine a handful of helpful cmdlets, discuss options for scheduling, and explore ways to track performance metrics.

Lessons

  • Exploring Cmdlets
  • Discussing Scheduling
  • Understanding Performance Metrics

Lab 1: Monitoring and Automation

  • None

After completing this module, students will be able to:

  • Explore available cmdlets.
  • Understand scheduling options.
  • Understand options for tracking performance metrics.

 

Module 5: SSAS, SSIS, AND SSRS Optional Module

In this module, we will examine ways of working with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS). This module is not meant to be an exhaustive reference but instead is intended to give you a brief look at the capabilities built into the system and encourage you to further explore ways of managing your SQL Server environment using PowerShell.

Lessons

  • Examining SQL Server Analysis Services (SSAS)
  • Exploring SQL Server Integration Services (SSIS)
  • Utilizing SQL Server Reporting Services (SSRS)

Lab 1: SSAS, SSIS, AND SSRS

  • SSAS
  • SSIS
  • SSRS

After completing this module, students will be able to:

  • Understand and utilize SSAS.
  • Understand and utilize SSIS.
  • Understand and utilize SSRS.

This course is intended for SQL Administrators and SQL Developers.

  • Six months experience using Powershell

This course is intended for SQL administrators with little or basic knowledge of PowerShell. The course centers on SQL administrative tasks that are commonly used, and provides the basic understanding needed for administrators to utilize the expanding PowerShell SQL interoperations.

TThe course concludes with a copy of course 752552 PowerShell 5.0 Basics.

  • Examine and install modules.
  • Examine and understand SQL Server Cmdlets.
  • Understand SQL Server Management Objects (SMO).
  • Understand recent updates.
  • 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.
  • Explore available cmdlets.
  • Understand scheduling options.
  • Understand options for tracking performance metrics.
  • Understand and utilize SSAS.
  • Understand and utilize SSIS.
  • Understand and utilize SSRS.
  • Understand the evolution of PowerShell.
  • Understand and utilize the PowerShell environment.
  • Understand and utilize the all-important Help System.
  • Understand and utilize PowerShell.
  • Understand and utilize working with the file system.
  • Understand and utilize parameters.
  • Understand and utilize user-defined variables.
  • Understand and utilize arrays.
  • Understand and utilize hash tables.
  • Understand and execute cmdlets.
  • Understand and utilize the pipeline.
  • Understand how to control the output with formatting.
  • Understand background jobs.
  • Understand aliases.
  • Understand and utilize loops.
  • Understand and utilize While loops.
  • Understand and utilize Do While loops.
  • Understand and utilize Do Until loops.
  • Understand and utilize For loops.
  • Understand and utilize ForEach loops.
  • Understand altering loop execution.
  • Understand and utilize scripting.
  • Understand functions and filters.
  • Understand the basics of script design.
  • Understand scripting pitfalls.

Module 1: Course Overview

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We’ll Be Discussing

Lab 1: Course Overview

  • None

After completing this module, students will be able to:

  • Successfully log into their virtual machine.
  • Have a full understanding of what the course intends to cover.

 

Module 2: PowerShell and SQL

In this module, we will be discussing SQL Server Cmdlets and SQL Server Management Objects. In addition, we will look at modules and the process to install the SQLPS Module.

Lessons

  • Examining Modules and Installing the SQLPS Module
  • Examining SQL Server Cmdlets
  • Discussing SQL Server Management Objects (SMO)
  • Recent Updates – July 2016

Lab 1: PowerShell and SQL

  • Installing the PowerShell SQL Module

After completing this module, students will be able to:

  • Examine and install modules.
  • Examine and understand SQL Server Cmdlets.
  • Understand SQL Server Management Objects (SMO).
  • Understand recent updates.

 

Module 3: SQL Administration with PowerShell

In this module, we will examine ways of retrieving information pertaining to the SQL Server instance installed, and look at ways of accomplishing many other management and administrative tasks that can be quickly and efficiently tackled with PowerShell.

Lessons

  • Examining SQL Information Retrieval
  • Exploring Logins
  • Adding Files and Filegroups
  • Detach and Attach Databases
  • Understanding Backup and Restore
  • Examining Indexes

Lab 1: SQL Administration with PowerShell

  • SQL Server Instances
  • Databases
  • Tables
  • Processes
  • Features
  • Jobs
  • Logins
  • Files and FileGroups
  • Detach and Attach Databases
  • Backup and Restore
  • Indexes

After completing this module, students will be able to:

  • 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.

 

Module 4: Monitoring and Automation

In this module, we will examine a handful of helpful cmdlets, discuss options for scheduling, and explore ways to track performance metrics.

Lessons

  • Exploring Cmdlets
  • Discussing Scheduling
  • Understanding Performance Metrics

Lab 1: Monitoring and Automation

  • None

After completing this module, students will be able to:

  • Explore available cmdlets.
  • Understand scheduling options.
  • Understand options for tracking performance metrics.

 

Module 5: SSAS, SSIS, AND SSRS Optional Module

In this module, we will examine ways of working with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS). This module is not meant to be an exhaustive reference but instead is intended to give you a brief look at the capabilities built into the system and encourage you to further explore ways of managing your SQL Server environment using PowerShell.

Lessons

  • Examining SQL Server Analysis Services (SSAS)
  • Exploring SQL Server Integration Services (SSIS)
  • Utilizing SQL Server Reporting Services (SSRS)

Lab 1: SSAS, SSIS, AND SSRS

  • SSAS
  • SSIS
  • SSRS

After completing this module, students will be able to:

  • Understand and utilize SSAS.
  • Understand and utilize SSIS.
  • Understand and utilize SSRS.

This course is intended for SQL Administrators and SQL Developers.

  • Six months experience using Powershell
    Upcoming Dates
  • ` Feb 13 2023
  • ` Mar 13 2023
  • ` Apr 10 2023
  • ` May 8 2023
  • ` Jun 5 2023
  • ` Jul 3 2023