Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-465): Managing SQL Server with PowerShell

Utilize Windows PowerShell and how it can be used to manage SQL Server and make the administrators’ jobs much easier and more efficient.

Description

Network administrators, server administrators, and database administrators take up the roles that manage the servers and ensure smooth functioning of the infrastructure. This course covers Windows PowerShell and how it can be used to manage SQL Server and make the administrators’ jobs much easier and more efficient. We discuss how to use and create various commands as well as write scripts to manage or automate.
 

Topics Covered Include:
-Introduction to Windows PowerShell
-PowerShell Cmdlets, Modules, and Commands
-PowerShell in SQL Server and Scripting

Full details

Curriculum

  • Course Overview
    Course Orientation
    1:54
    Managing SQL Server with PowerShell: Supplemental Materials
    Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-465): Managing SQL Server with PowerShell"" Course.
  • Introduction to Windows PowerShell
    Windows PowerShell
    1:02
    Overview
    2:56
    Introduction to Windows PowerShell
    2:09
    Windows PowerShell Features
    2:17
    Knowledge Check
    0:35
  • PowerShell Cmdlets, Modules, and Commands
    Windows PowerShell Cmdlets
    2:38
    Windows PowerShell Modules
    2:26
    Using Windows Commands and Utilities
    1:36
    Knowledge Check
    0:35
  • PowerShell in SQL Server and Scripting
    Windows PowerShell in SQL Server
    1:34
    SHOW ME Demonstration: Using Windows PowerShell
    1:50
    Scripting with Windows PowerShell
    2:26
    SHOW ME Demonstration: PowerShell Commands and PowerShell ISE
    2:32
    Running PowerShell Scripts in Secured Environment
    1:48
    Knowledge Check
    0:26
    Conclusion
    0:45

Skills

  • Database Management System (DBMS)
  • Database Management
  • SQL Server

Similar Courses

More Courses by this Instructor