1 Course Overview (4.65 MB)
1 Introduction (20.39 MB)
2 The Data Ecosystem (15.44 MB)
3 Role and Responsibilities of Data Engineers (17.44 MB)
4 Essential Skills and Tools for Data Engineers (22.35 MB)
1 Career Paths in Data Engineering (18.28 MB)
2 Building a Data Engineering Portfolio (33.43 MB)
3 Core Concepts and Real-world Tasks (30.93 MB)
4 Next steps (13.13 MB)
1 Course Overview (3 MB)
1 Introduction (943.08 KB)
2 What Is Big Data (4.76 MB)
3 The Vs of Big Data (3.44 MB)
4 History of Big Data (9.11 MB)
5 Opportunities in Big Data (6.19 MB)
6 Challenges in Big Data (5.1 MB)
7 Conclusion (2.59 MB)
1 Introduction (928.84 KB)
2 Principles in Designing a Scalable Big Data Architecture (7.9 MB)
3 Key Technologies in Big Data (7.53 MB)
4 Enterprise Technologies in Big Data (6.36 MB)
5 Demo - Using Data Lake (17.96 MB)
6 Demo - Using Databricks (16.1 MB)
7 Conclusion (1.75 MB)
1 Introduction (1.03 MB)
2 Techniques in Big Data (8.92 MB)
3 Ethical Considerations in Big Data (10.77 MB)
4 Conclusion (2.26 MB)
1 Course Overview (3.14 MB)
1 Cloud Computing (5.71 MB)
2 Advantages and Challenges (5.67 MB)
3 Cloud Providers (4.34 MB)
4 Data Engineering on AWS (9.69 MB)
5 Data Engineering on Microsoft Azure (8.82 MB)
6 Data Engineering on Google Cloud (7.37 MB)
7 Managed Services (6.45 MB)
1 Designing Data Pipelines (4.81 MB)
2 Deploying Data Pipelines (17.82 MB)
1 Security (8.4 MB)
2 Monitoring (4.23 MB)
3 Cost Optimization (3.14 MB)
1 Course Overview (3.66 MB)
1 Understanding Non-structured, Semi-structured, and Structured Data (5.41 MB)
2 Introduction to Data Modeling (8.81 MB)
3 Creating a Conceptual Data Model (6.91 MB)
4 Implementing Logical Data Models (7.05 MB)
5 Understanding Normalization and Entity Relationship Diagrams (8.06 MB)
1 Implementing a Physical Data Model (14.8 MB)
2 Understanding Optimization Techniques in Physical Database Design (11.42 MB)
3 Demo - Performance Tuning with Indexing (13.03 MB)
1 Understanding Key Characteristics of OLTP and OLAP Systems (14.66 MB)
2 Data Modeling for Big Data (6.28 MB)
1 Course Overview (4.35 MB)
1 So Many Designs (4.15 MB)
2 OLTP and OLAP (2.84 MB)
3 Relational Design (5.33 MB)
4 Atomic, Consistent, Isolated, and Durable (7.19 MB)
5 Page Contention (4.55 MB)
6 ODS, Star, and Snowflake Designs (3.75 MB)
1 The Vs of Big Data (5.54 MB)
2 Key Value and Memory Caches (3.69 MB)
3 PubSub, Stream, and Document Databases (4.08 MB)
4 File-based and Columnar Oriented Systems (5.47 MB)
5 The CAP Theorem (4.51 MB)
1 A Word on Graph (7.93 MB)
2 Security for Data at Rest (4.44 MB)
3 Identity and Access Management (3.85 MB)
4 Protecting Data in Transit (2.2 MB)
5 High Availability and Disaster Recovery (3.8 MB)
1 Course Overview (3.62 MB)
1 ETL Concepts and Importance (4.64 MB)
2 Overview of ETL Tools (9.42 MB)
3 Challenges in ETL Processes (6.7 MB)
4 Recap (1.31 MB)
1 Pipeline Design Fundamentals (10.32 MB)
2 Building an ETL Workflow (25.26 MB)
3 Introduction to Advanced Techniques (8.49 MB)
4 Recap (942.45 KB)
1 Monitoring and Error Management (8.8 MB)
2 Optimization Strategies (3.38 MB)
3 Future Trends and Innovations (8.65 MB)
4 Next Steps (846.23 KB)
1 Course Overview (3.61 MB)
1 Understanding Data Pipelines (12.77 MB)
2 Overcoming Challenges in Data Pipeline Engineering (9.54 MB)
3 Understanding and Applying Data Pipeline Tooling (13.23 MB)
1 Implementing Data Pipelines (13.35 MB)
2 Demo - Implementing Data Pipelines (21.29 MB)
1 Course Overview (2.98 MB)
1 Leveraging Subqueries to Simplify Complex Queries (4 MB)
2 Incorporating Data Aggregation for Analysis and Insight (3.22 MB)
3 Enhancing Aggregation with Window Functions (2.31 MB)
4 Structuring Subqueries Using Common Table Expressions (3.11 MB)
5 Navigating Hierarchical Data Using Recursive CTEs (3.16 MB)
6 Selecting the Best Join Operation (3 MB)
7 Overcoming SQL Limitations Using Dynamic SQL (3.48 MB)
1 System Factors that Influence SQL Query Performance (3.38 MB)
2 Reducing Query Time Using Indexing (3.45 MB)
3 Understanding Database Query Execution Plans (4.89 MB)
4 Reusing Execution Plans with the Query Cache (2.77 MB)
5 Designing a Database for Optimal Querying (5.99 MB)
6 Query Writing Habits to Adopt and Avoid (6.08 MB)
1 Understanding Data Ingestion (2.97 MB)
2 Comparing ETL and ELT (2.2 MB)
3 Validating, Transforming, Aggregating, and Enriching Data (3.96 MB)
4 Automating Data Pipelines (1.63 MB)
5 Breaking Down Data Ingestion Solutions (2.4 MB)
6 Surveying Data Ingestion Vendors (3.07 MB)
1 Introducing Big Data (3.29 MB)
2 Understanding Apache Hadoop (1.69 MB)
3 Querying Hadoop Using Hive (3.43 MB)
4 Utilizing Apache Spark for High Performance Analytics (4.31 MB)
5 Swimming in a Data Lake (2.8 MB)
6 Decentralizing Data in a Mesh (3.38 MB)
7 Course Summary (1.01 MB)
1 Course Overview (4.16 MB)
1 Introduction to Trend Analysis (7.58 MB)
2 Identifying Trends in Time-series Data (7.43 MB)
4 Data Smoothing (5.95 MB)
5 Demo - Data Smoothing (4.07 MB)
1 Analyzing Seasonal Variations (4.41 MB)
2 Demo - Analyzing Seasonal Variations (6.27 MB)
3 Recognizing Cyclic Patterns (2.19 MB)
4 Demo - Recognizing Cyclic Patterns (6.86 MB)
5 Forecasting Models (6.73 MB)
6 Demo - Forecasting Models (6.84 MB)
1 Course Overview (4.17 MB)
2 Demo - Data Preparation Techniques (24.64 MB)
1 Integration with External Tools (3.49 MB)
3 SQL Query Optimization (4.57 MB)
7 Summary (1.4 MB)