Data Engineering Professional(Zero Experience)

Data Engineering Practical Program(Arabic)

What you'll learn
You will become a junior data engineer
You'll be able to discuss and carry out the key responsibilities of a data engineer.
You will use the Python programming language and Linux/UNIX shell scripts to extract, transform and load (ETL) data.
You will work with Relational Databases (RDBMS) and query data using SQL statements. You will use NoSQL databases and unstructured data.
You will be introduced to Big Data and work with Big Data engines like Hadoop and Spark. You will gain experience with creating Data Warehouses.
You will work with AWS Cloud(Free email for all students)
Solve more than 115 Problem Solving for Python and more than 60 problem for SQL
You will implement more than 5 projects
Requirements
No programming experience needed
Description
Anyone who wants to develop job-ready skills, tools, and a portfolio for an entry-level data engineer position.You will become a junior data engineerYou'll be able to discuss and carry out the key responsibilities of a data engineer.You will use the Python programming language and Linux/UNIX shell scripts to extract, transform and load (ETL) data.You will be introduced to Big Data and work with Big Data engines like Hadoop and Spark.  You will gain experience with creating Data Warehouses.You will work with AWS Cloud(Free email for all students)Solve more than 115 Problems Solving for Python and more than 60 problems for SQLYou will implement more than 5 projectsYou will work with Relational Databases (RDBMS) and query data using SQL statements. You will use NoSQL databases and unstructured data.Develop and execute SQL queries using SELECT, INSERT, UPDATE, DELETE statements, database functions, stored procedures, Nested Queries, and JOINs.Create, design, and manage relational databases and apply database administration (DBA) concepts to RDBMSes such as MySQL, PostgreSQL, and IBM Db2.Demonstrate NoSQL & Big Data knowledge using MongoDB, Cassandra, Cloudant, Hadoop, Apache Spark, SQL, Spark ML, and Spark Streaming.Implement ETL & Data Pipelines with Bash, Airflow & Kafka; architect, populate, and deploy Data Warehouses; create BI reports & interactive dashboards.​

Overview

Section 1: Introduction

Lecture 1 Data Engineering Program

Lecture 2 Contact me

Lecture 3 Introduction

Lecture 4 Colab Book

Lecture 5 How to submit your answer?

Lecture 6 Master Colab 1

Lecture 7 Master Colab 2

Lecture 8 Master Colab 3

Lecture 9 HackerRank

Lecture 10 Keywords and Identifiers

Lecture 11 Variables and Constants

Lecture 12 Type Conversion

Lecture 13 Statement & Comments

Lecture 14 I/O and Import

Lecture 15 Python Operators 1

Lecture 16 Python Operators 2

Section 2: Python Flow Control

Lecture 17 if…else Statement

Lecture 18 Nested if

Lecture 19 While Loop

Lecture 20 For loop

Lecture 21 Break and Continue

Section 3: Python Functions

Lecture 22 Functions

Lecture 23 Function Arguments

Lecture 24 Recursion

Lecture 25 Anonymous/Lambda Function

Anyone who wants to develop job-ready skills, tools, and a portfolio for an entry-level data engineer position.