SQL Administration

Session Detail:    Classroom 1 Day

This one day lab-intensive course is targeted to Database Professionals who want to explore using PowerShell to administrate SQL Server. Here you will learn the power of PowerShell for writing reusable code, database tasks, customizing the environment, database development, monitoring and automation and much more.

Prerequisites

Six months experience using Powershell

Who Can Benefit

This course is intended for SQL Administrators and SQL Developers.

Session Outline

Class Outline

Module 1: Course Overview

  • Lesson 1: Introduction
  • Lesson 2: Course Materials
  • Lesson 3: Facilities
  • Lesson 4: Prerequisites
  • Lesson 5: What We’ll Be Discussing

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

  • Lesson 1: Examining Modules and Installing the SQLPS Module
  • Lesson 2: Examining SQL Server Cmdlets
  • Lesson 3: Discussing SQL Server Management Objects (SMO)
  • Lesson 4: Recent Updates July 2016

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

  • Lesson 1: Examining SQL Information Retrieval
  • Lesson 2: Exploring Logins
  • Lesson 3: Adding Files and File groups
  • Lesson 4: Detach and Attach Databases
  • Lesson 5: Understanding Backup and Restore
  • Lesson 6: Examining 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 file groups
  • 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

  • Lesson 1: Exploring Cmdlets
  • Lesson 2: Discussing Scheduling
  • Lesson 3: Understanding Performance Metrics

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

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

After completing this module, students will be able to:

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

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

SQL Administration

1 Day
Classroom

$295.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now