Every registration supports local education. TrainUp Gives Back

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
  • calendar Image 6-12 Months
    To Complete


PowerShell can be used to manage the full range of SQL Server management tasks, and through scripting can assist with automation of frequent tasks. This course covers policies and jobs, working with PowerShell’s powerful scripting features, and working with individual databases.

Learning Objectives
  • Start the course
  • Use cmdlets to create and configure user defined policies in PowerShell
  • Evaluate policies and output the result in PowerShell
  • Create a PowerShell Job Step inside a SQL Server Agent Job
  • Use Microsoft PowerShell to populate a table created in Microsoft SQL Server Management Studio using SQLCMD mode
  • Execute SQL scripts from file locations in PowerShell
  • Create SQL Server Agent Jobs in PowerShell
  • Execute existing SQL Server Jobs in PowerShell
  • Retrieve SQL Server Agent Job histories in PowerShell
  • Use PowerShell variables
  • Use piping in PowerShell
  • Use the PowerShell Utility to create a Stored Procedure
  • 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 e-mail
  • 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
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.