Purdue University - Professional Certificate Program in Data Engineering 

Induction Session for Purdue Data Engineering Program

PC DE: Python Basics for Data Engineering

Procedural and OOP understanding

Python and IDE installation

Jupyter Notebook usage mastery

Implementing identifiers, indentations, comments

Python data types, operators, string identification

Types of Python loops comprehension

Variable scope in functions exploration

OOP explanation and characteristics

PC DE: Database Management using SQL

Databases and their interconnections

Popular query tools and handle SQL commands

Transactions, table creation, and utilizing views

Execute stored procedures for complex operations

SQL functions, including those related to strings, mathematics, date and time, and pattern matching

Functions related to user access control to ensure the security of databases

PC DE: NoSQL Mastery with MongoDB

Understanding MongoDB

Document structure and schema design

Data modeling for scalability

CRUD operations and querying

Indexing and performance optimization

Security and access control

Data management and processing

Integration and scalability

Developing data pipelines

Monitoring and performance optimization

PC DE: Big Data with Hadoop and Spark

Hadoop ecosystem and optimization

Ingest data using Sqoop, Flume, and Kafka

Partitioning, bucketing, and indexing in Hive

RDD in Apache Spark

Process real-time streaming data

DataFrame operations in Spark using SQL queries

User-Defined Functions (UDF) and User-Defined Attribute

Functions (UDAF) in Spark

PC DE: AWS Tech Essentials

Understand the fundamental concepts of the AWS platform and cloud computing

Identify AWS concepts, terminologies, benefits, and deployment

options to meet business requirements

Identify deployment and network options in AWS

PC DE: AWS Certified Data Engineer - Associate

Data engineering fundamentals

Data ingestion and transformation

Orchestration of data pipelines

Data store management

Data cataloging systems

Data lifecycle management

Design data models and schema evolution

Automate data processing by using AWS services

Maintain and monitor data pipelines

Data Security and Governance

authentication mechanisms

authorization mechanisms

data encryption and masking

Prepare logs for audit

data privacy and governance

PC DE: Azure Fundamentals

Describe Azure storage and create Azure web apps

Deploy databases in Azure

Understand Azure AD, cloud computing, Azure, and Azure subscriptions

Create and configure VMs in Microsoft Azure

PC DE: Azure Data Engineer

Implement data storage solutions using Azure SQL Database, Azure

Synapse Analytics, Azure Data Lake Storage, Azure Data Factory

Azure Stream Analytics, Azure Databricks services

Develop batch processing and streaming solutions

Monitor Data Storage and Data Processing

Optimize Azure Data Solutions

PC DE: Capstone

By the end of the course, you can showcase your newly acquired skills in a hands-on, industry-relevant capstone project that combines everything you learned in the program into one portfolio-worthy example

Electives:

Generative AI Masterclass

Attend live generative AI masterclasses and learn how to leverage it to streamline workflows and enhance efficiency

Conducted by industry experts, these masterclasses delve deep into AI-powered creativity

PC DE: Snowflake SnowPro Core Certification

Snowflake structure

Overview and Architecture

Data protection features

Cloning

Time travel

Metadata and caching in Snowflake

Query performance

Data Loading

PC DE: Google Cloud Platform Fundamentals

The GCP Fundamentals course will teach you to analyze and deploy infrastructure components such as networks, storage systems, and application services in the Google Cloud Platform

PC DE: Version Control using Git

This course introduces Source Code Management (SCM), focusing on Git and GitHub