Maintaining SQL Server using PowerShell

Course:  PSSQLS
Duration:  3 Days
Level:  II
Course Summary

This course addresses the basic needs of a database in a "scripting" environment. Programming tasks are covered such as storage definition, assignment, loops, and SQL Server (2005 or 2008) access via objects. DDL and DML will be the major functions covered in managing a database.

« Hide The Details
Topics Covered In This Course

Overview of Windows PowerShell

  • Interactive Shell
  • Structured Commands (Cmdlets)
  • Deep Integration of Objects
  • Composable Commands
  • Common Discovery Commands
  • Ad-Hoc Development
  • Namespace Navigation Through Providers

PowerShell Language and Environment

  • Commands and Expressions
  • Comments
  • Variables
  • Booleans
  • Strings
  • Numbers
  • Simple Operators
  • Comparison Operators
  • Conditional Statements
  • Looping Statements
  • Working with the .NET Framework
  • Writing Scripts, Reusing Functionality
  • Capturing Output
  • Tracing and Debugging

Using PowerShell

  • Regular Expression Reference
  • Automatic Variables
  • .NET Classes and Their Uses
  • WMI Reference
  • COM Objects
  • .NET String Formatting
  • String Formatting Syntax
  • Standard Numeric Format Strings
  • .NET DateTime Formatting
  • Custom DateTime Format Strings

Database Scripting

  • Understanding ActiveX Data Objects
  • Understanding Connection Objects
  • Understanding Recordset Objects
  • Understanding Command Objects
  • Understanding the Differences between Databases
  • Understanding SQL
  • Viewing ActiveX Data Objects
  • .NET objects
What You Can Expect

At the end of this course, students will be able to:

  • Understand installation options
  • Understand language syntax
  • Maintain SQL Server objects
  • Debug scripts
  • Use scripts to automate repetitive tasks
  • Work with tools for creating scripts
  • Work with various help facilities
  • Understand the various clients (Management Studio, Command Line)
  • Understand performance options
Who Should Take This Course

This course is designed for Database Administrators and Application Developers.

Training Style

Instructor led with 50% lecture and 50% lab.

« Hide The Details
Related Courses
Code Course Title Duration Level
Microsoft SQL Server 2008 System Administration Fundamentals
3 Days
Automating Windows Server 2008 Administration with Windows PowerShell
3 Days
Advanced Windows Power Shell
3 Days
Microsoft Windows PowerShell v2 For Administrators
4 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]