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
SSADMF	Microsoft SQL Server 2008 System Administration Fundamentals	3 Days	I	Details
PSADM	Automating Windows Server 2008 Administration with Windows PowerShell	3 Days	II	Details
MSPSA	Advanced Windows Power Shell	3 Days	II	Details
MSPS	Microsoft Windows PowerShell v2 For Administrators	4 Days	II	Details

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]

Privacy Notice