Implement scalable database solutions using Azure SQL (DP-300T00)
Contact us to book this course
Learning Track
Cloud and AI Platforms
Delivery methods
On-Site, Virtual
Duration
4 days
This course provides students with the knowledge and skills to create a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
Learning Objectives
-
Plan, deploy and configure Azure SQL offerings
-
Monitor database performance and tune a database and queries for optimum performance
-
Plan and configure a High Availability Solution.
Who Should Attend
Database Administrator.
The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.
Prerequisites
- SQL & Relational Databases: Basic understanding of relational database concepts, including database planning security.
- SQL Server Administration: Foundational knowledge of SQL Server storage structure (data files, log files, and transaction log management), indexes, and system databases (master, tempdb, msdb).
- Database Operations & Querying: Ability to create on-premises SQL Server databases, use query tools, and write basic SQL/T-SQL code.
- Azure & Cloud Infrastructure: Experience creating and configuring cloud resources using the Azure portal.
- Virtualization & Systems: Familiarity with on-premises virtualization (VMs, virtual networking, virtual hard disks) and monitoring system components (CPU, I/O, network) using Windows Performance Monitor.
- Networking & Security: Practical knowledge of network configurations (TCP/IP, DNS, VPNs, firewalls) and encryption technologies.
