- Python Fundamentals
- Why Python and how it is different from the R programming language
- Variables, Identifiers, and Keywords in Python
- Data Structures in Python
- Strings, Array, Lists, Tuples, Set and Dictionaries
- Python Conditionals and Loops
- If, Nested If, Indentations
- Loops in Python
- Basic Operation and Operator in Python
- Operators in Python
- OOPs Concept
- Python Functions and Classes
- Functions and their types
- Classes in Python
- Type Conversion
- Lambda Functions
- Data Wrangling using Numpy
- Numpy for Data Engineers
- Data Wrangling using Pandas
- Pandas for Data Engineers
- Python for Visualisation
- Matplotlib
- Seaborne
Express Bootcamp for Data Engineering
Learn the topics that are associated with data engineering by enrolling on the Express Bootcamp for Data Engineering ...Read more
Online
3 Months
$ 60000 70000
Quick Facts
particular | details | |||
---|---|---|---|---|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Course overview
The Express Bootcamp for Data Engineering certification course is a 3-4 months online course. Offered by Board Infinity, this course on data engineering will be good for all the candidates in the beginner, and intermediate stages. The classes are offered only online modes with live sessions of training using other means like case studies, different activities, and quizzes.
The Express Bootcamp for Data Engineering training also offers different Bootcamp sessions for honing the skills in data engineering that can make the students job-ready. The live classes are usually taken care of by the experts in the industry in a span of just a few months. The Bootcamp sessions are designed with the aim of giving hands-on experience in Big Data Hadoop, Python Programming, SQL, and AWS.
The highlights
- 3- 4 months course
- Completely online programme
- Live classes conducted
- 60+ hours of training
- Shareable certificate of completion
Program offerings
- Live training
- Completion certificate
- Placement opportunity
- 6+ tools & skills
- Career services
- Bootcamp projects
- On-demand videos
- Assignments
- Case studies
- Projects
Course and certificate fees
Fees information
The Express Bootcamp for Data Engineering certification fee is Rs. 70,000. This fee can be broken into easy EMI facilities with the help of financers like Eduvanz, Credit Fair, and Bajaj Finserv.
Express Bootcamp for Data Engineering Fee Structure
Description | Amount in INR |
Course Fee, EMI Basis | Rs. 10,000/Month |
Total Training Fee | Rs. 70000 |
certificate availability
Yes
certificate providing authority
Board Infinity
Who it is for
Below are those students who would gain benefits from learning this programme:
- Data Engineer
- ETL Developer
- Big Data Engineer
- Data Warehouse Engineer
Eligibility criteria
Certification Qualifying Details
As soon as the course with its modules, case studies, assignments, and projects are completed, the Express Bootcamp for Data Engineering certificate by Board Infinity.
What you will learn
After completion of the Express Bootcamp for Data Engineering certification syllabus, the students shall learn the following:
- Understanding the concepts of the life cycle of data engineering.
- Understand the ways to find out the different ways to deal with real-world data engineering problems.
- The candidates will get advanced sessions on SQL, python, data science, and python libraries for analysis of huge databases.
- Learning to solve the different data engineering project pipelines.
- Present the different kinds of data engineering insights to the stakeholders.
- The students will also learn separate technologies related to Big Data with Hadoop and Spark.
The syllabus
Week 1: Python Programming
Week 2: Data Visualization with Tableau
- Introduction to SQL
- Introduction to Databases
- What is Database
- Introduction to MySQL and NoSQL
- DDL v/s DML v/s DCL v/s TCL
- Datatypes in SQL
- Basics of SQL
- Basic SQL statements (SELECT, DELETE, and UPDATE)
- How to convert data into tables
- COMMIT and ROLLBACK statements
- Filtering Data using SQL
- Filter Data using the WHERE and ORDER BY Clause
- Usage of Filtering Operators – IN, NOT IN, IS NULL, BETWEEN
- Regular Expression for Filtering
- Functions in Database
- Basics of Function
- Boolean Expressions and Concatenation
- String Function
- Grouping Function
- Introduction to SQL
- Grouping Data and Computing Aggregates
- Introduction to Grouping
- Using GROUP BY & HAVING
- Subqueries and Nested queries in SQL
- Single-Row, Multiple-Row Subqueries
- Subqueries with ANY and ALL Operators
- Conditional Expressions using CASE Clause
- Correlated Subqueries
- Windows Functions in SQL
- Intro to window functions
- Basic windowing syntax
- The usual suspects: SUM, COUNT, and AVG ROW_NUMBER() RANK() and DENSE_RANK() NTILE LAG and LEAD
- Defining a window alias
- Advanced windowing techniques
- Displaying Data from Multiple tables
- Introduction to Joins and its types
- Using UNION, UNION ALL, and EXPERT Clause Views, Sequences, and Indexes in SQL
Week 3: Big Data with Hadoop and Spark
- Big Data with Hadoop
- Introduction to Big Data and Hadoop
- Hadoop Architecture, Distributed Storage (HDFS)
- Data Ingestion into Big Data Systems and ETL
- Distributed Processing Map-Reduce Framework and Pig
- Apache Hive
- NoSQL Database
- Big Data with PySpark
- Introduction to PySpark
- Resilient Distributed Datasets
- PySpark UDF
- Broadcast and Accumulator
- PySpark Storage level
- Data frames and Transformations
- Data Processing with Spark Data Frames
- Sorting Technique
- PySpark RDD
- Broadcast & Accumulator
- PySpark SparkFiles
- PySpark StorageLevel
- PySpark Profiler
- PySpark StatusTracker
- PySpark Serializer
- Dataframes and Spark SQL
- Spark SQL
- PySpark SQL(Running SQL query on Spark)
- Creating DataFrames
- Transforming and Querying DataFrames
- Saving DataFrame
- DataFrames and RDDs
- Comparing Spark SQL, Impala, and Hive-on-Spark
- Big Data with Spark
- Apache Spark Next Generation
- Spark Core Processing
- Spark SQL – Processing Data Frames
- Stream Processing Frameworks and Spark Streaming
- RDD Operation
- RDD Persistence Overview
- Key value-based RDD
- Comparing Spark SQL, Impala, Hive on Spark
- Deploying Spark SQL
- Creating the SparkContext
- Building a Spark Application using PySpark
- The Spark Application Web UI
- Configuring Spark Properties
- Running Spark on Cluster
- RDD Partitions
- Executing Parallel Operations
- Stages and Tasks
Week 4: Cloud Engineering - Amazon Web Services (AWS)
- How to build data pipelines in cloud
- Glue/Step – AWS etc.
- Various services hands on
- AWS EC2, AWS S3 etc
- Introduction to AWS
- AWS Overview History and Evolution of AWS
- Knowledge Check Overview of AWS Products and Services
- How to configure / decide service
- Ex: App service configuration within AWS
- AWS EC2 – how to choose the machine based on the requirement?
- How to build a data lake using AWS S3 / Blob Storage?
- Best Practices
- Folder naming conventions etc.
- Cloud Data Warehouse: AWS RedShift
- Back-end architecture
- How to create & work objects
- Databases
- Clone
- Time travel
- Un-drop
- Keys
- Schema
- Access Control - Important
- Cloud Engineering - Amazon Web Services (AWS)
- Best Practices of Cloud Platform
- What are the best practices?
- Integration using Cloud engineering services
- How to establish API to the DW
- Performance considerations
- Work with AWS Redshift, Kinesis as Database
Week 5: Orchestration Tool - Airflow
- Orchestration Tool - Airflow
- Introduction to Airflow
- Apache Airflow
- Installation on Cloud
- Usage
- Connectivity
- Troubleshooting
- Upgrade
- End-to-End data pipeline using Airflow
Admission details
To get admission to the Express Bootcamp for Data Engineering classes, the students may follow the steps:
Step 1: Follow the official URL: https://www.boardinfinity.com/learning-path/data-engineering-bootcamp.
Step 2: Then the Book Your Slot’ has to be clicked, wherein a form with some basic information has to be submitted.
Step 3: After the details are submitted the students’ eligibility gets checked, and the fee deposit marks the beginning of getting admission.
Scholarship Details
Both the freshers and the ones with minimal work experience are given certain opportunities to be able to secure scholarships in consultation with career counsellors who are rated as the top ones in the industry.
How it helps
The Express Bootcamp for Data Engineering certification benefits every enrolled candidate by giving them an offer of learning Bootcamp projects thereby increasing exposure to practical concepts. All these learnings are backed by great student-mentor interaction. These projects are endorsed by top companies hence learnings will be matching the expectations.
Instructors
FAQs
Why should a candidate learn this course from Board Infinity?
Since the candidates get job opportunities also so this Board Infinity course is ideal.
For the Express Bootcamp for Data Engineering online course what are the prerequisites?
The prerequisite is only having a passion to learn data engineering.
Are there specific requirements of technology for this online programme?
Technology requirements are only open when the students get on with their enrolment.
How will the students get evaluated for placement services?
During the entire course, the students will have to maintain a pretty decent score for qualifying for placements.
What kind of certificate is given to the students of Express Bootcamp for the Data Engineering programme?
A certificate of recognition is given to the candidates.