Data Engineering Essentials – SQL, Python and Spark

Data Engineering Essentials – SQL, Python and SparkNow, Course instructor offering 100%OFF on the original price of the course and its limited time offer. Enroll the course before the coupon expired Once you’re enrolled for the course, you can start it whenever and complete it at your own pace. it will never expire on your account.

What you’ll learn

  • Setup Development Environment on GCP
  • Database Essentials using Postgres
  • Programming Essentials using Python
  • Data Engineering using Spark Dataframe APIs
  • Data Engineering using Spark SQL

Detailed agenda for the course

  • Database Essentials – SQL using Postgres
    • Getting Started with Postgres
    • Basic Database Operations (CRUD or Insert, Update, Delete)
    • Writing Basic SQL Queries (Filtering, Joins and Aggregations)
    • Creating Tables and Indexes
    • Partitioning Tables and Indexes
    • Predefined Functions (String Manipulation, Date Manipulation and other functions)
    • Writing Advanced SQL Queries
  • Programming Essentials using Python
    • Perform Database Operations
    • Getting Started with Python
    • Basic Programming Constructs
    • Predefined Functions
    • Overview of Collections – list and set
    • Overview of Collections – dict and tuple
    • Manipulating Collections using loops
    • Understanding Map Reduce Libraries
    • Overview of Pandas Libraries
    • Database Programming – CRUD Operations
    • Database Programming – Batch Operations
  • Setting up Single Node Cluster for Practice
    • Setup Single Node Hadoop Cluster
    • Setup Hive and Spark on Single Node Cluster
  • Introduction to Hadoop eco system
    • Overview of HDFS Commands
  • Data Engineering using Spark SQL
    • Getting Started with Spark SQL
    • Basic Transformations
    • Managing Tables – Basic DDL and DML
    • Managing Tables – DML and Partitioning
    • Overview of Spark SQL Functions
    • Windowing Functions
  • Data Engineering using Spark Data Frame APIs
    • Data Processing Overview
    • Processing Column Data
    • Basic Transformations – Filtering, Aggregations and Sorting
    • Joining Data Sets
    • Windowing Functions – Aggregations, Ranking and Analytic Functions
    • Spark Metastore Databases and Tables

Who this course is for:

  • Computer Science or IT Students or other graduates with passion to get into IT
  • Data Warehouse Developers who want to transition to Data Engineering roles
  • ETL Developers who want to transition to Data Engineering roles
  • Database or PL/SQL Developers who want to transition to Data Engineering roles
  • BI Developers who want to transition to Data Engineering roles
  • QA Engineers to learn about Data Engineering
  • Application Developers to gain Data Engineering Skills

Can I download Data Engineering Essentials – SQL, Python and Spark course?

You can download videos for offline viewing in the Android/iOS app. When course instructors enable the downloading feature for lectures of the course, then it can be downloaded for offline viewing on a desktop.
Can I get a certificate after completing the course?
Yes, upon successful completion of the course, learners will get the course e-Certification from the course provider. The Data Engineering Essentials – SQL, Python and Spark course certification is a proof that you completed and passed the course. You can download it, attach it to your resume, share it through social media.
Are there any other coupons available for this course?
You can check out for more Udemy coupons @ www.coursecouponclub.com
Note: 100% OFF Udemy coupon codes are valid for maximum 3 days only. Look for "ENROLL NOW" button at the end of the post.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.
Deal Score0

Course Coupon Club
Logo