COURSE 10 / 12 · FOUNDATIONS

Azure Data Fundamentals

Relational, non-relational and analytics data on Azure at DP-900 level.

4 weeksBeginnerLive 1:13 × 1h 15m / week
Enroll in this course Book a free callWhatsApp
100+ students trained80+ placed in jobs7+ years in data
compare.sql
-- Relational: Azure SQL DatabaseSELECT TOP 5 product, SUM(qty) AS unitsFROM dbo.salesGROUP BY productORDER BY units DESC; -- Non-relational: Azure Cosmos DB (NoSQL API)SELECT c.product, c.qtyFROM cWHERE c.region = 'EU'
✓ readySQL · course 10
DURATION4 weekstypical pace
SESSIONS~12live, 1:1
LIVE HOURS~15hwith your mentor
MODULES4step by step
PROJECTS3portfolio ready
PRICE$200USD / month
OverviewCurriculumProjectsToolsWho it's forPricingFAQEnroll →
01 / OVERVIEW

What this course is about

This course gives you the big picture of data on Azure. You learn core data concepts, relational databases like Azure SQL, non-relational options like Cosmos DB and storage, and the analytics services that tie it together: Data Factory, Databricks, Synapse, Microsoft Fabric and Power BI. Each week has labs, and the course ends with DP-900 preparation.

You learn by doing: every week has hands-on exercises on Google Classroom, and every module ends with something you built yourself.

01

Know core data concepts

Structured and unstructured data, file formats, OLTP and OLAP.

02

Work with relational data

SQL basics and the Azure SQL family of services.

03

Work with non-relational data

Blob, ADLS Gen2, Table storage and Cosmos DB.

04

Understand analytics on Azure

Ingestion, warehouses, lakehouses and real-time analytics.

05

See the data roles clearly

What data engineers, analysts and DBAs actually do.

06

Pass DP-900

Practice questions and a clear exam plan.

02 / CURRICULUM

Week by week

A clear plan from the first session to the last. The pace adapts to you: if you already know a topic we move faster, and if something needs more time we take it.

WEEK 1Core data concepts5 topics
  • Structured, semi-structured and unstructured data
  • CSV, JSON, Parquet and Avro
  • Transactional vs analytical workloads
  • Batch vs streaming
  • Data roles and responsibilities
WEEK 2Relational data on Azure5 topics
  • Tables, keys and normalisation
  • SQL: DDL and DML basics
  • Azure SQL Database and Managed Instance
  • SQL Server on Azure VMs
  • Azure Database for PostgreSQL and MySQL
WEEK 3Non-relational data on Azure5 topics
  • Azure Blob Storage and ADLS Gen2
  • Azure Files and Table storage
  • Azure Cosmos DB and its APIs
  • Partitioning and consistency basics
  • Choosing the right store
WEEK 4Analytics and exam prep5 topics
  • Ingestion with Data Factory
  • Data warehouses and lakehouses
  • Databricks, Synapse and Microsoft Fabric
  • Real-time analytics and Power BI
  • DP-900 practice questions
03 / PROJECTS

What you will build

Real projects you can put on GitHub and explain with confidence in interviews.

PROJECT 01

Case study design

Pick the right Azure data services for a realistic business scenario and explain the trade-offs.

ArchitectureTrade-offsDiagrams
PROJECT 02

Azure SQL lab

Create an Azure SQL database, load sample data and answer questions with SQL.

Azure SQLSQLSecurity
PROJECT 03

Cosmos DB lab

Store JSON documents in Cosmos DB and compare queries with the relational version.

Cosmos DBJSONPartition keys
04 / TOOLS

Tools and technologies

The same tools used by data teams in real companies.

Azure SQL DatabaseAzure Cosmos DBAzure StorageADLS Gen2Azure Data FactoryMicrosoft FabricPower BI
05 / IS IT FOR YOU

Who this course is for

Who it is for

  • Beginners exploring data careers
  • Analysts and developers new to Azure data services
  • Project and product people working with data teams
  • Anyone preparing for DP-900

What you need

  • No experience needed
  • An Azure free account, I guide the setup
  • Azure Fundamentals is helpful but optional

Roles it leads to

  • Junior Data Analyst
  • Junior Data Engineer
  • A first step to Azure Data Engineer or Fabric
06 / HOW YOU LEARN

What you get

Live and one-to-one

Every session is just you and me, never a batch. No recordings, so we can talk openly about your code.

3 sessions a week

Each session is 1 hour 15 minutes, on weekdays, weekends or both. We agree the schedule before starting.

Google Classroom

Assignments, projects, quizzes, interview questions and homework, all organised in one place.

Real projects

You build projects like the ones companies run, and get feedback on your code and design.

Interview preparation

Common questions, live coding practice and mock interviews with honest feedback.

Job placement support

CV, LinkedIn, applications and interviews. I stay with you until you are hired, as long as you do the work.

07 / PRICING

Simple pricing

You pay for your time with me, not per course. All prices are in US dollars.

WEEKLY
$50USD / week
Pay week by weekChoose weekly
MOST POPULARMONTHLY
$200USD / month
Pay once a monthChoose monthly
EVERY 15 DAYS
$100USD / 15 days
200 USD a month, split into 2 paymentsChoose every 15 days
Estimated total for Azure Data Fundamentals at the typical pace (4 weeks)
About 200 USD
Full refund if it is not right for you after the first session. Go faster and it costs less.
08 / YOUR MENTOR
Hikmat Ullah, Senior Data Engineer and mentor

Hikmat Ullah

Senior Data Engineer at Algo · Lahore, Pakistan

I build data platforms with Snowflake, Azure Databricks, Azure Data Factory and Microsoft Fabric every day, and I have been mentoring since 2021. I teach what I use at work, and I stay with you until you land the job.

7+years in data
100+students trained
80+placed in jobs
1:1always, never a batch

See my experience and projects → Student reviews →

09 / FAQ

Questions about Azure Data Fundamentals

Is DP-900 still relevant with Fabric?

Yes. DP-900 covers the core ideas behind every Azure data service, including analytics with Microsoft Fabric. It is a solid base for any Azure data role.

Do I need SQL?

No. We learn the SQL you need for DP-900 inside the course.

What should I take next?

SQL Developer if you want strong hands-on skills, or the Azure Data Engineer or Fabric track for a full career path.

How much does it cost?

200 USD per month whichever course you choose. You can also pay 100 USD every 15 days or 50 USD per week. All prices are in US dollars wherever you live.

What is the refund policy?

If the training is not right for you after the first session, you get a full refund. After that, payments already used for completed sessions are not refunded, but unused prepaid time can be refunded.

Is there a job guarantee?

Yes. As long as you attend your sessions and complete the assignments and projects, I keep helping you with CV, LinkedIn, mock interviews and job applications until you are hired.

Can I join from another country or time zone?

Yes. Students join from many countries. We pick session times that work for your time zone before we start.

10 / KEEP GOING

Related courses

4 weeks

Azure Fundamentals

Cloud concepts, core Azure services, security and pricing at AZ-900 level.

View course → 2 months

SQL Developer

From your first SELECT to stored procedures, data models and fast queries.

View course → 6 months

Microsoft Fabric Data Engineer

OneLake, lakehouses, pipelines, Spark, warehouse, real-time and Power BI in one platform.

View course →

See all 12 courses →

START WHEN YOU ARE READY

Start the Azure Data Fundamentals course

Tell me your goals and your time zone. We plan your schedule together, and your first session can start this week.

Enroll now Book a free 20 min callWhatsApp