Data Engineering Courses / Workshops

Duration: 8 Weeks

Course Level: Beginner to Advanced

Objectives:

To equip students with a thorough understanding of the Unix/Linux environment, from basic command-line usage to advanced system administration and networking, preparing them to manage and automate tasks in Unix/Linux-based systems.

Price: CAD 49 | INR 3000

Course Outline:

1. Introduction to Unix/Linux – Basics of the OS and command-line usage
2. File Management and Permissions – File operations, permissions, and ownership
3. Text Processing and Command-Line Tools – grep, awk, sed, and file search tools
4. Shell Scripting – Writing scripts, loops, and functions
5. System Administration Basics – User management, disk management, logging
6. Networking and Security – Network configuration, SSH, firewalls, and security basics
7. Advanced Topics – Systemd, cron jobs, Docker basics, and server setup
8. Project – Build a functional server environment with automation

---

Duration: 6 Weeks

Course Level: Intermediate

Objectives:

Introduce fundamental data engineering concepts, including data pipelines, ETL, and data storage, for building robust data solutions.

Price: CAD 82| INR 5000

Course Outline:

1. Introduction to Data Engineering Concepts
2. Data Pipelines and ETL Basics
3. Data Storage Systems
4. SQL for Data Engineering
5. Data Quality and Governance
6. Project: Build an ETL Pipeline

---

Duration: 6 Weeks

Course Level: Intermediate to Advanced

Objectives:

To develop expertise in DBT for efficient data transformations in modern data warehouses, focusing on SQL transformations, testing, and version control for real-world data engineering tasks.

Price: CAD 82| INR 5000

Course Outline:

1. Introduction to DBT – Basics of DBT and project setup
2. SQL Modeling – Writing SQL models, using Jinja for transformations
3. Data Management – Incremental models, seeds, and snapshots
4. Version Control – Git integration and project versioning
5. Testing and Documentation – Data quality testing and DBT documentation
6. Deployment – Scheduling, orchestration with Airflow, and production optimization

---

Duration: 6 Weeks

Course Level: Beginner to Intermediate

Objectives:

To introduce students to Python programming, covering the fundamentals, data structures, object-oriented programming, and libraries for data manipulation, preparing them for real-world applications and further programming studies.

Price: CAD 49 | INR 3000 FREE

Course Outline:

1. Introduction to Python – Basic syntax, variables, and data types
2. Control Structures – Conditionals, loops, and functions
3. Data Structures – Lists, tuples, dictionaries, and sets
4. Object-Oriented Programming – Classes, inheritance, and polymorphism
5. File Handling and Exception Management – File I/O, error handling
6. Libraries and Modules – Introduction to libraries like NumPy and Pandas
7. Project – Develop a small application or data analysis script

---

Course Hosted by: Subhadip Mukherjee, Price: 75USD/6000INR

Please check the details in the below page:

Data Engineering workshop using Python

Duration: 8 Weeks

Course Level: Intermediate

Objectives:

To understand core data structures and algorithms essential for problem-solving, preparing students for technical interviews and advanced studies.

Price: CAD 65| INR 4000

Course Outline:

1. Introduction to Data Structures and Complexity Analysis
2. Arrays, Stacks, and Queues
3. Linked Lists and Recursive Algorithms
4. Trees and Binary Search Trees
5. Hashing and Graph Theory
6. Sorting and Searching Algorithms
7. Advanced Algorithms and Dynamic Programming
8. Project: Develop Solutions Using DSA

---

Duration: 6 Weeks

Course Level: Beginner

Objectives:

To provide a strong foundation in C programming, covering syntax, control structures, and memory management, and preparing students for complex programming tasks and further studies in computer science.

Price: CAD 49 | INR 3000

Course Outline:

1. Introduction to C Programming
2. Variables, Data Types, and Operators
3. Control Structures and Functions
4. Pointers and Memory Management
5. Structures, Unions, and File I/O
6. Project: Develop a Simple Application in C

---

Duration: 6 Weeks

Course Level: Beginner to Intermediate

Objectives:

This course covers object-oriented programming in C++, teaching students the principles of classes, inheritance, and polymorphism, preparing them for real-world programming.

Price: CAD 49 | INR 3000

Course Outline:

1. Introduction to C++ and Object-Oriented Concepts
2. Basic Syntax and Data Types
3. Control Structures and Functions
4. Classes and Objects
5. Inheritance and Polymorphism
6. Project: Develop an OOP-Based Application

---

Duration: 6 Weeks

Course Level: Beginner to Intermediate

Objectives:

Introduce students to Java and object-oriented programming principles, providing them with skills for building platform-independent applications.

Price: CAD 49 | INR 3000

Course Outline:

1. Introduction to Java and OOP
2. Data Types, Variables, and Operators
3. Control Statements and Functions
4. Classes, Inheritance, and Polymorphism
5. Exception Handling and File I/O
6. Project: Building a Java-Based Application

---

