Duration
5 day
What you will learn
This course aims to cover the various big data database warehouse and business intelligence methods currently available for dealing with big data. From distributed clustered databases like GreenPlum to real time in-memory log based databases like GemFire and HANA. This course will give hands on experience of the differences in various methods, and how each solves business problems.
Objectives
Upon successful completion of this course, participants should be able to:
- Manage database objects and workload management processes based on different underlying infrastructure
- Implement system-level and database-level security
- Use data manipulation language and data query language tools to access, manage and query data
- Determine when it is best to use an index and what type of index to use
- Improve query performance by following a number of performance enhancement tips
- Know which tool to use for different aspects of the analytics life cycle
Prerequisite Knowledge/Skills
To be eligible for this course, a student must have:
- Basic knowledge of Unix or Linux commands
- Experience with SQL syntax
- Basic understanding of fundamental relational database concepts
Course Outline
- Big Data Database Fundamental Concepts
- The Basics of Data Warehousing
- ACID vs. Base
- Concepts, Features and Benefits
- Comparison of In-Memory databases vs. Distributed databases
- Introduction To Tools, Utilities And Internals
- Data Definition Language
- How To Structure The Database
- Loading the Data
- Table partitioning
- External Tables
- Unloading the Data
- Using tools
- Big Data Management And Archiving
- Backup and Recovery
- Big Data Modelling
- Data Modeling, Databases and Schemas
- Physical Design Decisions
- Visualization
- Aggregates And Extensions
- Arrays and Array Aggregates
- Window Functions
- User Defined Functions and Aggregates
- Using Extensions
- MADlib, Spring
- Big Data Database Performance Analysis And Tuning
- Data Manipulation Language and Data Query Language
- Database Tuning
- Analysing Queries
- Performance Statistics and Reporting
- Improving Performance
- Indexing Strategies
Programme scope, delivery arrangements and suitability are confirmed during enquiry.