EncartaLabs

MicroStrategy Database Architect

( Duration: 2 Days )

In MicroStrategy Database Architect training course, you will learn about the foundation of database management systems, including big data architecture and technologies to design and maintain database enterprise assets. You will learn about relational, and distributed data warehouse topics from a holistic approach of the Database Architect in an Intelligent Enterprise. The course focuses on the key competencies to help you succeed as a Database Architect, by supporting your Intelligent Enterprise in providing well-tuned data pipelines, and a stable data warehouse platform environment.

By attending MicroStrategy Database Architect workshop, attendees will learn to:

  • Implement big data analytics using Hadoop and Hive
  • Data Warehouse performance tuning techniques such as partitioning, indexing, and query optimization
  • Data integration and migration using Talend Open Studio

  • Knowledge of MicroStrategy Foundations

  • Anyone who wants to become the MicroStrategy Database Architect

COURSE AGENDA

1

Shaping the Intelligent Enterprise

  • The Intelligence Center and the Database Architect role
2

Knowledge Discussions with Enterprise Team

  • Intelligent Enterprise standards
  • Standardizing documentation and data model repositories
3

Big Data Analytics

  • Implementing big data analytics using Hadoop and Hive
  • Apache Hadoop core component installation and configuration, including HDFS, MapReduce, and YARN
  • Performance tuning Hive
4

Data Warehouse Performance Tuning

  • Improve query performance using various data processing and storage techniques related to distributed datasets
5

Database Optimization

  • Database optimization strategies employing aggregation, partitioning, and indexing
6

Data Integration and Migration

  • Migrating data form PostgreSQL to SQL Server database using Talend Open Studio
  • Live data ingestion with Python
7

Enterprise Data Lakes

  • Leverage data lakes

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top