| Course Name |
Hours |
List Price |
Content |
| 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:
|
| MySQL Administration |
14.00 |
$999.00 |
|
Description: This 2-day class walks the admin through the basics of MySQL administration. Included are an introduction to the available MySQL client software and its use in performing administrative functions, optimization tasks, and general performance tuning.
# of Days:
Setting:
|
| MySQL Administration and Development |
28.00 |
$1,999.00 |
|
Description: This 4-day class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers.
# of Days:
Setting:
|
| MySQL Development |
21.00 |
$1,499.00 |
|
Description: This 3-day class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. Students also participate in database design discussions, and learn about optimization.
# of Days:
Setting:
|
| PostgreSQL Administration |
35.00 |
$3,500.00 |
|
Description: This course is designed for PostgreSQL administration and configuration. It will cover specific PostgreSQL configurations and processes. It will address specific PostgreSQL utilities, commands, and security. It is designed for experienced DBAs and developers.
# of Days:
Setting:
|
| Oracle SQL Optimization for Developers and DBAs |
21.00 |
$1,920.00 |
|
Description: This course provides students with an introduction to application and database tuning. Students will learn how the cost-based optimizer works. A discussion of basic Oracle architecture will provide the foundation for understanding both SQL statement and system performance. Students will use EXPLAIN PLAN and AUTOTRACE for evaluating execution strategies and the DBMSSTATS package for gathering optimizer statistics. Also discussed is how to influence the behavior of the optimizer with hints, physical schema changes, and alternative SQL statement syntax. Factors that affect overall system performance such as the buffer cache, SGA structures, and waits due to locks and latches are presented.
Hands-on workshops provide students with a solid understanding of the concepts presented in the lectures.
This course can be taught for any Oracle version.
|