3.1.0 Overview

Module 1 focuses on normalized data modeling, advanced query creation and query optimization techniques. 1:25 minute

• Module 1: Overview Video

Target Competencies

• Construct normalized data models
• Assemble advanced queries using SQL
• Evaluate optimization techniques for data models
• Construct data models for data analysis

Learning Objectives

• Specify data to be normalized
• Diagram a normalized data model
• Create data models
• Create logical joins to query data
• Develop queries to populate data models
• Explain queried data results
• Write queries for optimal performance
• Demonstrate best practices in query structure
• Identify errors and required components of a query
• Identify different kinds of data used for analysis
• Compare data models
• Contrast data models
• Interpret data model results