Job Guarantee Program: Database | Networking
We are OPEN and delivering training as usual. View our COVID-19 statement.

Microsoft Certified: Azure Data Fundamentals

Synopsis

  • Fast Track (4 Days) – Mon to Thurs (10:00-18:00)
    Weekend Track (7 Weeks) – Every Saturday (14:30–18:30)
    Regular Track (7 Weeks) – Every Friday (09:30–13:30)
    Evening Track (5 Weeks) – Every Tue & Thurs (18:30–21:30)
  • Course Fee: £742 + VAT
  • Industry Expert and Certified Instructors
  • Training Venue: Central London Location
  • Tutor Led Classroom Training

Request Brochure


Attend Instructor Led Training From Anywhere

Course Information

Microsoft Certified: Azure Data Fundamentals

Get trained in Microsoft Certified: Azure Data Fundamentals - Azure Data Fundamentals to implement and manage cloud database and on-premises azure services. This course will give you a hands-on training on sql data which will gain you a certificate as well as solid knowledge on Azure data services and cloud database.

Candidates for the Azure Data Fundamentals certification gain foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services.

Candidates for this exam are database administrators and data management specialists that manage on-premises and cloud relational databases built with Microsoft SQL Server and Microsoft Azure Data Services.

This role is responsible for management, availability, security and performance monitoring and optimization of modern relational database solutions. This role works with the Azure Data Engineer role to manage operational aspects of data platform solutions.

This certification is intended for candidates beginning to work with data in the cloud.

Microsoft Certified: Azure Database Administrator Associate course is delivered in London and classes are running during the day and on the evenings & weekends

Learning Facilities

We have immaculate learning facilities with state of art technology, fully equipped with high specs latest servers, workstations and software.

General Facilities

We also provide Free Wifi Internet, Refreshment, Water, Tea and Coffee Facilities.

Registration Process

Speak with course advisor about Azure training in London. Call us: 0207 256 7722

Who is this course for?

Candidates wishing to persue their career in cloud computing is responsible for management, availability, security and performance monitoring and optimization of modern relational database solutions.

Requirements

Basic knowledge computing skill and microsoft sql server database would be an advantages.

Delivery Method

This course is delivered
"Instructor Led Virtual Live Training"
Or "Our Center Classroom Instructor Led Training"

Career path

Azure Data Fundamentals can be used to prepare for other Azure role-based certifications like Azure Database Administrator Associate or Azure Data Engineer Associate, but it’s not a prerequisite for any of them.

Job roles: Azure Cloud Database, Database Administrator, Technology Manager

Course Fee: £1200 + VAT

  • Hands-on Tutor Led Training
  • Classroom Based Practical Training
  • Unlimited Practice Lab Access
  • Small Size Class and Interactive Sessions
  • Lab Exercises
  • Project Work
  • WiFi Internet
  • Refreshments
  • Completion Certificate
  • Free Re-training
  • The course fee excludes VAT
Interest Free Credit for IT course

Pay Monthly.

Interest Free Installments Upto 1 Year.

Contact


Microsoft Certified: Azure Data Fundamentals

  • Exam DP-900: Microsoft Azure Data Fundamentals

Course Syllabus

Describe core data concepts

Describe types of core data workloads

  • describe batch data
  • describe streaming data
  • describe the difference between batch and streaming data
  • describe the characteristics of relational data

Describe data analytics core concepts

  • describe data visualization (e.g., visualization, reporting, business intelligence (BI))
  • describe basic chart types such as bar charts and pie charts
  • describe analytics techniques (e.g., descriptive, diagnostic, predictive, prescriptive, cognitive)
  • describe ELT and ETL processing
  • describe the concepts of data processing

Describe how to work with relational data on Azure

Describe relational data workloads

  • identify the right data offering for a relational workload
  • describe relational data structures (e.g., tables, index, views)

Describe relational Azure data services

  • describe and compare PaaS, IaaS, and SaaS solutions
  • describe Azure SQL family of products including Azure SQL Database, Azure SQL
  • Managed Instance, and SQL Server on Azure Virtual Machines
  • describe Azure Synapse Analytics
  • describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL

