Big data and database programBig Data and Database Management

Prepare for Database Management and Big Data development roles: database modeling, Oracle, SQL Server, MySQL, Hadoop, NoSQL and ETL, with ample labs, quizzes and project work.

Book an appointment Call 847-350-9034

Hands-on labsQuizzesCapstone projectInternships

Program description

Designed to prepare students for positions such as Information Systems Manager, MIS Director, Database Administrator, Database Analyst and Database Programmer.The program covers database modeling (ERD), creating and managing databases (Oracle, Microsoft SQL Server, MySQL, Apache Hadoop platform), NoSQL databases like MongoDB, Cassandra, HBase and Redis cache, and ETL processing using Big Data and Data Warehousing solutions. It also provides hands-on experience with Apache Spark, Pig, Hive, Hue, Zookeeper, HBase and Ganglia.Other modules cover Business Analysis, Service Oriented Architecture, Linux, AWS EMR, Data Analytics, Excel Solver, linear programming, model development, AWS cloud web services, and Java and Python (NumPy, Pandas, machine learning analytics algorithms). The program includes labs, quizzes, group discussions, project work, and internal and external internship opportunities.

Eight parts of the course

Most parts include a lab and homework. 1

Big Data foundation

Databases, Oracle PL/SQL, data warehouse, ETL and Hadoop install lab.2

HDFS commands

Hadoop architecture, key components, Linux vs HDFS commands.3

Pig programming

Architecture, use cases, syntax and Pig job lab.4

Hive programming

Architecture, use cases, syntax and Hive job lab.5

Sqoop programming

Architecture, use cases, syntax and Sqoop job lab.6

NoSQL overview

HBase, OLAP vs OLTP, NoSQL vs SQL, Zookeeper.7

Spark programming

Spark architecture, syntax and Spark vs Hadoop use cases.8

Capstone project

Apply the whole course in a final project.

Detailed course content

Topics covered in each part.

1. Big Data foundation

✓Database overview, Oracle PL/SQL✓Data warehouse, ETL [Extract Transform Load]✓Data warehouse vs Big Data; Big Data tools and use case✓Lab: Hadoop installation

2. HDFS commands

✓Hadoop architecture and key components✓Linux overview; Linux vs HDFS commands✓Quiz one and lab

3 to 5. Pig, Hive and Sqoop

✓Architecture overview and use cases for each✓Programming syntax for each✓Labs: set up Pig, Hive and Sqoop jobs

6. NoSQL overview

✓HBase overview, OLAP vs OLTP, NoSQL vs SQL✓MongoDB vs HBase vs Hive✓Zookeeper overview and HBase commands lab

7. Spark programming

✓Spark architecture overview and syntax✓Spark vs Hadoop use cases✓Quiz two and lab

Support and salient features

Career support and classroom features that come with the course.

Staffing support

✓Resume preparation✓Mock interview preparation✓Phone interview preparation✓Face to face interview preparation✓Project and 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 and exam✓Regular support beyond the classroom✓Students can re-take the class at no cost✓Dedicated conference rooms for group project work✓Live streaming for remote students✓Video recording to catch up on a missed class

Ready to start work with big data?

Call 847-350-9034 or book an appointment to talk about this course and funding options.Book an appointment Call 847-350-9034 Education grant program

Program description

Designed to prepare students for positions such as Information Systems Manager, MIS Director, Database Administrator, Database Analyst and Database Programmer.The program covers database modeling (ERD), creating and managing databases (Oracle, Microsoft SQL Server, MySQL, Apache Hadoop platform), NoSQL databases like MongoDB, Cassandra, HBase and Redis cache, and ETL processing using Big Data and Data Warehousing solutions. It also provides hands-on experience with Apache Spark, Pig, Hive, Hue, Zookeeper, HBase and Ganglia.Other modules cover Business Analysis, Service Oriented Architecture, Linux, AWS EMR, Data Analytics, Excel Solver, linear programming, model development, AWS cloud web services, and Java and Python (NumPy, Pandas, machine learning analytics algorithms). The program includes labs, quizzes, group discussions, project work, and internal and external internship opportunities.

Eight parts of the course

Most parts include a lab and homework.1

Big Data foundation

Databases, Oracle PL/SQL, data warehouse, ETL and Hadoop install lab.2

HDFS commands

Hadoop architecture, key components, Linux vs HDFS commands.3

Pig programming

Architecture, use cases, syntax and Pig job lab.4

Hive programming

Architecture, use cases, syntax and Hive job lab.5

Sqoop programming

Architecture, use cases, syntax and Sqoop job lab.6

NoSQL overview

HBase, OLAP vs OLTP, NoSQL vs SQL, Zookeeper.7

Spark programming

Spark architecture, syntax and Spark vs Hadoop use cases.8

Capstone project

Apply the whole course in a final project.

Detailed course content

Topics covered in each part.1

Big Data foundation

✓Database overview, Oracle PL/SQL✓Data warehouse, ETL [Extract Transform Load]✓Data warehouse vs Big Data; Big Data tools and use case✓Lab: Hadoop installation2

HDFS commands

✓Hadoop architecture and key components✓Linux overview; Linux vs HDFS commands✓Quiz one and lab3

3 to 5. Pig, Hive and Sqoop

✓Architecture overview and use cases for each✓Programming syntax for each✓Labs: set up Pig, Hive and Sqoop jobs6

NoSQL overview

✓HBase overview, OLAP vs OLTP, NoSQL vs SQL✓MongoDB vs HBase vs Hive✓Zookeeper overview and HBase commands lab7

Spark programming

✓Spark architecture overview and syntax✓Spark vs Hadoop use cases✓Quiz two and lab

Support and salient features

Career support and classroom features that come with the course.1

Staffing support

✓Resume preparation✓Mock interview preparation✓Phone interview preparation✓Face to face interview preparation✓Project and technology preparation✓Internship with internal project work✓Externship with client project work2

Our salient features

✓Hands-on labs and homework✓Group discussion and case study✓Course project work✓Regular quiz and exam✓Regular support beyond the classroom✓Students can re-take the class at no cost✓Dedicated conference rooms for group project work✓Live streaming for remote students✓Video recording to catch up on a missed class

Ready to start work with big data?

Call 847-350-9034 or book an appointment to talk about this course and funding options.Book an appointment Call 847-350-9034 Education grant program