Duration
3 days
Module 1
- Introduction to SQL Language
- The Basics of SOL for analytics
- Relational Databases and SOL
- Basic Data Types of SQL
- Reading Tables
- Creating Tables
- Updating Tables
- Deleting Data and Tables
- SQL and Analytics
Module 2
- Assemble multiple tables and queries together into a dataset
- Transform and clean data using SQL functions
- Remove duplicate data using DISTINCT and DISTINCT ON
- Assembling Data
- Transforming Data
- Aggregate Functions
- Aggregate Functions with GROUP BY
- The HAVING Clause
- Using Aggregate to Clean Data and Examine Data Quality
Module 3
- What is HNe and Impala
- Similarities and differences between Hive and Impala
- Data Types
- Partitioning
- Built-in Operators
- Built-In Functions
- Views and Indexes
- HiveQL
- Hive Shell
- Impala Overview
- Impala Architecture
- Impala Shell
- Impala Query Language
- Exercises and Quizzes
Programme scope, delivery arrangements and suitability are confirmed during enquiry.