Database Management

This Database training course will allow the student to gain the skills necessary for day-to-day administration of databases in Oracle or SAP HANA or MS Sql Admin or Big Data Developer or Administration or ETL. The primary audiences for this course are Database administrators, web server administrators, implementation specialists, data center support engineers, senior application designers and developers. This course also provides the hands-on experience to install, configure and manage the Apache Hadoop platform and its associated ecosystem. Attendees learn to monitor Hadoop using built-in functionality and associated tools like Ganglia. Additionally, they learn to optimize resource allocation related to the file system and MapReduce. This course also covers techniques of ensuring robustness, efficiency and high availability using approaches such as redundancy and Name Node Federation. In addition to coverage of core Hadoop administration, attendees are exposed to the management of Pig, Hive, Zookeeper, Oozie and HBase as well as the challenges related to backup, recovery and security. Sqoop and Flume will be employed to demonstrate the migration of data into and out of Hadoop.

CIP: 11-0802 Data Modeling/Warehousing and Database Administration.

CIP: 11-0501 Computer Systems Analysis/Analyst.

CIP: 11-0802 Data Modeling/Warehousing and Database Administration.

Prerequisites

High School Diploma or GED, Associates degree, or Bachelor’s degree.

The primary audiences for this course are Database administrators, web server administrators, implementation specialists, data center support engineers, senior application designers and developers.

Certification: Oracle Database 11g Administrator Certified Associate, OPN Certified system administrators.

After completing classroom instruction an additional 120 hours of study may be required before taking certification exam.

CIP: 11-0802 Data Modeling/Warehousing and Database Administration.

MS SQL Server Admin:

In this course, you will develop an advanced understanding of complex Oracle database concepts, maintenance and recovery routines, and database management. You have an Oracle installation and need to broaden your knowledge of advanced Oracle administrative functionality so that you can maintain the healthiest possible database.

CIP: 11-0802 Data Modeling/Warehousing and Database Administration.

BIG DATA Development and Administration:

This course provides the hands-on experience to install, configure and manage the Apache Hadoop platform and its associated ecosystem. Attendees learn to monitor Hadoop using built-in functionality and associated tools like Ganglia. Additionally, they learn to optimize resource allocation related to the file system and MapReduce. This course also covers techniques of ensuring robustness, efficiency and high availability using approaches such as redundancy and Name Node Federation. In addition to coverage of core Hadoop administration, attendees are exposed to the management of Pig, Hive, ZooKeeper, Oozie and HBase as well as the challenges related to backup, recovery and security. Sqoop and Flume will be employed to demonstrate the migration of data into and out of Hadoop.

CIP: 11-0501 Computer Systems Analysis/Analyst.

ETL Ab Initio:

The Ab Initio software is a business intelligence platform containing six data processing products: Co>Operating System, The Component Library, Graphical Development Environment, and Enterprise Meta>Environment, Data Profiler and Conduct. It is a powerful graphical user interface-based parallel processing tool for ETL data management and analysis.

Certification: Certified Business Intelligence and Analytics.

After completing classroom instruction, an additional 120 hours of study may be required before taking certification exam.

CIP: 11-0202 Computer Programming, Specific Applications.

Length of the program:12 Weeks (480.00 Hours / 0.00 Credit Hours)

Course offering: Every Quarter

Course Number: CGIDBA003