Certificate Authentication

SQL For Data Science and Data Analysis Certificate for Ffion Edwards

Add to LinkedIn

Certificate ID: 
795811
Authentication Code: 
a2e60
Certified Person Name: 
Ffion Edwards
Trainer Name: 
Gunnar Bless
Duration Days: 
2
Duration Hours: 
14
Course Name: 
SQL For Data Science and Data Analysis
Course Date: 
20 January 2025 09:30 to 21 January 2025 16:30
Course Outline: 

Lesson 1 - SQL basics: 

  • Select statements
  • Join types
  • Indexes
  • Views
  • Subqueries
  • Union
  • Creating tables
  • Loading data
  • Dumping data
  • NoSQL

Lesson 2 - Data Modeling:

  • Transaction based ER systems
  • Data warehousing 
  • Data warehouse models
    • Star schema
    • Snowflake schemas
  • Slowly changing dimensions (SCD)
  • Structured and non-structured data
  • Different table type storage engines:
    • Column based
    • Document-based
    • In Memory

Lesson 3 - Index in the NoSQL/Data science world

  • Constraints (Primary)
  • Index-based scanning
  • performance tuning

Lesson 4 - NoSQL and non-structured data

  • When to use NoSQL
  • Eventually consistent data
  • Schema on read vs. Schema on write

Lesson 5 - SQL for data analytics

  • Windowing function
  • Lateral Joins
  • Lead & Lag

Lesson 6 - HiveQL

  • SQL Support
  • External and Internal Tables
  • Joins
  • Partitions
  • Correlated subqueries
  • Nested queries
  • When to use Hive

Lesson 7 - Redshift

  • Design and structured
  • Locks and shared resources
  • Postgres differences
  • When to use redshift