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

 

Requirements

  • An understanding of  databases
  • Experience with SQL an asset.

Audience

  • Business analysts
  • Software developers
  • Database developers
 14 Hours

Testimonials (5)

Related Courses

ArcGIS for Spatial Analysis

14 Hours

ArcMap in ArcGIS

14 Hours

ArcGIS Pro for Spatial Analysis

14 Hours

ArcGIS with Python Scripting

14 Hours

QGIS for Geographic Information System

21 Hours

Advanced Data Analysis with TIBCO Spotfire

14 Hours

Introduction to Spotfire

14 Hours

AI-Driven Data Analysis with TIBCO Spotfire X

14 Hours

Data Analysis with SQL, Python and Spotfire

14 Hours

Sensu: Beginner to Advanced

14 Hours

Monitoring Your Resources with Munin

7 Hours

Automated Monitoring with Zabbix

14 Hours

Fluentd for Log Data Unification

14 Hours

Nagios Certified Administrator Preparation

21 Hours

Advanced Nagios

21 Hours

Related Categories

1