We are OPEN and delivering training as usual. View our COVID-19 statement.

Microsoft Certified: Azure Data Fundamentals

Microsoft Certified: Azure Data Fundamentals Course

Azure Administrator Overview:

Certification:

  • Microsoft Certified: Azure Data Fundamentals

Delivery:

  • Azure classroom training. Instructor led hands-on classes.

Azure Certification Exams:

  • 2 Exams, Real Time Simulation, Single and Multiple Choice Questions
  • Microsoft Certified: Azure Data Fundamentals

Azure Course Length:

  • 4 Weeks or Fast Track 4 Days

Azure Administrator Includes:

  • Hands-on Training, Lab Exercises, Project work, Unlimited Lab Access, Free Re-training

Azure Administrator Locations:

  • Liverpool Street, London
  • London Bridge, London
  • Moorgate, London

Flexible Starting Dates:

  • Azure Administrator on Weekdays, Weekends and Evenings

Brochure Request



Live Instructor-Led Classes

Virtual Training is the same as Face-to-Face Training

Virtual Classroom is the best option for anyone wishing to get an instructor-led training - while staying in the comfort of their home or office.

Call Us: 0207 256 2268

 

COVID-19 Statement

We are open and delivering training as normal

Monday 30th June 2020

To all our valued students,

We are all experiencing incredibly confusing and unpredictable times. In consideration of the ongoing uncertainty regarding COVID-19, we wish to reassure you that we are taking necessary precautions to protect the health, safety and well-being of our customers, our employees and our partners.

We will continue to operate our business in accordance with government guidelines. We are accepting new registration and delivering on going training as normal.

We understand the importance of our customers feeling safe and comfortable in their homes. For your peace of mind, we are offering a safe and contact free LIVE online tutor led training too.

We are closely monitoring the advice and information provided by the government and commit to updating you if anything changes. Rest assured, our priority remains providing you with the quality training in the safest possible way.

We would also like to take some time to thank our incredible emergency services and NHS staff for their unbelievable and unprecedented support. We give thanks to those working tirelessly to keep us all safe and healthy. For more information, please click here.

As always our customer services team are available to help with any queries on 0207-256-2268 and through our contact us pages.

We wish good health to you, your friends and your family at this time.

Stay safe.

Training Square Team.

Yes we are open for training with a small number of students per class, considering government guidelines, and with social distancing in place.

- Our opening and closing hours are:
Mon to Fri - 10:00 till 17:00
Saturday - 10:00 till 1700

Yes, we have followed the government guidelines with social distancing. We are providing access to hand sanitizer to all our students, providing disposable masks and keeping the place clean and tidy.

Yes, the majority of our courses can be done LIVE online tutor led. You can join the scheduled classes with the tutor online. The online live classes are the same as the scheduled classes and the only difference is, you will be attending from wherever you wish to, as long as you have reliable internet access.

Finance Available

0% Interest

Spread The Cost of Your Training Across 12 Months

Course Fee: £890

3 months - £178 Upfront and monthly payments of £237

6 months - £178 Upfront and monthly payments of £119

12 months - £178 Upfront and monthly payments of £59

Enquire Now



Time Table

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

Microsoft Certified: Azure Data Fundamentals Course Description

Get trained in Microsoft Certified: Azure Database Administrator Associate - Azure Administrators associate to implement and manage cloud database and on-premises azure servers. This course will give you a hands-on training which will gain you a certificate as well as solid knowledge on Azure server and cloud database.

Azure Database Administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built with Microsoft SQL Server and Microsoft Azure Data Services. The Azure Database Administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.

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.

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:

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

Microsoft Certified: Azure Database Administrator Associate

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

Microsoft Certified: Azure Data Fundamentals Course Highlight

  • Exam DP-900: - Microsoft Azure Data Fundamentals
  •  
  • Microsoft Certified: Azure Data Fundamentals
 

Microsoft Certified: Azure Data Fundamentals

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

Price Info: £890

  • Hands-on Tutor Led Training
  • Classroom Based Practical Training
  • Unlimited Practice Lab Access
  • Small Size Class and Interactive Sessions
  • Lab Exercises
  • Mock Exam
  • WiFi Internet
  • Refreshments
  • Completion Certificate
  • Free Re-training
  • Cost is calculated at 70 percent Tuition Vatable and 30 percent Training Book(s) with 0 rated Vat

 

 

 

 

 

Package Offer: Great Savings!!!

Professional Package

£4200Saving £550

Request Info 0207 256 2268
Package Includes
MCSA SQL Server 2012 - £1250
+
Oracle 11g OCP - £3500

Total Price £4750

Offer Price £4200

Saving £550

MOST
POPULR

Career Package

£4000Saving £750

Request Info 0207 256 2268
Package Includes
MCSA SQL Server 2012 - £1250
+
MCSE SQL Server 2012 - £3000 +
MCSE Server 2012 - £1750

Total Price £4750

Offer Price £4000

Saving £750

Specialised Package

£2700Saving £300

Request Info 0207 256 2268
Package Includes
MCSA SQL Server 2012 - £1250
+
MCSE Server 2012 - £1750

Total Price £3000

Offer Price £2700

Saving £300

Trustpilot Training Square Review

The following reviews were taken at the end of the course and are 100% verifiable


Kolade

Tutor takes his time to explain and uses various examples to clarify a point.

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes


Steven

Tutor has extensive knowledge of the subject and was very helpful

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes


Mark

Tutor was very good at explaining concepts and applying real world examples…

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes


Lee

Tutor was very knowledgeable and answered all questions

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes


Ali

Tutor was very helpful and professional.

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes




Recently Trained Customers

"Your success is our goal"

IT Training
Training Square is rated 4.6 stars on Facebook based on 9 reviews