Maintaining SQL Server using PowerShell
Course: PSSQLS
Duration: 3 Days
Level: II
On our website at:
http://www.verhoef-training.com/courses/PSSQLS.html
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:
- 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.
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.