Identify basic management tasks for relational data

  • describe provisioning and deployment of relational data services
  • describe method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)
  • identify data security components (e.g., firewall, authentication)
  • identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
  • identify query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)

Describe query techniques for data using SQL language

  • compare Data Definition Language (DDL) versus Data Manipulation Language (DML)
  • query relational data in Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL

Describe how to work with non-relational data on Azure

Describe non-relational data workloads

  • identify the right data offering for a relational workload
  • describe relational data structures (e.g., tables, index, views)

Describe relational Azure data services

  • describe and compare PaaS, IaaS, and SaaS solutions
  • describe Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines
  • describe Azure Synapse Analytics
  • describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL

Identify basic management tasks for relational data

  • describe provisioning and deployment of relational data services
  • describe method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)
  • identify data security components (e.g., firewall, authentication)
  • identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
  • identify query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)

Describe query techniques for data using SQL language

  • compare Data Definition Language (DDL) versus Data Manipulation Language (DML)
  • query relational data in Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL

Describe how to work with non-relational data on Azure

Describe non-relational data workloads

  • describe the characteristics of non-relational data
  • describe the types of non-relational and NoSQL data
  • recommend the correct data store
  • determine when to use non-relational data

Describe non-relational data offerings on Azure

  • identify Azure data services for non-relational workloads
  • describe Azure Cosmos DB APIs
  • describe Azure Table storage
  • describe Azure Blob storage
  • describe Azure File storage

Identify basic management tasks for non-relational data

  • describe provisioning and deployment of non-relational data services
  • describe method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)
  • identify data security components (e.g., firewall, authentication, encryption)
  • identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
  • identify management tools for non-relational data

Describe an analytics workload on Azure

Describe analytics workloads

  • describe transactional workloads
  • describe the difference between a transactional and an analytics workload
  • describe the difference between batch and real time
  • describe data warehousing workloads
  • determine when a data warehouse solution is needed

Describe the components of a modern data warehouse

  • describe Azure data services for modern data warehousing such as Azure Data Lake Storage Gen2, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight
  • describe modern data warehousing architecture and workload

Describe data ingestion and processing on Azure

  • describe common practices for data loading
  • describe the components of Azure Data Factory (e.g., pipeline, activities, etc.)
  • describe data processing options (e.g., Azure HDInsight, Azure Databricks, Azure Synapse Analytics, Azure Data Factory)

Describe data visualization in Microsoft Power BI

  • describe the role of paginated reporting
  • describe the role of interactive reports
  • describe the role of dashboards
  • describe the workflow in Power BI

What Our Customers says

Microsoft Certified: Azure Data Fundamentals Package Offer: Great Savings!!!

Giveaway Price
£2000 +VAT
Silver Package
  • Package Includes
  • MCSA: SQL 2016 Database Administration test £1200
  • MCSA: SQL 2016 Database Development £1200
  • Total Price £2400
  • Offer Price £2000
  • Savings £400
Giveaway Price
£4000 +VAT
Diamond Package
  • Package Includes
  • MCSA: SQL 2016 Database Administration test £1200
  • MCSA: SQL 2016 Database Development £1200
  • MCSA SQL 2016 BI Development £1200
  • MCSA MS SQL 2012 Data Platform £1200
  • Total Price £4800
  • Offer Price £4000
  • Savings £800
Giveaway Price
£3000 +VAT
Gold Package
  • Package Includes
  • MCSA: SQL 2016 Database Administration test £1200
  • MCSA: SQL 2016 Database Development £1200
  • MCSA SQL 2016 BI Development £1200
  • Total Price £3600
  • Offer Price £3000
  • Savings £600

Time Table and Pricing

This is an On-Demand course. Please call us on 0207 256 7722 to arrange the training as per your requirement.

Training Facilities

Training And Certification

Why Choose London Training ?

  • Authorized Training Center
  • Hands-on Training
  • Tutor Led Classroom
  • Small Class Size 5-7 max
  • Central London Locations
  • Expert and Certified Trainers
  • Price includes Tuition Fee, Classroom Training and Course Material
  • Expert and Certified Trainers
  • Classes on Week Days, Evening or Weekends
  • Free Re-training
  • Modern Training Facilities
  • Inclusive Books / Materials
  • Mock Exams / Projects