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
  • BIG DATA foundation

    • Database – overview , Oracle PL/SQL

    • Data warehouse, ETL [Extract Transform Load]

    • Data Warehouse vs BIG DATA

    • BIG DATA – Use cases, Hadoop 1.x vs 2.x overview

    • OLAP vs OLTP

  • Analytics - Managerial decisions based on data

    • Statistic Overview

    • Probably distribution – Monte Carlo (@Risk)

    • Empirical Model Preparation

    • Forecasting, and Projection Algorithm [R, Excel]

    • Classification, Clustering, Regression Algorithm

    • Descriptive and Visual Data Analysis [Neo4J]

    • Data Simulation

    • Data Reports for C-executives

    • Machine Learning [Mahout,R]

  • BIG DATA programming Project work with Hadoop Technology

    • Linux Shell Scripting

    • HDFS commands

    • PIG Programming

    • Hive Programming

    • Sqoop – data import and export

    • Zookeeper Architecture

    • R Programming

    • Python Programming

    • Java – Mapreduce

    • Hadoop Mapreduce

    • MySQL Database

    • NoSQL - MongoDB, Hive, HBASE, Neo4J(Graph Database), Cassandra

    • Storm/Spark – Real time Analytics