Data Engineer Course with Career Transition
The Data Warehouse Toolkit Textbook
Data Engineer Course with Career Transition
0%
Completed
Free Textbook Download
Data Intensive Applications TextBook
Reading
The Data Warehouse Toolkit Textbook
Reading
End-to-End Real-Time Projects & Internship Projects
Data Engineering Project Pipeline using AWS, S3, PySpark & SnowFlake
Reading
AirFlow, AWS S3, Glue, PySpark & Amazon RedShift Data Engineering Project Pipeline
Reading
AWS S3, Glue, PySpark, Athena & Quick Sight Project Pipeline
Reading
Kafka, EMR, PySpark & Amazon RedShift End-to-End Project
Reading
HDFS Data Lake, PySpark & MongoDB Project Pipeline
Reading
Star Schema & SnowFlake Schema Design using SnowFlake Data Warehouse Pipeline
Reading
Kafka, Azure Data Factory, Azure Databricks & Synapse Analytics Project Pipeline
Reading
Automatic Ingestion using SnowPipe, S3 & SnowFlake
Reading
SnowPark, SnowFlake, Stored Procedures Data Science Project Pipeline Design
Reading
SnowFlake Cron Jobs, Aggregations using SQL & Reporting using Power BI Pipeline
Reading
Introduction to Data Warehouse
What Is Data Warehouse?
Reading
Important Data Warehouse Concepts
Reading
Difference between OLAP vs OLTP
Reading
Data Ecosystem Mindmap
Reading
Overview of Data Warehouse
Reading
Data Warehouse Architecture
Reading
Mastering Python
Introduction to Python
Reading
Structure of Any Programming Language like Value, Variables, Functions & Libraries
Reading
Different In-Built Data Structures like List, Tuple, Set & Dict
Reading
Mastering Conditional Flow
Reading
Loops like While & For
Reading
List Comprehension
Reading
Mastering User-Defined Functions
Reading
Regular Expressions and Lambda
Reading
Strings and Arrays
Reading
Procedural Programming vs OOPS
Reading
Mastering OOPs
Reading
Different Libraries like Pandas & Numpy
Reading
Instance Variable, Class Variable, Class Method
Reading
Association vs Composition & Aggregation
Reading
Oops Concept
Reading
Encapsulation, Inheritance
Reading
Polymorphism, Method OverLoading, Method Overriding
Reading
Introduction to SnowFlake
What is Snowflake?
Reading
SnowFlake Architecture
Reading
Snowflake Virtual Warehouse
Reading
SnowFlake Object Hierarchy
Reading
Mastering MySQL
Introduction to MySQL
Reading
Creating Database in MySql
Reading
Star Schema and SnowFlake Schema Design
Reading
Forward and Reverse Engineering
Reading
Creating ER diagrams
Reading
Deep Dive into MySQL
Reading
SELECT, UPDATE, DELETE Operations
Reading
Clauses in MySql Part-1
Reading
Clauses in MySql Part-2
Reading
Clauses in MySQL Part-3
Reading
MySQL Data Handling Part-1
Reading
MySQL Data Handling Part-2
Reading
Data Integrity & Referential Integrity
Reading
Data Normalisation
Reading
First & Second Normal Form
Reading
Functional Dependency, Transitive Dependency & 3rd Normal Form
Reading
Boyce-Codd Normal Form
Reading
Denormalization
Reading
Temporary Table, Common Table Expression, Recursive CTE
Reading
When to use Temporary Table, CTE & Recursive CTE
Reading
Subquery in MySQL
Reading
Views in MySQL
Reading
Stored Functions
Reading
Stored Procedures
Reading
Triggers in MySQL
Reading
Create Events in MySQL
Reading
Different Functions in MySQL
Reading
Big Data & Streaming Tools
Introduction to Big Data
Reading
Distributed Computing & Hadoop Architecture
Reading
Storing Data on Hadoop -HDFS
Reading
Processing - MapReduce
Reading
Working on YARN
Reading
HBase
Reading
Working on Sqoop
Reading
Working on Impala
Reading
Working with Flume
Reading
Working with Zookeeper
Reading
Big Data Scheduling
Big Data Scheduling with Airflow
Reading
Oozie
Reading
Mastering HIVE
Introduction to HIVE
Reading
HIVE Architecture
Reading
Data Storage in HIVE
Reading
Tables in HIVE
Reading
Loading Data into Partitions
Reading
Big Data on Cloud
Introduction to Cloud - Models, Service Categories, AWS security, IAM
Reading
AWS platform
Reading
EC2 and S3
Reading
Databases on AWS
Reading
AWS EMR
Reading
AWS Data Collection & DataLake
Data Warehousing on AWS
Reading
DynamoDB, Lambda
Reading
Redshift
Reading
AWS Glue
Reading
AWS Data pipelines and data nodes
Reading
Activity, Pre-condition and Schedule
Reading
Introduction to DataLake
Reading
Learn about Data Lake vs. Data Warehouse
Reading
Key components of a Data Lake Architecture
Reading
Query files directly using SQL
Reading
Amazon Kinesis
Amazon Kinesis and Kinesis Stream
Reading
Kinesis data stream architecture and components
Reading
Data producer and Consumer
Reading
Kinesis stream emitting data to AWS services and Kinesis connector library
Reading
Kinesis firehose
Reading
Data Loading/Ingestion and Extraction
What is Data Ingestion?
Reading
Data Ingestion in Real-World
Reading
Create an Integration Object to Connect Snowflake with AWS S3
Reading
Ingesting CSV from S3 to Snowflake
Reading
Ingest JSON from S3 to Snowflake
Reading
How to do Continuous Data Ingestion in Snowflake
Reading
SnowPipe: Implementation of Snow Pipe
Reading
SnowPipe: Billing Estimation and Key Considerations for Data Ingestion
Reading
Unloading of Data from Snowflake to S3
Reading
Big Data on Azure
Introduction to Cloud - Models, Service Categories
Reading
Overview of Azure Synapse and Architecture
Reading
Azure SQL, Creating SQL Pool
Reading
Data Warehousing on Azure
Reading
Azure SQL Data Warehouse, HDInsight
Reading
Cosmos, Azure Functions
Reading
Azure VM, Blob Storage
Reading
DataBricks and Data Factory
Azure Stream Analytics
Reading
Learn how to input data into Azure ASA
Reading
Learn how to create queries and data analysis pipelines with Azure ASA
Reading
Learn how to output the results of the data analysis pipeline to various output formats
Reading
Learn how to work with Azure ASA and Microsoft PowerBI
Reading
Azure Data Factory
Reading
Microsoft Azure Data Lake
Reading
Different tools and scenarios to ingest data in to Data Lake
Reading
Data Lifecycle and Architecture around Data Lake
Reading
Use Azure Databricks and HDInsight to process data in ADLS
Reading
Monitor the performance of your Data lake
Reading
Azure Data Factory
Reading
Azure Functions
Reading
PySpark Mastering
Core PySpark architecture
Reading
Deployment modes
Reading
RDD and RDD Operations, DAG
Reading
PySpark SQL
Reading
Dataframes, Hive Integration, data manipulation with PySpark SQL
Reading
PySpark Streaming
Reading
Structured Streaming
Reading
Amazon EMR and Running all Hadoop jobs on AWS EMR
Reading
Kafka
What is Kafka?
Reading
Kafka Features
Reading
Kafka Concepts
Reading
Kafka Architecture
Reading
Kafka Components
Reading
ZooKeeper
Reading
Where is Kafka Used?
Reading
Kafka Installation
Reading
Kafka Cluster
Reading
Types of Kafka Clusters
Reading
Configuring Single Node Single Broker Cluster
Reading
Kafka Producer
Reading
Kafka Consumer
Reading
Kafka Internals & Load Balancing
Reading
Mastering MongoDB
Introduction to Mongo DB
Reading
Installation of MongoDB
Reading
Basics Operations of MongoDB
Reading
Create Operations in MongoDB
Reading
Update Operations in MongoDB
Reading
Read Operations in MongoDB
Reading
Delete Operations in MongoDB
Reading
Query & Projection Operations
Reading
Python with MongoDB
Reading
Spark with MongoDB
Reading
Tables in Snowflake
Different Types of Tables in Snowflake
Reading
Creating Tables in Snowflake
Reading
Materialised Views, Views & Secure Views in Snowflake
Reading
Creating Views in Snowflake
Reading
Creating Secure Views in Snowflake
Reading
In-depth about Views in Snowflake
Reading
Tasks and Query Scheduling
Introduction to Tasks
Reading
Creating Standalone and Dependent Tree of Tasks
Reading
Billing and Query History for Tasks
Reading
Streams and Change Data Capture
Introduction to Streams
Reading
Implementation of Standard Streams
Reading
Implementation of Append-Only Streams
Reading
Streams in a Transaction
Reading
Data Retention and Staleness
Reading
Change Tracking Using " Changes "
Reading
End-to-End Stream Creation
Reading
End-to-End Pipeline Demonstration
Reading
Snowflake – External Functions
Introduction to External Functions
Reading
What is AWS Lambda Functions?
Reading
Write & Deploy AWS Lambda Function
Reading
What is IAM Role in AWS?
Reading
Creating IAM Role in AWS
Reading
Create API Gateway
Reading
Secure and Deploy API Gateway
Reading
Create External Function in Snowflake
Reading
Snowflake with Python, Spark, and Airflow on AWS
Connect Python with Snowflake in Your Local Machine
Reading
Introduction to AWS Glue
Reading
Deploy and Execute Python Script to AWS Glue
Reading
Parameterize Your Python Script on AWS Glue
Reading
Python Pandas with Snowflake on AWS Glue
Reading
What Is Pushdown in Spark 3.1?
Reading
What is Spark? Introduction to PySpark
Reading
Deploy a PySpark Script Using AWS Glue
Reading
What is Airflow?
Reading
Set Up Managed Airflow Cluster on AWS
Reading
Configure Snowflake Connectivity in Airflow
Reading
Deploy a PySpark Transformation job in AWS Glue
Reading
Set Up Airflow DAG
Reading
Real-Time Streaming with Kafka and Snowflake
What is Kafka?
Reading
Why to go with Real-Time Streaming
Reading
Introduction to Kafka
Reading
Download the Necessary JAR Files
Reading
Set Up Kafka in your local system
Reading
Set Up Kafka Snowflake Connector
Reading
Set Up Encryption Keys for Kafka-Snowflake Connectivity
Reading
Streaming Data in Action
Reading
Snowflake – Data Protection and Governance
What Is Time Travel and Failsafe in Snowflake?
Reading
Time Travel and Data Recovery
Reading
Column Level Dynamic Data Masking
Reading
What Is Row Level Security?
Reading
Create and Implement Row Level Access Policy
Reading
More
Announcements
Course Info
Exercise Files
eBook+Ralph+Kimball+3rd+Edition+-+The+Data+Warehouse+Toolkit (pdf)
5.48 MB
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
Go Back to Course
Complete Anyway