Careers360 Logo
Interested in this College?
Get updates on Eligibility, Admission, Placements Fees Structure
Compare

Quick Facts

Medium Of InstructionsMode Of LearningMode Of Delivery
EnglishSelf Study, Virtual ClassroomVideo and Text Based

Courses and Certificate Fees

Certificate AvailabilityCertificate Providing Authority
yesMIT Cambridge

The fees for course Data Engineering Course is -

HeadAmount
Total Admission Fee
₹ 1,59,030 (Inclusive of All)
EMI Starts at
₹ 8,000

The Syllabus

  • Introduction to SQL
  • Database Normalization and Entity Relationship Model
  • SQL Operators
  • Join, Tables, and Variables in SQL
  • Deep Dive into SQL Functions
  • Subqueries in SQL
  • SQL Views, Functions, and Stored Procedures
  • User-defined Functions in SQL
  • SQL Optimization and Performance
  • SQL Parsing
  • Managing Database Concurrency

  • Python Basics
  • OOPs Concept
  • NumPy
  • Pandas
  • Data Visualization
  • File Handling
  • Exception Handling
  • Regular Expressions Fundamentals

  • Introduction to Linux
  • File System Navigation
  • File and Text Manipulation
  • User and Group Management
  • Process Management
  • System Configuration and Networking
  • System Monitoring and Logging
  • Shell Scripting
  • Security and Permissions
  • Advanced Linux Commands

  • Basic Concepts of Data Modelling
  • Business Data Requirements – Entities and Classes
  • Business Data Requirements – Attributes
  • How To Link Things Together – Relationships
  • Requirements Analysis
  • Conceptual Data Modeling
  • Logical Data Modeling
  • Physical Data Modelling
  • Data Modelling Tools and Techniques
  • Data Modelling Documentation and Communication

  • AWS Basics
  • Amazon Kinesis
  • Amazon MSK (Managed Streaming for Apache Kafka)
  • AWS Glue
  • Amazon EMR (Elastic MapReduce)
  • Amazon S3 (Simple Storage Service)
  • Amazon S3 Glacier
  • DynamoDB
  • AWS Redshift
  • Amazon Athena
  • Amazon QuickSight

  • Introduction to Microsoft Azure
  • Authentication, Authorization, and Monitoring
  • Data Storage and Integration
  • Azure Synapse Analytics and Databricks
  • Azure Stream Analytics, and Azure Service Bus

  • Introduction to Airflow
    • Introduction to Airflow
    • Testing a Task in Airflow
    • Examining Airflow Commands
    • Airflow DAGs
    • Defining a Simple DAG
    • Working With DAGs and the Airflow Shell
    • Troubleshooting DAG Creation
    • Airflow Web Interface
    • Starting the Airflow Webserver
    • Navigating the Airflow UI
    • Examining DAGs With the Airflow UI
  • Airflow Operators
    • Defining a BashOperator Task
    • Multiple BashOperator
    • Airflow Tasks
    • Define Order of BashOperator
    • Determining the Order of Tasks
    • Troubleshooting DAG Dependencies
    • Additional Operators
    • Using the PythonOperator
    • More PythonOperator
    • EmailOperator and Dependencies
    • Airflow Scheduling
    • Schedule a DAG via Python
    • Deciphering Airflow Schedules
    • Troubleshooting DAG Runs

  • Introduction to Apache Spark
  • PySpark SQL and Data Frames
  • Apache Kafka and Flume
  • PySpark Streaming
  • Introduction to PySpark Machine Learning

  • Introduction to DevOps
  • Git
  • Docker
  • Kubernetes
  • Jenkins

  • Introduction to Power BI
  • Data Extraction
  • Data Transformation – Shaping & Combining Data
  • Data Modeling & DAX (Data Analysis Expressions)
  • Data Visualization with Analytics
  • Power BI Service (Cloud), Q & A, and Data Insights
  • Power BI Settings, Administration & Direct Connectivity
  • Embedded Power BI with API & Power BI Mobile
  • Power BI Advance & Power BI Premium

Articles

Back to top