Database Management

PowerShell 3    |    Intermediate
  • 14 Videos | 1h 11m 32s
  • Earns a Badge
Likes 14 Likes 14
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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 1 Likes 1  
Likes 4 Likes 4  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 22 Likes 22  
Likes 17 Likes 17  
Likes 141 Likes 141