One platform: students, companies, universities
Walnutcraft
Career course · Working professionals Intermediate

Data Engineering Foundations

This course prepares you for the AWS Solutions Architect Associate credential. University partner: Partner University (sample).

Databases, distributed systems and data modelling from university faculty; SQL at scale, Python pipelines, Spark and cloud data platforms from working data engineers.

Part A · Theory · University · 35%Part B · Practical · Industry · 65%

Who this course is for

Data analysts and developers who want to build pipelines, and engineering graduates with SQL and Python.

What you will be able to do

Graduates are ready for junior data engineer and analytics engineer roles.

Careers this course serves

Data EngineerData Engineer in Canada

Jobs this course leads to

Roles from partner employers that name this course's certification.

All jobs
IT services partner6 vacanciesJunior Data EngineerChennai, India₹5 to 8 lakh a yearQualificationEngineering graduate with SQL and PythonKey certificationAWS Solutions Architect AssociateSuggested course12 weeksData Engineering FoundationsUniversity + company₹26,0001 to 3 yearsView job

Syllabus, by who teaches it

Progress is tracked separately for theory and practical, and both are assessed.

Part A · Theory University faculty
  1. A1
    Advanced SQL and database internals

    Indexes, query plans and transactions.

  2. A2
    Data modelling for analytics

    Dimensional models and the modern lakehouse.

  3. A3
    Distributed data processing

    How Spark and warehouses scale.

  4. A4
    Data quality and governance

    Contracts, lineage and testing.

Assessed by a proctored online theory exam set and marked by university faculty.
Part B · Practical Industry professionals
  1. B1
    Python pipelines

    Extract, transform and load with pandas and orchestration.

  2. B2
    Spark

    Batch processing on Databricks or a cloud cluster.

  3. B3
    Cloud data platforms

    A warehouse on BigQuery, Snowflake or Redshift.

  4. B4
    Orchestration and monitoring

    Airflow, alerts and cost control.

  5. B5
    Industry project

    A production-style pipeline for a partner company's data, reviewed by their data lead.

Assessed on progressive assignments, the industry project and a presentation to the partner team.
You earnWalnutcraft Certificate in Data EngineeringIssued on passing both assessments, with theory and practical marks shown separately. Verifiable online by employers.
Industry projectA brief from a partner companyA production-style pipeline for a partner company's data, reviewed by their data lead.
After the courseApply to partner rolesApply from Walnut LMS to the roles partner employers share for this career, and sit the certification exam with the course's preparation.

Certifications this course prepares you for

AWS Solutions Architect AssociateAmazon Web ServicesThe most held AWS certification worldwide, for people who design and run workloads on AWS.

Ready for Data Engineering Foundations?

Ask about the next batch, fees and whether your employer can sponsor the seat.

Enrol or enquireRequest the syllabus