Audience
This course is designed for Database Administrators and Application Developers.
Prerequisites
Delegates should have experience with SQL Server. Previous experience with PowerShell would be beneficial.
Duration
3 days.
Course Objectives
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 access via objects. DDL and DML will be the major functions covered in managing a database.
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
Course Content
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