Accessing SQL Server Databases from Windows PowerShell
Course info



Course info



Description
PowerShell is an awesome tool, and as an IT pro or a Developer you probably want to use its powerful automation potential to automate your own tasks. SQL Server is the database software of choice for organizations running in the Microsoft ecosystem. Instead of storing information from your PowerShell scripts in CSV or text files, you can store this information into a SQL Database and then use SQL Server's powerful reporting tools to create beautiful looking reports and historical data. In this course, Accessing SQL Server Databases from Windows PowerShell, you'll learn how to use PowerShell to read and write data from/to a SQL Server database. First, you'll discover how to get the required PowerShell Module and how to connect to both a local and a remote SQL Server. Next, you'll explore how to use PowerShell to read data from a SQL Table. Finally, you'll learn how to use PowerShell to write information to an existing, or a brand-new SQL database. When you're finished with this course, you'll have the skills and knowledge of PowerShell needed to access SQL Server databases from PowerShell.
Section Introduction Transcripts
Course Overview
[Autogenerated] Hi, everyone. My name is Lad Cap UNESCO and welcome to my course, accessing SQL Server databases from PowerShell. I'm a Microsoft M v P and independent consultant from Montreal, Canada. Whether you're looking to store data or to create important historical and trend reports in PowerShell, SQL is probably one of the best locations to save your information. In this course, you will learn how to use PowerShell to read and write data from or to a SQL Server database. Some of the major topics that will cover include connecting to a local or remote SQL Server, reading data from a SQL database and writing data to a SQL Server database. By the end of this course, you will be able to use PowerShell to read or write information to a SQL Server database before beginning discourse. You should be familiar with the basics of PowerShell as well as the basics of SQL Server. From here, you should feel comfortable diving in to other PowerShell topics. Week courses such as working with CSV data in PowerShell, working with XML data in PowerShell and reporting with partial HTML and enhanced HTML. I hope you'll join me on this journey to learn PowerShell with the accessing SQL Server databases from PowerShell course at Pluralsight. Yeah,