| 1.Course Overview | |||
| 01.Course Overview.mp4 | 3.83 MB | ||
| 2.Course Introduction | |||
| 02.Introduction to SQL and the Course.mp4 | 7.03 MB | ||
| 3.Connecting to SQL Server | |||
| 03.Module Introduction.mp4 | 1.05 MB | ||
| 04.Getting the SQL Server PowerShell Module.mp4 | 19.92 MB | ||
| 05.Connecting to a Local SQL Server.mp4 | 5.36 MB | ||
| 06.Connecting to a Remote SQL Server.mp4 | 12.69 MB | ||
| 07.Encrypting Credentials.mp4 | 13.33 MB | ||
| 08.Conclusion.mp4 | 1.92 MB | ||
| 4.Reading Data from a SQL Database | |||
| 09.Module Introduction.mp4 | 1.5 MB | ||
| 10.The Basics of Reading Data.mp4 | 10 MB | ||
| 11.Filtering and Views.mp4 | 15.66 MB | ||
| 12.Conclusion.mp4 | 1.03 MB | ||
| 5.Writing Information into a SQL Database | |||
| 13.Module Introduction.mp4 | 1.47 MB | ||
| 14.The Basics of Writing Data in a SQL Database.mp4 | 9.96 MB | ||
| 15.Writing Data to a New SQL Table.mp4 | 19.25 MB | ||
| 16.Conclusion.mp4 | 1.45 MB | ||
| 6.Course Conclusion | |||
| 17.Course Conclusion.mp4 | 8.68 MB |
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 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
All Comments