Getting to know each other
Learning Approach
Computer
History of Computer
What is a Operating System?
Unix based OS
Introduction to Command Line Interface
Unix Commands
Shell script
What is Data?
Basics of Data structures
Different Types of Data
What is a Relational Database Management systems
Tables
Primary key and Foreign key
Data Normalization
Entity Relationship
Oracle VM
Ubuntu
MySQL Installation
Working with MySQL
Creating the Database & Table
Import data from csv files
CRUD operations - Create, Insert, Update and Delete
Introducing SQL queries
Joins and Subqueries
stored producers
functions
Execution plan
Analyze and optimize
Python Basics & Functional Programming
What is Python
Introduction to Python
Setup and configuration of Python and IDE
Data Types
Variables and Operators
Loops and collections- Array, Map, Lists, Tuples
Functions and Control Flow Structures
Numpy and pandas
visualization
Object-Oriented Programming
Introduction to object-oriented programming
Different OOPS concepts
Nested Classes and visibility rules
Sql using Python
DWH Concepts and Design
(Data lakes, Data Mesh, Data virtualization, Data Fabrics)
Facts and Dimension tables
Dimensional Modeling
SCD-1 and SCD-2
Data Storage and Processing(ETL and ELT)
Difference between ETL vs ELT
Emergence of the Big Data
Basic Terminologies
Central Theme of Big Data
Requirements of a Programming Model
Big Data Introduction
Failure of Traditional system to handle Big Data
Importance/Applications of Big Data
Setting up the Azure Subscription
Hadoop Introduction
Hadoop Core Components- HDFS, MapReduce & Daemon Processes
Hadoop Work-flow Architecture
Hadoop Flavors – Apache, Cloudera, Hortonworks, and more
$ads={1}
HDFS Architecture
HDFS Master-Slave Architecture & Design Principle
Regular File System vs HDFS
Block Distribution , Replication & Fault Tolerance
Namenode, Datanode, Secondry Namenode
Hadoop Directory Structure, FS Image, Editlog, Share Log, Chk Point
HDFS /Namenode Federation, Namenode High Availability
Troubleshooting encountered problems
HDFS - Handson
Basics of Azure data services like Azure Data Factory, Databricks, Synapse
Transactional Processing vs Analytical Processing
Hive as an open source Data Warehouse
Adhoc SQL based solution – Apache Hive
Introduction to and architecture of Hadoop Hive
Playing with the Hive shell and running HQL queries
Hive DDL and DML operations(How it is different from MySQL)
Hive execution flow
Schema design and other Hive operations(How it is different from MySQL)
Schema-on-Read vs Schema-on-Write in Hive
Meta-store management and the need for RDBMS
Limitations of the default meta-store
Loading Data into Hive
Hive Query Language(HQL)
Manage and External Table
Using SerDe to handle different types of data
Optimization of performance using partitioning & Bucketing
Apache Hive View and Hive Index
Writing various Quaries on Real-World Datasets
Apache Sqoop - Introduction
Introduction and working of Sqoop
Importing data from RDBMS to HDFS
Exporting data to RDBMS from HDFS
MongoDB Introduction to NoSQL Databases, CAP Theorem
Mongo DB introduction
CRUD operations with MongoDB
PyMongo - connecting MongoDB with Python
Indexing and Aggregation framework
MongoDB Architecture - Shards, Replica setsc
Cassandra - Overview
Advantages of Cassandra
Environment setup
Data Modeling
CQLSH,Create keyspace, Drop keyspace, Create Column Family, Drop Column Family, Data Types
Insert Document, Query Document, Update Document, Delete Document, Partitions
Replication Strategy, Sorting Records, Indexing, Aggregation
Basics of Power BI
Job Types: Part-time, Freelance
Contract length: 7 weeks
Part-time hours: 10 per week
Salary: ₹1,400.00 - ₹1,500.00 per hour
Benefits:
- Work from home
Schedule:
- Day shift
- Evening shift
- Monday to Friday
- Morning shift
Experience:
- Big data: 4 years (Required)
- total work: 7 years (Required)
Speak with the employer
+91 9602880219
Application Deadline: 18/07/2023
Expected Start Date: 24/07/2023
