Microsoft Azure SQL Administration : DP-080T00: Quering Data with Microsoft Transact – SQL & DP – 300T00: Administering Microsoft Azure SQL Solutions
Azure SQL, a cloud-based relational database service, presents a wealth of features including scalability, high availability, and robust security. For those seeking career advancement, mastering Azure SQL is the pathway to success. With its high demand, this skill opens doors to various job opportunities in the cloud computing industry.Our training program empowers you to become a proficient cloud database expert; you will gain the skills required for effective management, ensuring availability, security, performance optimization, and more. The curriculum covers essential tasks, including evaluating and implementing migration strategies for seamless database movement between Azure and on-premises environments.
Benefit Highlights:
Career Progression: Azure SQL proficiency propels your career. The job market values this skill, offering diverse roles for adept users.
Skill Value: Efficiently manage databases within Azure’s dynamic framework. These skills enhance both your professional and personal growth.
Certification Pathway: Successful course completion can lead to certification, validating your Azure SQL expertise.
Holistic Learning: The course encompasses varied aspects, from optimizing performance to strategic migration between Azure and on-premises environments.
Ready yourself for a rewarding career in cloud computing through our Azure SQL training. Don’t miss out on the chance to become a sought-after professional in this dynamic field.
Candidates participating in Microsoft Courses will be granted a 180-day online lab access to reinforce the knowledge gained during their classroom and practice what they have learned.
Courses are delivered in collaboration with Formatech, a Microsoft Learning Partner.
Are you an organisation or a small medium enterprise? Give us a call and let us explore together how we can best customise this course for you!
Write SELECT statements to retrieve columns from one or more tables
Sort and filter selected data
Use built-in functions to returned data values
Create groups of data and aggregate the results
Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE
Plan and implement data platform resources
Implement a secure environment
Monitor, configure, and optimize database resources
Configure and manage automation of task
Plan and configure a high availability and disaster recovery (HA/DR) environment
• Introduction to Transact-SQL
• Sort and filter results in T-SQL
• Combine multiple tables with JOINs in T-SQL
• Write Subqueries in T-SQL
• Modify data with T-SQL
• Prepare to maintain SQL databases on Azure
• Deploy IaaS solutions with Azure SQL
• Deploy PaaS solutions with Azure SQL
• Evaluate strategies for migrating to Azure SQL
• Migrate SQL workloads to Azure SQL databases
• Migrate SQL workloads to Azure Managed Instances
• Configure database authentication and authorization
• Protect data in-transit and at rest
• Implement compliance controls for sensitive data
• Describe performance monitoring
• Configure SQL Server resources for optimal performance
• Configure databases for optimal performance
• Explore query performance optimization
• Evaluate performance improvements
• Explore performance-based design
• Automate deployment of database resources
• Create and manage SQL Agent jobs
• Manage Azure PaaS tasks using automation
• Describe high availability and disaster recovery strategies
• Explore IaaS and PaaS solutions for high availability and disaster recovery
• Back up and restore databases
This course is for participants with an understanding of database concepts.It is suitable for participants working with data such as data analysts, a data engineers, a data scientists, database administrators or a database developers. 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.
Microsoft Azure SQL Administration : DP-080T00: Quering Data with Microsoft Transact – SQL & DP – 300T00: Administering Microsoft Azure SQL Solutions
