Database Management
PowerShell 3
| Intermediate
- 14 videos | 1h 9m 32s
- Earns a Badge
PowerShell can be used to manage the full range of SQL Server management tasks. Discover how to use PowerShell to perform some of the more common management tasks for individual databases.
WHAT YOU WILL LEARN
-
Create databases in powershell
Use microsoft powershell to create a microsoft sql server login
Use microsoft powershell to change a sql database's ownership
Create a schema within a database using the powershell utility
Create, alter, and drop a stored procedure using the powershell utility
Pass your dbcc to each database using powershell
Create a schema collection using powershell -
Configure and enable database mail using powershell
Connect to an instance of sql server using authentication in powershell
Use powershell cmdlets to change an instance of sql server from integrated mode authentication to mixed mode authentication
Use powershell cmdlets to drop an object within an instance of sql server
Use powershell cmdlets to send sql server query results through an smtp email
Use powershell cmdlets to create an operator within sql server agent
Use powershell cmdlets to create error alerts for multiple errors simultaneously in sql server agent
IN THIS COURSE
-
3m 29sIn this video, you will learn how to create databases in PowerShell. FREE ACCESS
-
4m 1sLearn how to use Microsoft PowerShell to create a login for Microsoft SQL Server. FREE ACCESS
-
3. Change Database User4m 13sIn this video, learn how to change a SQL database's ownership using Microsoft PowerShell. FREE ACCESS
-
4. Create Schema7m 4sFind out how to create a schema within a database using PowerShell. FREE ACCESS
-
5. Create Stored Procedure7m 23sIn this video, you will learn how to create, change, and delete a stored procedure using the PowerShell utility. FREE ACCESS
-
6. DBCC Using PowerShell3m 38sIn this video, you will learn how to pass your DBCC to each database using PowerShell. FREE ACCESS
-
7. Create XML Schema Collection2m 52sDuring this video, you will learn how to create a schema collection using PowerShell. FREE ACCESS
-
8. Configure Database Mail6m 48sDuring this video, you will learn how to configure and enable database mail using PowerShell. FREE ACCESS
-
9. Connect to SQL Using SQL Authentication2m 37sIn this video, learn how to connect to an instance of SQL server using authentication in PowerShell. FREE ACCESS
-
10. Change Server to Mixed Mode Authentication5m 40sIn this video, you will use PowerShell cmdlets to change an instance of SQL Server from Integrated Mode Authentication to Mixed Mode Authentication. FREE ACCESS
-
11. Drop Objects5m 41sIn this video, you will use PowerShell cmdlets to delete an object within an instance of SQL Server. FREE ACCESS
-
12. Send Query Results E-mail7m 5sLearn how to use PowerShell cmdlets to send SQL Server Query results through an email. FREE ACCESS
-
13. Create Operator3m 47sFind out how to use PowerShell cmdlets to create an operator in SQL Server Agent. FREE ACCESS
-
14. Create Alert5m 16sFind out how to use PowerShell cmdlets to create error alerts for multiple errors at the same time in SQL Server Agent. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
