Select Page

Microsoft Azure and SQL Specialist. Data Engineer

Official Microsoft Imagine Academy

Information, and consequently, databases, are of great importance today. They store data for later processing and use in our daily lives, from the smallest website to the most important app. In this regard, SQL Server is positioned as one of the preferred platforms for price, performance, and large-scale scalability.

REQUEST MORE INFORMATION

     

    Do you want to see a demo class?

      Demo Video
      Infórmate Infórmate

      About the Microsoft Azure and SQL Data Engineer Specialist course

      The DP-300 is a Microsoft certification that certifies technicians in the administration of relational database solutions in Azure. An Azure Data Engineer refers to a data professional who possesses the skills to implement, manage, and maintain relational databases in the Azure cloud. Azure Data Engineer competencies include SQL Server and Azure SQL database administration, implementation of hybrid and cloud-native solutions, security management, database performance monitoring and optimization, and high availability and disaster recovery planning.

       Duration:

      +200 Hours / 3-5 months

       Mode:

      In person
      Semi-presential
      On-line

       Prerequisites:

      Basic knowledge of computers and the Internet

      Official Certification

      Students gain official registration as technicians in a specific technology, which certifies them to practice their profession internationally. We certify our students worldwide.

      • AZ-900 Microsoft Azure Fundamentals Certification
      • DP-300 SQL Administration Certification on Microsoft Azure
      • DP-700 Microsoft Fabric Data Engineer Associate Certification
      • DP-900 Azure Data Fundamentals Certification

      Job opportunities

      Azure is the only consistent hybrid cloud compatible with any open source technology. Therefore, the need for Azure-trained professionals is endless, and there is currently no offering that can meet this demand. Therefore, specialists trained to implement Azure deployments are considered essential.

      Today, 901% of Fortune 500 companies have already moved their services to the Microsoft Azure cloud, serving as a guide for other companies that look to them as a role model.

      Through Cloud TalentThe school connects you with more than 10,000 companies and generates job interviews and internships tailored to your professional profile. Additionally, the Cloud Talent Program gives you access to other complementary SAP certifications at no cost to enhance your qualifications.

      Syllabus

      Technical Training

      Azure Fundamental Management (AZ-900)

      Microsoft Azure Fundamentals Certification
      • Describe Cloud concepts.
      • Describe the main Azure services.
      • Describe the main management solutions and tools in Azure.
      • Describe general security and network security features.
      • Describe the characteristics of identity, governance, privacy, and compliance.
      • Describe Azure cost management and Service Level Agreements.

      Specific Training

      Azure and SQL Fundamentals (AZ-900 and DP-900)

      Azure Fundamentals. Introduction to SQL. Advanced T-SQL. Azure SQL Basics
      • Describe cloud concepts.
      • Describe the main Azure services.
      • Describe the main management solutions and tools in Azure.
      • Describe general security and network security features.
      • Describe the characteristics of identity, governance, privacy, and compliance.
      • Describe Azure cost management and Service Level Agreements.
      • Describe basic data concepts.
      • Describe how to work with relational data in Azure.
      • Describe how to work with non-relational data in Azure.
      • Describe an analytics workload in Azure.
      • SQL Basics.
      • Perform administration using T-SQL.

      Administering Relational Databases on Azure

      SQL resources. High availability and disaster recovery environment. Data warehousing in Azure. Data integration at scale with Azure Data Factory.
      • Plan and implement data platform resources.
      • Implement a safe environment.
      • Monitor and optimize operational resources.
      • Optimize query performance.
      • Perform task automation.
      • Plan and implement a High Availability and Disaster Recovery (HADR) environment.

      Data Engineering

      Azure Synapse Analytics. Implementation with Azure Databriks. Working with Data Lake Storage and Cosmos DB
      • Implement data storage solutions.
      • Cloud data architectures and evolution (DWH-DL-LH).
      • Design of a data storage.
      • Physical implementation of storage structures.
      • Implementation of logical data structures.
      • Manage and develop data processing.
      • Data ingestion, processing, availability and exploitation.
      • Process orchestration with ADF.
      • Monitor and optimize data solutions.
      • Design Azure data storage solutions.
      • Implement security solutions.
      • Design data processing solutions.
      • Design for Data Security and Compliance.
      • Data storage in Azure.
      • Using relational data in Azure.
      • Using NoSQL data in Azure Cosmos DB.
      • Large-scale data processing with Azure Data Lake Storage Gen2.

      Final Project

      Final Project
      • Course review.
      • Case study.

      Official Certification Seminar

      Official Certification
      • Preparation of exam-type questions.

      Subsidized Training for Companies

      Cloud Training as an entity registered with code 16753 in the State Registry of Training Entities, Manages and teaches courses within the Company-Programmed Training initiative, Vocational Training for Employment, in accordance with the provisions of Law 30/2015, of September 9.

      Cloud Training helps you check your company's credit amount for this year, free of charge.