Pro PowerShell for Database Developers

Pro PowerShell for Database Developers is a deep dive into professional application development using Windows PowerShell. Developers of database-backed applications will find no better title to help them learn and apply Microsoft’s powerful scripting toolset in a database or enterprise environment. You’ll learn to use PowerShell as a full-fledged development platform on which to build client-facing applications, and as an ETL platform. Many practical examples are covered that can be pulled out and applied immediately to solve real world problems.

Chapters progressively move from the basics of the environment through to writing simple scripts and ultimately on to writing full-fledged, GUI-based applications in PowerShell. A highlight of the book is its extensive coverage on using PowerShell as an ETL platform. Glue together the components in an ETL workflow. Implement an ETL workflow entirely within PowerShell. Connect to disparate data sources such as SQL Server, Oracle Database (via ADO.NET), Microsoft Access, Microsoft Excel, and more.

PowerShell is great for scripting repetitive tasks. It’s also excellent for lightweight application development. Pro PowerShell for Database Developers helps you create standalone applications such as you might use for in-house deployment of utility applications and table maintenance applications. The book shows how to create graphical user interfaces from PowerShell using Windows Forms. You’ll even learn to turbocharge your applications through parallelism and multi-threading done through Windows Workflow.

• Examines PowerShell as a development language, going over the pros and cons while delving into the unique features available and the limitations you need to be aware of.
• Progressively expands your knowledge of PowerShell through numerous examples of applying PowerShell to accomplish commonly-required tasks.
• Covers technically deep functionality such as multi-threading, interfacing with SQL Server and other databases, and using Windows Forms to run a GUI.