Database Management

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 14 Likes 14  
Likes 166 Likes 166  
Likes 17 Likes 17