This unit introduces the fundamentals of data, the role and lifecycle of data engineering, and core database concepts including relational and NoSQL approaches. Students will also set up a SQL Server environment and practice composing efficient queries, preparing them for downstream units on pipelines, storage, and data transformation.
Learning Objectives
- Analyze the historical evolution of data and categorize common data types, explaining how each type supports different analytical and operational uses
- Apply the data engineering life cycle and the oil refinery analogy to translate stakeholder requirements into data engineering tasks and deliverables
- Demonstrate knowledge of key database concepts by comparing relational and NoSQL databases and selecting the appropriate database model for given scenarios
- Evaluate and construct efficient basic SQL queries using comparison operators and joins in a SQL Server environment while following query best practices
Curriculum
- 1 Section
- 21 Lessons
- 30 hours
Expand all sectionsCollapse all sections
- Unit 1 — Foundations of Data Engineering and SQL21
- 1.1A Brief History of Data20 mins
- 1.2Types of Data20 mins
- 1.3Why Is Data Important?20 mins
- 1.4Data and Information20 mins
- 1.5Summary20 mins
- 1.6Notes20 mins
- 1.7Data Engineering Explained Using an Oil Refinery Analogy20 mins
- 1.8An Overview of the Data Engineering Life Cycle20 mins
- 1.9Navigating Project Requirements, Engaging Stakeholders, and Delivering Business Value20 mins
- 1.10The Current State of Data Engineering20 mins
- 1.11The Importance of Data Engineering20 mins
- 1.12Summary20 mins
- 1.13Key Concepts of Databases20 mins
- 1.14Types of Databases20 mins
- 1.15Choosing Between Relational and NoSQL Databases20 mins
- 1.16Summary20 mins
- 1.17Introduction to SQL20 mins
- 1.18Comparison Operators20 mins
- 1.19Understanding Joins20 mins
- 1.20Lab: Setting Up SQL Server and Running SQL Queries20 mins
- 1.21Best Practices for Writing Efficient SQL Queries20 mins
Instructor
Free
Leave a Reply