| 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:
|
| PHP and MySQL Web Development |
28.00 |
$2,269.00 |
|
Description: MySQL and PHP are two of the most popular open source technologies to emerge during the past decade. PHP (Hypertext Preprocessor) is a powerful, portable, efficient scripting language written for web development. Its functionality far exceeds that of many other programming languages such as ASP or JSP. MySQL is the worlds most popular open source client-server database. Its architecture makes it extremely fast, reliable, and easy to customize. Together, these two technologies provide you with a powerful platform for building database-driven Web applications. This extraordinarily hands-on MySQL and PHP training course covers everything attendees need to successfully build data-driven Web sites using MySQL and PHP.
# of Days:
Setting:
|
| SQL Level 1 for Windows |
7.00 |
$399.00 |
|
Description: In this course you will cover how to: connect to the SQL Server database and execute a simple query, include a search condition in a simple query, use various functions to perform calculations on data, organize data, retrieve data by combining information from multiple tables present query results in a report.
# of Days:
Setting:
|
| SQL Level 2 for Windows |
7.00 |
$399.00 |
|
Description: In this course you will cover advanced techniques for querying a database including how to: code subqueries to generate query output, manipulate table data by inserting, updating and deleting records in a table, create a simple table, create tables with constraints, modify the table structure, and delete tables, create views, manipulate data through views, modify the view structure and drop views index data.
# of Days:
Setting:
|