Course Hosted by: Subhadip Mukherjee, Price: 30USD/2400INR FREE [Python Basic workshop is always free]

1: Introduction to Python

• Lesson 1.1: What is Python? History and Overview
• Lesson 1.2: Installing Python and Setting Up the Development Environment
• Lesson 1.3: Writing and Running Your First Python Program
• Lesson 1.4: Python Syntax and Indentation

2: Basic Data Types and Operations

• Lesson 2.1: Variables and Data Types (int, float, str, bool)
• Lesson 2.2: Basic Arithmetic Operations
• Lesson 2.3: String Manipulation and Formatting
• Lesson 2.4: Working with Booleans and Comparison Operators

3: Control Flow

• Lesson 3.1: Conditional Statements (if, elif, else)
• Lesson 3.2: Loops (for, while)
• Lesson 3.3: List Comprehensions

4: Data Structures

• Lesson 4.1: Lists and Tuples
• Lesson 4.2: Dictionaries and Sets
• Lesson 4.3: Introduction to Arrays (using the array module)

5: Functions

• Lesson 5.1: Defining and Calling Functions
• Lesson 5.2: Function Parameters and Return Values
• Lesson 5.3: Lambda Functions
• Lesson 5.4: Scope and Lifetime of Variables

6: Working with Modules and Packages

• Lesson 6.1: Importing Modules
• Lesson 6.2: Creating Your Own Modules
• Lesson 6.3: Using Python Standard Libraries

7: File Handling

• Lesson 7.1: Reading from and Writing to Files
• Lesson 7.2: Working with CSV and JSON Files
• Lesson 7.3: Handling File Exceptions

8: Error Handling

• Lesson 8.1: Understanding Exceptions
• Lesson 8.2: Try, Except, and Finally Blocks
• Lesson 8.3: Raising and Creating Custom Exceptions

Course Hosted by: Subhadip Mukherjee, Price: 50USD/4000INR

9: Object-Oriented Programming (OOP)

• Lesson 9.1: Introduction to Classes and Objects
• Lesson 9.2: Inheritance, Polymorphism, and Encapsulation
• Lesson 9.3: Abstract Classes and Methods
• Lesson 9.4: Magic Methods and Operator Overloading

10: Advanced Data Structures

• Lesson 10.1: Working with Advanced Collections (Deque, NamedTuple)
• Lesson 10.2: Sets, Frozensets, and Counters
• Lesson 10.3: Linked Lists and Trees (Introduction)
• Lesson 10.4: Stacks and Queues

11: Functional Programming

• Lesson 11.1: Higher-Order Functions
• Lesson 11.2: Map, Filter, and Reduce
• Lesson 11.3: Decorators
• Lesson 11.4: Generators and Iterators

12: Working with Databases

• Lesson 12.1: Introduction to SQL and Database Operations
• Lesson 12.2: Using SQLite with Python
• Lesson 12.3: Connecting to MySQL/PostgreSQL
• Lesson 12.4: ORM with SQLAlchemy

13: Web Development with Python

• Lesson 13.1: Introduction to Flask
• Lesson 13.2: Building RESTful APIs
• Lesson 13.3: Template Rendering with Jinja2
• Lesson 13.4: Introduction to Django (Optional)

14: Data Science and Machine Learning

• Lesson 14.1: High performing data management: Working with Libraries like NumPy, Pandas, Dask, Vaex etc.
• Lesson 14.2: Data Visualization with Matplotlib and Seaborn
• Lesson 14.3: Introduction to Scikit-Learn for Machine Learning
• Lesson 14.4: Working with Real-World Data (Capstone Project)

15: Testing and Debugging

• Lesson 15.1: Writing Unit Tests with unittest and pytest
• Lesson 15.2: Debugging Techniques and Tools
• Lesson 15.3: Code Profiling and Optimization

16: Deployment and Version Control

• Lesson 16.1: Introduction to Git and GitHub
• Lesson 16.2: Continuous Integration and Deployment (CI/CD)
• Lesson 16.3: Packaging Python Applications
• Lesson 16.4: Deploying Python Applications to the Cloud

Duration: 6 Weeks

Course Level: Intermediate

Objectives:

To provide a comprehensive understanding of computer architecture and the functioning of digital systems, preparing students for systems programming and hardware interaction.

Price: CAD 49 | INR 3000

Course Outline:

1. Introduction to Computer Architecture
2. Digital Logic and Gates
3. Memory and Storage Systems
4. Instruction Set Architecture and Microarchitecture
5. CPU Design and Pipelining
6. Project: Design a Simple Processor Model

---

Duration: 6 Weeks

Course Level: Intermediate

Objectives:

This course aims to develop an understanding of operating systems’ internal mechanisms, covering processes, memory management, and file systems.

Price: CAD 49 | INR 3000

Course Outline:

1. Introduction to Operating Systems
2. Process Management and Scheduling
3. Memory Management Techniques
4. File Systems and Storage Management
5. Interprocess Communication and Synchronization
6. Project: Implement Basic OS Concepts

---