Limited time · 90% off Premium Membership - claim $199 deal →
For Teams For Libraries Sign in
EN
Start unlimited
Catalog Courses Books Assets Newsletter Merch About Contact Blogs
Cart Sign in Start unlimited
Catalog / All levels / Associate Data Engineering – Database Design and Warehousing with PostgreSQL & Snowflake with 10 Exams
Mammoth Club All levels 9 sections 55 lectures

Associate Data Engineering – Database Design and Warehousing with PostgreSQL & Snowflake with 10 Exams

Created by humans, supported with AI features like chat and quizzes, and verified by human editors for trustworthiness. Data needs structure before it can drive decisions.

MC
Created by Team Mammoth
·
55 lectures
01
Skill level
All levels
02
Sections
9
03
Lectures
55
04
Instructor
Team Mammoth
What's inside

This course includes.

✓
9
Sections
✓
30
Quizzes
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content

Curriculum & lectures.

9 sections · 55 lectures
+ 01 Data Engineering for Everyone 5 lectures Preview
01 What is Data Engineering? Locked
02 Data Engineer vs Data Scientist Roles Locked
03 Data Collection, Cleaning, and Cataloging Locked
04 Introduction to Data Pipelines Locked
05 Parallel and Cloud Computing Concepts Locked
+ 02 SQL Fundamentals and Database Basics 6 lectures
01 Introduction to SQL Locked
02 Joining Multiple Tables - Connecting the Dots Locked
03 Calculating Aggregated Statistics Locked
04 Grouping and Filtering Grouped Data Locked
05 Writing Subqueries and CTEs Locked
06 Window Functions Locked
+ 03 Database Design and Modeling 6 lectures
01 Database Design Fundamentals Locked
02 Normalization (1NF, 2NF, 3NF) Locked
03 Star Schema Design for Data Warehouses Locked
04 Snowflake Schema Patterns Locked
05 Dimensional Modeling Techniques Locked
06 Fact Tables and Dimension Tables Locked
+ 04 PostgreSQL Deep Dive 8 lectures
01 Installing PostgreSQL on Different Operating Systems Locked
02 Database Server Configuration Locked
03 User Management and Role-Based Access Locked
04 Security Best Practices Locked
05 Creating, altering, and deleting tables Locked
06 Data Type Casting and Conversion Locked
07 Indexes and Query Optimization Locked
08 Stored Procedures and Functions Locked
+ 05 Data Warehousing Concepts 8 lectures
01 Understanding the Data Warehouse Revolution Locked
02 What is a Data Warehouse? Locked
03 Data Warehouse Architecture Components Locked
04 OLTP vs OLAP: Two Different Worlds Locked
05 Data Warehouse Design Patterns Locked
06 Data Storage Solutions: Warehouses vs Lakes Locked
07 Data Partitioning Strategies Locked
08 Data Archiving and Lifecycle Management Locked
+ 06 Introduction to Snowflake 5 lectures
01 The Cloud Data Revolution Locked
02 Cloud Data Warehouse Concepts Locked
03 Snowflake Architecture and Benefits Locked
04 Snowsight Interface Navigation Locked
05 Account Setup and Basic Configuration Locked
+ 07 Snowflake SQL and Data Operations 4 lectures
01 SnowSQL Syntax and Features Locked
02 Data Loading from Various Sources Locked
03 Data Integration Methods Locked
04 Query Optimization and Performance Monitoring Locked
+ 08 Advanced Snowflake Features 8 lectures
01 Role-Based Access Control (RBAC) Locked
02 User Management and Permissions Locked
03 Data Sharing and Governance Locked
04 Security Best Practices Locked
05 Advanced SnowSQL Techniques Locked
06 Advanced CASE Statements and Complex Logic Implementation Locked
07 Common Table Expressions (CTEs) and Advanced Window Functions Locked
08 Data Transformation and Modeling Locked
+ 09 Data Pipeline Development 5 lectures
01 ETL vs ELT Workflow Design Locked
02 Data Extraction from Multiple Sources Locked
03 Data Transformation Techniques Locked
04 Data Loading Strategies Locked
05 Automation and Monitoring Locked
Description

About this course.

This course introduces foundational skills in data engineering, focusing on database design and warehouse solutions with PostgreSQL and Snowflake as guiding platforms.


✅ Understand principles of relational database design

✅ Explore warehousing concepts for large-scale data storage

✅ Practice transformation and integration workflows

✅ Test your learning with 10 structured exams


By combining fundamentals with modern platforms, you’ll gain a versatile entry into data engineering practices that scale across industries.


🎁 Build the foundations of reliable and efficient data systems.

Ready to start building?

Created by humans, supported with AI features like chat and quizzes, and verified by human editors for trustworthiness. Data needs structure before it can drive decisions.

Buy lifetime access →