Course Name |
Hours |
List Price |
Content |
55069 - PowerShell for SQL Server Administrators |
14.00 |
$1,159.00 |
|
Description: This two-day instructor-led course provides candidates with the knowledge and skills needed to use PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012. Students will learn how to manage day-to-day and scheduled maintenance tasks. The main focus will be administration of the database engine, but optional material exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.
If all the optional lab exercises are included, the class would need to be taught in three days instead of two.
Audience Profile
This course is intended for SQL Server administrators who work in a Windows network environment. At least one year of experience administering SQL Servers and using PowerShell is recommended.
At Course Completion
Install and Configure SQL Server and all its components using PowerShell
Manage day-to-day SQL Server Administration with PowerShell
Maintain the SQL Server environment using PowerShell scripting and programming options
# of Days:
Setting:
|
DP-080T00: Querying Data with Microsoft Transact-SQL |
14.00 |
$1,159.00 |
|
Description: This course will teach the basics of Microsofts dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
Audience Profile
This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.
# of Days:
Setting:
|
OR5460: Introduction to Oracle PL/SQL Programming |
21.00 |
$1,800.00 |
|
|
OR5470: Oracle Advanced PL/SQL Programming |
14.00 |
$1,195.00 |
|
|
OR5475: Troubleshooting, Debugging and Tuning Oracle PL/SQL Programs |
14.00 |
$1,195.00 |
|
|
PHP and MySQL Web Development |
28.00 |
$2,269.00 |
|
|
SQ1000: SQL Cross Platform SQL Essentials |
14.00 |
$1,125.00 |
|
|
SQ1010: SQL Cross Platform SQL - Dealing with Complex Queries |
21.00 |
$1,875.00 |
|
|