Skip to content

Bootcamps
About
Explore
Get started
- Sign up
- Log in
Book a Consultation

Bootcamps
About
Explore
Get started
- Sign up
- Log in
Book a Consultation

Data Engineering Specialization

Home
Courses
Data Engineering Specialization

Current Status

Not Enrolled

Price

Closed

Get Started

This course is currently closed

Course & topics

Course Home Expand All

Section 1 - Advanced SQL for Data Engineering

Week 1 – Day 1 – Setting up the Environment and Overview of Relational Database

10 Topics

1. Introduction to the Course

2. Data Scientist vs Data Engineer

3. How to Become a Data Engineer

4. How Data Engineering Works

5. What is Data Engineering

6. Course GitHub Repository

7. Setting up the Environment

8. An Overview of Relational Databases

9. DDL, DML, DQL, DCL.

Week 1 – Day 2 – Manipulating Databases; Mastering Essential SQL Statements

8 Topics

1. Intro SQL Statements

Week 1 – Day 3 – Timing is Everything; Managing and Manipulating Date Time in SQL

4 Topics

1. Date Time Intro

2.Different Date Time Types

Week 1 – Day 4 – Complex Datatypes; ENUMS, Arrays, Ranges, and Nested Data in SQL

4 Topics

Week 2 – Day 1 – Advanced Query Techniques; Exploring OVER, JOINS, CASE and more in SQL

9 Topics

3. Lateral Join

4. Cross Join Lateral

8. Recursive CTE

9. Recursive CTE – Second Part

Week 2 – Day 2 – Optimizing Data Structures; The Art and Science of Data Normalization in SQL

4 Topics

1. Data Normalization (1 of 3)

2. Data Normalization (2 of 3)

3. Data Normalization (3of 3)

4. STAR Schema Snowflake

Week 2 – Day 3 – Performance and Control; Mastering Stored Procedures, temporary tables, and Control Structures in SQL

7 Topics

1. Stored Procedures and UDFs (1 of 3)

2. Stored Procedures and UDFs (2 of 3)

3. Stored Procedures and UDFs (3 of 3)

5. Materialized View

6. Transactions

7. SQL Structures

Week 2 – Day 4 – Practical Tasks

4 Topics

Section 2. Building Data Pipelines Extract Transform, and Load backup

Week 3

Week 3 – Day 1

7 Topics

Building Our Data Engineering Infrastructure

Apache NiFi Lecture – Introduction.

ETL & Data Flow

Apache NiFi Introduction

Why We Need Apache NiFi – Enterprise Data Flow Problem

Why We Need Apache NiFi – Challenges in EDFPP

Why We Need Apache NiFi – Key Features and Capabilities

Week 3 – Day 2

12 Topics

Reading and Writing Files

Apache Nifi Installation – NiFi User Interface

Apache Nifi Installation – Understand Key Terminologies Practically with Demo

Apache Nifi Installation – JDK Installation

Apache Nifi Installation – NiFi Installation

Apache Nifi Installation – Update NiFi Username

Apache Nifi Hands-On-Basics – Flow File Internals and Repositories

Apache Nifi Hands-On-Basics – Generate Flow Files

Apache Nifi Hands-On-Basics – Expression Language

Apache Nifi Hands-On-Basics – Expression Language Use Case Implementation

Apache Nifi Hands-On-Basics – Funnel

Apache Nifi Hands-On-Basics – Variables

Week 3 – Day 3

12 Topics

Apache NiFi Hands-on-In Depth – Process Group in Data pipeline

Apache NiFi Hands-on-In Depth – Parameter Context Introduction

Apache NiFi Hands-on-In Depth – Parameter Context Implementation

Apache NiFi Hands-on-In Depth – Templates in NiFi

Apache NiFi Hands-on-In Depth – Controller Services

Apache NiFi Hands-on-In Depth – Controller Services Demo with MySQL Integration

Advance Concepts – Data Provenance

Advance Concepts – Debugging Pipeline Using Data Provenance

Advance Concepts – Flow File Expiration

Advance Concepts – Back Pressure and Threshold

Advance Concepts – Flow File Prioritization

Advance Concepts – Priority Attribute Prioritizer

Week 3 – Day 4

8 Topics

Working with Databases

Logging in NiFi

Logging in NiFi- Pipeline Monitoring

Logging in NiFi- Cluster and Resource Monitoring

Custom Processor – Introduction

Custom Processor – NiFi Archetypes & Installation of Maven

Custom Processor – Generate Template for Custom Processor

Custom Processor – Develop and Deploy NiFi Custom Processor

Week 4

Week 4 – Day 1

1 Topic

Cleaning, Transforming and Enriching Data

Week 4 – Day 2

1 Topic

Building a 311 Data Pipeline

Section 3: Deploying Data Pipelines in Production

Week 4 – Day 3

1 Topic

Features of a Production Pipeline

Week 4 – Day 4

2 Topics

Version Control with the NiFi Registry

Monitoring Data Pipelines

Week 5

Week 5 – Day 1

1 Topic

Deploying Data Pipelines

Section 4: Beyond Batch – Building Real-Time Data Pipelines

1 of 2

© 2026 Dataset Nexus Tech. All rights reserved.

Contact
Careers
Privacy
Terms
Refund

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account

Username

Email

Registration confirmation will be emailed to you.