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
Testimonials (6)
Dużo cierpliwości
Mateusz - WestWind Energy Polska Sp. z o.o.
Course - ArcGIS for Spatial Analysis
The trainer adapted the materials and contents to what he thought would be best for us and he succeeded. The quality of the training was excellent.
Jorge Sanchez Hernandez - CSMART - Carnival
Course - QGIS for Geographic Information System
I genuinely enjoyed the lots of labs and practices.
Vivian Feng - Destination Canada
Course - Data Analysis with SQL, Python and Spotfire
Professional and very practical, usuefull in a daily work
Jozefin Rékasi - SC Automobile Dacia SA
Course - Advanced Data Analysis with TIBCO Spotfire
It covered the areas i said i was interested in before the course: data relationships, using python script. Connecting to databases will be covered in the advanced module.
Cristian Tudose - SC Automobile Dacia SA
Course - Introduction to Spotfire
Rapide et efficace VM Azure et support au top