Database Management
Course number: CGIDM280
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.
Target Audience
The primary audiences for this course are database administrators, web server administrators, implementation specialists, data center support engineers, senior application designers and developers.
Certification
MS SQL Server Admin from Microsoft, ETL Ab Initio from Ab Initio, BIG DATA Development and Administration from Cloudera.com
Exam
MS SQL Server Admin exam or ETL Ab Initio exam or BIG DATA Development and Administration exam
Accreditation
Post class completion, students can appear for the MS SQL Server Admin exam or ETL Ab Initio exam or BIG DATA Development and Administration exam
Course Content
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.
Certification: MS SQL Server Admin from Microsoft
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.
Certification: BIG DATA Development and Administration from Cloudera.com
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: ETL Ab Initio from Ab Initio
After completing classroom instruction, an additional 120 hours of study may be required before taking the certification exam.
Classroom
Live Online