Skip to content
Lagos CityComputer College
Microsoft CertificationsCertification PrepBeginnerAdmission open

Microsoft Azure Data Fundamentals (DP-900)

Learn core data concepts, relational and non-relational data, and analytics on Azure, and prepare for DP-900.

Programme duration, fees, schedules and entry requirements are being confirmed by the college. Please contact admissions for the latest information.

Programme overview

Data powers every modern business. DP-900 gives you a solid understanding of how data is stored, processed and analysed, and how Microsoft Azure supports each stage.

You will work with relational databases and SQL, explore non-relational stores such as Azure Cosmos DB, and see how large-scale analytics and reporting are built with Microsoft Fabric and Power BI.

The course suits beginners and is a strong foundation for data analysis, data engineering and AI careers.

Who it is for

  • Beginners interested in data careers
  • Business analysts and report writers
  • Developers who want to understand Azure data services

Recommended background

  • Basic computer literacy
  • Comfort with spreadsheets is helpful

Curriculum

5 modules · 20 topics

Indicative curriculum. Final modules and schedule are confirmed at enrolment.

  1. 01Core Data ConceptsUnderstand how data is represented and used.
    • Structured, semi-structured and unstructured data
    • Transactional versus analytical workloads
    • Data roles: database administrator, data engineer, data analyst
  2. 02Relational Data on AzureWork with tables and SQL.
    • Tables, keys, normalisation and relationships
    • SQL statements: SELECT, INSERT, UPDATE and DELETE
    • Azure SQL Database, Azure SQL Managed Instance and SQL Server on VMs
    • Azure Database for PostgreSQL and MySQL
  3. 03Non-Relational Data on AzureStore documents, files and key-value data.
    • Azure Blob Storage, Data Lake Storage and Azure Files
    • Azure Table storage
    • Azure Cosmos DB and its APIs
  4. 04Analytics WorkloadsTurn raw data into insight.
    • Data ingestion and ETL/ELT
    • Data warehouses and lakehouses
    • Real-time analytics
    • Microsoft Fabric and Azure Databricks overview
    • Data visualisation with Power BI
  5. 05Exam Readiness & Practice TestsPrepare to sit DP-900 with confidence.
    • How the DP-900 exam is structured and scored
    • Question types: case studies, drag-and-drop and multiple choice
    • Timed practice tests with review of every answer
    • Personal study plan based on your weak areas
    • Booking the exam online or at a test centre

What you will be able to do

  • Explain core data concepts and data roles
  • Query relational data with SQL
  • Choose suitable Azure services for relational and non-relational data
  • Describe modern analytics architectures
  • Be ready to sit the DP-900 exam

Tools & technologies

  • Azure SQL Database
  • Azure Cosmos DB
  • Azure Storage
  • Microsoft Fabric
  • Power BI

Career paths

  • Junior data analyst
  • Database support associate
  • Reporting analyst
  • Pathway to data engineering

Certification

Prepares you for Microsoft Certified: Azure Data Fundamentals (exam DP-900).

This is an exam-preparation course delivered by Lagos City Computer College. Certification exams are booked and taken separately through Microsoft, and exam fees are not included unless stated. Exam codes and skills measured follow Microsoft's published study guide at the time of delivery; Microsoft may update or retire exams, so confirm the current outline on Microsoft Learn before booking. Microsoft, Azure, Power BI and Power Platform are trademarks of the Microsoft group of companies; Lagos City Computer College is not affiliated with or endorsed by Microsoft unless stated.

Entry requirements

  • Specific entry requirements will be published once confirmed by the school.
  • Programme suitability depends on the individual course. Contact the admissions team for guidance.
Read the full admissions guide

Related programmes