Maintaining SQL Server using PowerShell

Course:   PSSQLS
Duration:   3 Days
Level:   II
On our website at:
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.

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:

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.

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.