fbpx

Become a certified
Data Engineer in 3 months

Launch your product design career with our intensive, live online bootcamp. Gain the skills to design user-centred products from scratch.

Live Bootcamp

All Levels

3 months

20+ topics

400+ Students

Our world-class curriculum empowers you to unleash your full potential as a Data Engineer!

This curriculum is tailored for individuals aspiring to embark on careers in data engineering. The program spans three months and is structured around three core tools: SQL, Power BI, and Python, with each tool receiving dedicated focus.

Integral to the course is a capstone project, offering students an opportunity to apply acquired skills in practical scenarios and showcase their proficiency upon completion of all modules. The capstone project will occur prior to the conclusion of each cohort, providing participants with a culminating experience to demonstrate their learning outcomes.
Module 1: Data Engineering Basics

Introduction to Data

What is data, types of data and forms, Data formats (CSV, Avro, Parquet, e.t.c), Concept of Storage systems (databases)

Introduction to Data Engineering

The need for a Data engineer, The Data lifecycle (Data collection process, storage, transformation and consumption)

Data Storage and Management

Types of databases, examples of each types

Modern Data Storage systems

Data warehouses, Datalakes, Lakehouses and differences

Common data Engineering concepts

ETLs and ELTs, Data Modelling; Meaning, Normalisation and Denormalisation

SQL Server Basics

Connecting to SQL Server using SSMS
Creating and altering a database
Creating and working with tables
Basic Select Operations
DDL and DML operations
Table constraints
Differences between Where and Having

Joins and Advanced Operations

Understanding the concept of Joins
Types of Joins and their use cases
Working with NULLs and Coalesce function
Using Unions and Union All
Exploring Stored Procedures
Triggers and their use cases

Functions and Optimization

Understanding SQL Functions
Types of Functions: Built-in and Custom Functions
Examples: LEFT, Right, Len, Upper, Lower, Date Functions
Exploring Indexes and Partitioning for Performance
Performance Testing Techniques

Advanced SQL Concepts

Working with Views, CTEs, and Subqueries
Understanding Database Normalization and Relational Databases
Types of Database Normalization
Exploring Rollup and Cube in SQL Server

Python Basics - Introduction to Python and its importance in data engineering

a. Setting up Python environment (Anaconda, Jupyter Notebook)
b. Basic syntax, variables, and data types
c. Control structures: if statements, loops

Data Structures

a. Lists, tuples, dictionaries, sets
b. List comprehensions
c. Working with data structures

Functions and Modules

a. Functions: defining, calling, arguments, return values
b. Scope and namespaces
c. Introduction to modules and libraries (e.g. pandas, NumPy)

Data Manipulation with pandas

a. Introduction to pandas library
b. Reading and writing data: CSV, Excel, SQL
c. Data exploration and manipulation: filtering, sorting, grouping

Data Cleaning and Preprocessing- Data transformation and standardization

Data Visualization - Creating basic plots: line plots, bar charts, histograms

Database Integration

a. Connecting Python with databases (e.g., SQLite, PostgreSQL)
b. Performing CRUD operations (Create, Read, Update, Delete) using Python
c. Executing SQL queries from Python

Web Scraping and API Integration

a. Introduction to web scraping using libraries like BeautifulSoup
b. Accessing APIs using Python

Introduction to Data Pipelines

a. Understanding data pipelines and ETL (Extract, Transform, Load) processes
b. Designing data engineering pipelines using Python
c. Workflow Management Tools (Azure Data Factory, Apache Airflow, Databricks,)

Get Started with Microsoft Data Analytics

a. Describe the Power BI Landscape of Products and Services
b. Tour the Power BI Service

Get Data in Power BI

a. Identify and retrieve data from different data sources
b. Understand the different connection methods and their performance
c. Optimise query performance

Clean, Transform, and Load Data in Power BI

a. Apply Data Shape Transformations
b. Enhance the Data Structure
c. Profile and Examine the Data

Design a Data Model in Power BI

a. Apply Data Shape Transformations
b. Understand the basics of Data Modelling
c. Defining Tables and Granularity
d. Define Relationships and their Cardinality
e. Implement Dimensions and Hierarchies

Creating Measures using DAX in Power BI

a. Understand DAX
b. Use DAX for Simple Formulas and Expressions
c. DAX Date and Time functions
d. Create Calculated tables and columns
e. Build simple Measures

Creating Reports

a. Design a Page layout
b. Select and add Appropriate Visualization type
c. Work with charts and tables on the report.

We hold 100% virtual live classes enabling you to learn from wherever alongside other budding techies, After your program, you’ll get the chance to showcase your work to industry experts and potential employers on our demo day.

This program is not for you if:

You are looking to bag jobs quickly without putting in the work

You can’t commit 6-8 hours a week for sessions and assignments

You don’t want to grow alongside a community of hustlers

You’re seeking theoretical learning and do not want to build a portfolio

You're searching for shortcuts rather than mastering core skills

You don't want to invest in your personal development

This program is tailor made for:

Individuals who love asking questions and uncovering insights from data.

People who understand that learning require putting in the work

Beginner data engineers who want to accelerate their growth

You love to put your lerning into practice and get hands-on

People from other career path trying to transition to Data engineering.

Newbies trying to get into the data field.

Learn and build with industry standards tools

Enhance your creativity, master your software skills with industry-standard tools 

Some Frequently asked questions

What does a certification from Verdac Tech mean?

Verdac Tech certifications validate your skills and knowledge in your specific tech field. Since 2022, we’ve been committed to delivering high-quality, industry-standard education. Our programs are designed to equip you with the practical skills employers seek. We are at the top of our game, and our instructors are some of the absolute best in the industry. Learn from the best and gain a competitive edge.

