Database Management

PowerShell 3    |    Intermediate
  • 14 videos | 1h 9m 32s
  • Earns a Badge
Rating 4.7 of 40 users Rating 4.7 of 40 users (40)
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 29s
    In this video, you will learn how to create databases in PowerShell. FREE ACCESS
  • 4m 1s
    Learn how to use Microsoft PowerShell to create a login for Microsoft SQL Server. FREE ACCESS
  • Locked
    3.  Change Database User
    4m 13s
    In this video, learn how to change a SQL database's ownership using Microsoft PowerShell. FREE ACCESS
  • Locked
    4.  Create Schema
    7m 4s
    Find out how to create a schema within a database using PowerShell. FREE ACCESS
  • Locked
    5.  Create Stored Procedure
    7m 23s
    In this video, you will learn how to create, change, and delete a stored procedure using the PowerShell utility. FREE ACCESS
  • Locked
    6.  DBCC Using PowerShell
    3m 38s
    In this video, you will learn how to pass your DBCC to each database using PowerShell. FREE ACCESS
  • Locked
    7.  Create XML Schema Collection
    2m 52s
    During this video, you will learn how to create a schema collection using PowerShell. FREE ACCESS
  • Locked
    8.  Configure Database Mail
    6m 48s
    During this video, you will learn how to configure and enable database mail using PowerShell. FREE ACCESS
  • Locked
    9.  Connect to SQL Using SQL Authentication
    2m 37s
    In this video, learn how to connect to an instance of SQL server using authentication in PowerShell. FREE ACCESS
  • Locked
    10.  Change Server to Mixed Mode Authentication
    5m 40s
    In this video, you will use PowerShell cmdlets to change an instance of SQL Server from Integrated Mode Authentication to Mixed Mode Authentication. FREE ACCESS
  • Locked
    11.  Drop Objects
    5m 41s
    In this video, you will use PowerShell cmdlets to delete an object within an instance of SQL Server. FREE ACCESS
  • Locked
    12.  Send Query Results E-mail
    7m 5s
    Learn how to use PowerShell cmdlets to send SQL Server Query results through an email. FREE ACCESS
  • Locked
    13.  Create Operator
    3m 47s
    Find out how to use PowerShell cmdlets to create an operator in SQL Server Agent. FREE ACCESS
  • Locked
    14.  Create Alert
    5m 16s
    Find 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.

YOU MIGHT ALSO LIKE

Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 19 users Rating 4.5 of 19 users (19)
Rating 3.9 of 26 users Rating 3.9 of 26 users (26)
Rating 4.4 of 253 users Rating 4.4 of 253 users (253)