ATC-BASIC-SAP-HANA - Basic SAP HANA

Overview

Duration: 4.0 days

Our Sap Hana Training course will help you understand and learn the fundamentals and will also felicitate on training hands-on for the better grasp on the course. Further, we have the highly qualified professionals who will train you about Sap Hana Studio, Modeling, Security features and its various other aspects. This course is designed in such a way that it will make you understand 'why sap Hana is a fundamentally different database engine.

Objectives

To help you learn about SAP HANA basics, features, architecture and terminology involved.
Train Hana Studio Modelers to help you gain expertise in modeling.
Help you master Sap Hana Interface, client, and connectivity.
Learn Auto-documentation process and SAP BO Analysis.
We will help you learn Sap Hana administration activities like managing users, storage and security.
The course will master you on System Replication, data provisioning, and ABAP Data flow.
You will learn all the process for configuring, reporting, and monitoring and dashboard creation.
To provide real-time and complex HANA projects for better understanding.
The course will help you writing Sap Hana queries and performance tuning.

Content

HANA Introduction

In-Memory Computing
Evolution of In-Memory computing at SAP
History of SAP HANA
HANA compare to BWA
In-Memory Basics
HANA Use cases

Architecture

Hana Engine Overview
Different HANA Engine Types
Row Store
Column Store
Persistency Layer
Business Impact of new architecture
Backup & Recovery

Modeling

Key Concepts in Data Modeling
Components of HANA data model & Views
Analytical Views
Attribute views
Calculation Views
Joins
Measures
Filters
Real Time Scenarios
HANA SQL Intro
Functions & Expressions
Procedures

Data Provisioning

Overview
Trigger Based Replication
ETL Based Replication
Log Based Replication
Intro to BODS 4
Basic Data service Connection types
Flat File upload in to HANA

Security

Creating Users
Creating Roles
Privileges
User Administration

Reporting

Connectivity options
Business Objects BI 4

Audience

SAP Developer & BI consultants
Data warehouse professionals
Project Managers
Data Analytics Professionals along with Database Architectures

Prerequisites

Basics of SQL, Database & Data Warehouse
Knowledge about SAP BW preferred
Basic understanding of any ERP business process would be an added advantage

Certification

Trainocate Certificate of Attendance

Lịch khai giảng

Tên khóa học

Thời gian

Lịch dự kiến

Địa điểm

Học phí

ĐĂNG KÝ

Form đăng ký

Bằng cách nhấn nút "ĐĂNG KÝ", tôi hoàn toàn đồng ý với Chính sách bảo mật

Các khóa đào tạo Database khác

ATC-SBO - SAP Business Objects

SAP BODS is a data processing platform, it is used in extracting data from all types of dissimilar systems, transform it into meaningful information and load it into diverse types of systems. With full visibility into data quality, business users of an organization can observe that how their data measures up against information governance rules and standards. Understand the working and importance of SAP BODS to deliver better solutions during crisis. Our training comprises of Basic data profiling and Query Transform, Platform Transforms Overview, Data Integrator Transforms and many more.

ATC-SAMBO - SAP Application Maintenance in Business Objects

SAP BOBI is a collection of front-end applications that enables business persons to view and analyze BI information. SAP BO BI provides an agile management system for a company Business Intelligence standard that enables the corporate world to confidently make use of it and standardize their Business Intelligence implementations. We deliver SAP Business Objects Training that includes detailed knowledge of working with the Business Intelligence tool of the SAP family. Curriculum paths include the Web Intelligence 4.1 Business Objects Explorer 4.2 Enhancement of BO 4.1, Crystal reports for enterprise software. The SAP BOBI solutions can help you simplify the way your decision makers use information.

ATC-MACROS-VBA - Macros VBA (For Non-Programmers)

This course will help to write macros in Excel using programming language Visual Basic Application (VBA). Recorded macro can edit to customize it to fulfill our requirement and one can directly go for coding to accomplish the required tasks. One can write his own functions and procedures, design forms and working with add-ins using VBA Macro

ATC-PSQL-ADM-DEV - PostgreSQL Administration & Development

PostgreSQL is the most advanced open source database; it is globally accepted as an incredibly powerful tool for database management. PostgreSQL Administration & Development course offers you the information required to manage your live production database. It handles the administration and performance tuning of PostgreSQL databases. The candidates of PSQL training program are likely to learn the use of specialized PostgreSQL (AKA Postgres) modules such as replication, connection pooling, and full-text searching.

ATC-MYSQL-BASIC - MySQL Basic

The Introduction to MySQL course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced.

ATC-SAP-S-4HANA-SYSADM - SAP S 4HANA System Administration

For this SAP training course, delegates can learn to explain the Monitoring Architecture, User Administration Fundamentals, Architecture of SAP NetWeaver Application Server Describe the Procedure of a System Logon (AS ABAP) and troubleshooting. The delegate can able to describe SAP system Configuration and Architecture of Database Systems.

Bản quyền thuộc về Trainocate Việt Nam

back to top

Hotline HN
Hotline HCM
Messenger