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

 IT Expert System, Inc. is approved to operate by the Private Business and Vocational Schools Division of the Illinois Board of Higher Education.

 IT Expert System, Inc. is not accredited by a US Department of Education recognized accrediting body. IBHE Mandatory Disclosure Reporting

 IT Expert System, Inc Training programs are approved by the Illinois State Approving Agency for the enrollment of qualified veterans and/or other eligible persons to receive Montgomery GI Bill® education benefits.

‘PMP’ and 'CAPM' are registered marks of the Project Management Institute, Inc.

‘GI Bill' is a registered trademark of the U.S. Department of Veterans Affairs (VA).

Office:

951 N. Plum Grove Rd.

Suite A, C
Schaumburg, IL, 60173

Ph: 847 350 9034

Email: info@itexps.com

Branch Office:

1560 Wall Street,

Suite #111,

Naperville, IL 60563 

Ph: 847 350 9034

Email: info@itexps.com

Disclaimer: At this time, we are not offering any training programs for Nebraska residents.