Empower Clients Through IT
IT EXPERT SYSTEM, INC
IT Training, Staffing and IT Services Provider
Schaumburg | Des Plaines | Naperville IL, USA
Big Data & Database Management Program
Program Description:
This program is designed to prepare students for Database Management/Big Data Development related positions, such as Information Systems Manager, Management Information Systems Director (MIS Director), Database Administrator (DBA), Database Analyst, and Database Programmer. This comprehensive program covers database modeling (ERD), creating and managing databases (Oracle, Microsoft SQL Server, My SQL, Apache Hadoop platform) to deploy the relational databases, and No SQL database like MongoDB, Cassandra, HBase Redis cache and ETL processing using: Big Data and Data Warehousing solutions. This program also provides hands-on experience on Apache Spark, Pig, Hive, Hue, Zookeeper, HBase, and Ganglia. This program has many other courses/ modules covering Business Analysis (BA), Service Oriented Architecture (SOA), Linux, AWS EMR, Data Analytics, Excel Solver, Linear programming, Model development, AWS cloud Web Services, Java and Python (Numpy, Pandas, Machine Learning Analytics Algorithm) programming concepts. The program includes ample labs, quizzes, group discussions/ exercises, project work, and internal/ external internship opportunities.
Course Content
1. BIG DATA Foundation
-
Database – overview, Oracle PL/SQL
-
Data warehouse, ETL [Extract Transform Load]
-
Data Warehouse vs BIG DATA
-
BIG DATA Tools / Technology
-
BIG DATA – Use case
-
LAB: Hadoop Installation
-
Homework
2. HDFS commands
-
Hadoop Architecture
-
Hadoop key components
-
Linux Overview
-
Linux vs HDFS Commands
-
Quiz one
-
LAB
-
Homework
-
3. PIG Programming
-
PIG Architecture Overview
-
PIG use cases
-
PIG Programming Syntax
-
LAB – Setup PIG Jobs
-
Homework
4. Hive Programming
-
HIVE Architecture Overview
-
HIVE use cases
-
HIVE Programming Syntax
-
LAB – Setup HIVE Jobs
-
Homework
-
5. Sqoop Programming
-
Sqoop Architecture Overview
-
Sqoop use cases.
-
Sqoop Programming Syntax
-
LAB – Setup Sqoop Jobs
-
Homework
6. NO SQL Overview
-
HBASE Overview
-
OLAP vs OLTP.
-
NO SQL vs SQL
-
Mongo DB vs HBASE vs HIVE
-
Zookeeper overview
-
LAB – HBASE commands
-
Homework
7. Spark Programming
-
Spark Architecture Overview
-
Spark Programming Syntax
-
Spark vs Hadoop use cases
-
Quiz two
-
LAB – HBASE commands
-
Homework
8. Capstone Project
Staffing Support
-
Resume Preparation
-
Mock Interview Preparation
-
Phone Interview Preparation
-
Face to Face Interview Preparation
-
Project/Technology Preparation
-
Internship with internal project work
-
Externship with client project work
Our Salient Features:
-
Hands-on Labs and Homework
-
Group discussion and Case Study
-
Course Project work
-
Regular Quiz / Exam
-
Regular support beyond the classroom
-
Students can re-take the class at no cost
-
Dedicated conf. rooms for group project work
-
Live streaming for the remote students
-
Video recording capability to catch up the missed class