Who are Verdac instructors?

Verdac instructors are industry experts and at the top of their game in the tech world. They’re accomplished professionals currently working at leading tech companies. This means you’ll learn from practitioners who bring real-world experience and insights into the classroom.

What is the class schedule?

We understand you’re busy! Verdac offers flexible learning options to fit your schedule. Choose from part-time weeknights or weekend classes, or opt for our self-paced program for maximum flexibility. All programs provide comprehensive training within a set timeframe.

Why should I choose Verdac over other schools?

Verdac offers several advantages:
Gain a competitive edge with our industry-focused curriculum, taught by experienced instructors. Choose from flexible learning options to fit your schedule and learning style, and connect with a supportive community of learners and instructors for guidance and mentorship.

Is my background good enough to get started in tech?

Absolutely! Verdac programs cater to individuals with diverse backgrounds and career aspirations. We provide the foundational knowledge and practical skills needed to launch your tech career.

Can Verdac Tech provide custom training for my company?

Yes! Verdac offers customized training programs tailored to your company’s specific needs. Contact us to discuss your requirements.

How can I get started?

Ready to take the next step? Enroll now in the program that interests you. Have questions? Schedule a free consultation to discuss your goals and explore the best fit for you.

Kistart your enrollment with

N50,000

*Bootcamp full tuition is N150,000. 

Pay N50,000 in month 2 and 3 of the bootcamp to complete tuition.

Live Bootcamp

All Levels

3 Months

400+ Students

Requirements

  • Absolutely no experience is required. We will start from the basics and gradually build up your knowledge.
  • You will need a working laptop and internet connection
  • Enthusiasm and willingness to learn

Highlighing what you will learn
from this bootcamp

Take a dive into the amazing reviews from techies who have passed through our training

UX Research methodologies & Design Sprints

Component Library & Design systems

Auto Layout, Styles & Variables

Designing for website and applications

Design prototyping and micro interactions

Developer Handover

how will you learn?

We'll Guide You Every Step of the Way

From immersive bootcamps to self-paced micro-learning, we’re here to guide you at every turn. Experience the best and flexible learning experience tailored just for you.

Interactive Learning

Robust content and Videos

Self-paced + Live Classes

Assessments and projects

Best in class

Weekend classes

Intensive training

Focus on real live scenario

Skill & Career Guidance

Internship Placement Assistance

Soft skills training workshops

Interview Prep Workshops

Capstone Project

Work on a variety of projects

Close mentorship from tutors

QnA sessions

Certificate of completion

Get certificate at the end of your course

Validate your skills and impress employers: Earn a course completion certificate upon finishing.

Building a rewarding and fulfilling career has never been easier

Meet your tutor

Pay 70% at start, the rest in week 6

Comfortably spread your tuition by paying 70% upfront and balancing up in 6 weeks after course kick-off (Live classes only)

Wanna hear what our
students say about us?

Take a dive into the amazing reviews from techies who have passed through our training

The tutor's expertise and patience in teaching made complex concepts really digestible for me. Her guidance gave me understanding of data engineering principles and techniques. She equipped me with practical skills essential for real-world applications. I now feel confident in my ability to tackle data challenges.
Samuel Olwajobi
Verdac Alumni
As someone transitioning into tech and very new to Data being clouded with different tools and concepts, I was mentored by Niniola and she gave me roadmaps that was really helpful for my growth and learning. She was very instrumental in my career growth and the tips that I was given really helped me.
Daniel Nnadi
Verdac Alumni
Niniola was an outstanding supervisor during my Internship, particularly in guiding me through data analytics.
The tutor provided valuable guidance on storytelling, visualization selection, and understanding report data which enhanced my Power BI skills.
Daniel Nnadi
Verdac Alumni
I had the opportunity of being supervised by Niniola in the early years of my data analytics journey, she held my hand throughout the process and created a solid foundation which I built on.
Eniola Odejimi
Verdac Alumni
I was able to understand and master data engineering essentials with ease, the tutor's clear explanations and hands-on approach made learning a great experience for me.
Olasubomi Akinade
Verdac Alumni

Wondering if this programme is right for you?

Take a dive into the amazing reviews from techies who have passed through our training

Request a callback

Let us know if we should call you and we will reach out to you within 24 hours

Join a taster session

Join our next taster session where you get to witness how our tutors teach.

Next step quiz

Not sure about the right path yet? take the next step quiz.

Join hundreds of tech enthusiasts to
revolutionize the future of tech

Experience Verdac

Join our next taster session

Join our next taster session where you get to witness how our tutors teach.

Kickstart your tech career!

Pay in installment or in full, Get best in class learning for almost nothing!

Enroll now and unlock a world of opportunity.

Witness our class session

Join our free 1hour taster session

Get first hand introduction into your path of study by our world class mentors.

Kickstart your tech career

Ready to upskill? We've been waiting for you!

You might just be one step away from changing your life. kindly complete the form below.

Kickstart your tech career!

Pay in installment or in full, Get best in class learning for almost nothing!

Enroll now and unlock a world of opportunity.

Kickstart your tech career!

Pay in installment or in full, Get best in class learning for almost nothing!

Enroll now and unlock a world of opportunity.

Kickstart your tech career!

Pay in installment or in full, Get best in class learning for almost nothing!

Enroll now and unlock a world of opportunity.

Kickstart your tech career!

Pay in installment or in full, Get best in class learning for almost nothing!

Enroll now and unlock a world of opportunity.

Make positive Impact

Be the next to drive positive change and shape the future.

Africa’s untapped talent is ready to change the world. We’re making it happen.

Make positive Impact

Be the next to drive positive change and shape the future.

Africa’s untapped talent is ready to change the world. We’re making it happen.

×