Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Maximizing Your SAP HANA Skills: Top 5 Course Contents to Consider

You can find SAP HANA course contents for your quick reference. You can download as a pdf. Before you take a course these are the contents you need to learn.


Module#1. SAP HANA Introduction and Architecture


  • SAP HANA Overview 
  • SAP In-Memory Computing Overview 
  • SAP HANA Features 
  • Look and feel of SAP HANA 
  • SAP HANA Architecture 
  • SAP HANA Landscape 
  • Structure of SAP in-memory Computing studio 
  • Row store and column store Architecture 
  • Multi Version Currency Control(MVCC) 
  • Persistence Layer in In-memory Computing Engine 
  • Back up &Recovery 
  • High-Availability 
  • Distributed System 
  • Data Provisioning options in SAP HANA 
  • Reporting options on SAP HANA 
  • Security options in HANA 
  • SAP HANA Appliance Model 
  • How SAP HANA Appliance is delivered 
  • Sizing Considerations 
  • SAP HANA –Licensing Options 
  • SAP HANA Project Implementation 
  • Overview: Key Activities 
  • Key Roles 
  • Key Points to keep in mind 
  • Administration


Module#2. Basic Modeling


  • Modeling Overview
  • Terminology
  • SAP HANA Studio Features
  • Information Modeler Overview
  • Installation and Configuration of HANA Studio
  • Prerequisites for Modeling
  • Modeling Considerations
  • Levels of Modeling
  • Attribute Views
  • Analytic Views
  • Modeling Considerations
  • Joins: Different types and when to use what.
  • Where Class Vs Constraint Filters
  • HANA Studio Preview(use with Caution)
  • Impact of Query Execution
  • Demo
  • Modeling Suggestions
  • Troubleshooting Modeling Issues
  • Export and Import Models
  • Analytics Option on HANA
  • HANA Reporting Layer & Connectivity Options
  • Reporting on HANA Clients
  • Reporting on HANA Open Interfaces
  • Prerequisites for reporting on SAP HANA
  • IMDB client installation
  • Setting up new connection
  • SAP Business Objects BI4.0:Overview & tool comparison
  • Analytical Reporting on HANA
  • Relational Reporting on HANA
  • Reporting on HANA Demo Included
  • Native Excel Interface via ODBO
  • SAP Business Object Analysis(Office Edition)
  • SAP Business Object Explorer
  • Semantic Layer Approach
  • IDT Vs Universe Designer
  • SAP BOBJ Web I
  • SAP BOBJ Xcelsius
  • SAP Crystal Reports
  • Enterprise Vs 2011
  • Front end tool reporting considerations on top of HANA
  • Troubleshooting common reporting issues


Module#3. Advanced Data Modeling with SQL Script


  • Modeling Overview 
  • Calculation View :Overview & Types 
  • SQL Script :Motivation 
  • SQL Script: Overview 
  • SQL Script Processing 
  • Data Type Extensions 
  • Scalar Data type 
  • Table type 
  • Functional Extension 
  • Concept 
  • Procedure 
  • Procedure Calls 
  • Implementing Functional logic 
  • Operators 
  • SQL Script/Built in Function 
  • Debugging and troubleshooting SQL Script 
  • Restrictions for SQL Statement


Module#4. Data Provisioning: Data Services and Sybase Replication


  • Data Provisioning :Overview 
  • Data Provision Options 
  • Trigger Based Replication 
  • ETL-Based Replication 
  • Log-Based Replication 
  • SAP Business Objects Data Services 4.0 and HANA 
  • ODP enabled Extractor Support in Data Services 4.0 
  • HANA and Data Service Process flow for SAP and non-SAP data 
  • How it works for SAP System 
  • How it works for Non-SAP System 
  • Advanced Data Service options 
  • Column tables creation 
  • Bulk loader options & configuration 
  • Bulk extracting options & configuration 
  • Log based replication overview 
  • Technical system landscape 
  • User administration 
  • Authorization 
  • Installing log based replication 
  • Updating the SAP host agent on source system 
  • Installing Sybase components 
  • Deploying the SAP HANA load controller and related components 
  • Configuring log based replication 
  • Configuring Sybase components 
  • Sybase replication server 
  • Enterprise connect data access(ECDA) 
  • Sybase replication agent 
  • Test Sybase components 
  • Configure SAP HANA load controller on SAP HANA system 
  • Initializing replication using SAP HANA system 
  • Initializing replication using SAP HANA load controller
  • Module#5. DATA PROVISIONING: SAP LANDSCAPE TRANSFORMATION (SLT)
  • Data provisioning overview 
  • SAP landscape transformation set-up 
  • Options for SLT landscape installation 
  • Post installation stem 
  • Concept of SLT replication 
  • Architecture and key building block 
  • Technical requirement and system set-up information for LT replication server 
  • Key benefits of LT replicating server 
  • Transformational capabilities 
  • Operations 
  • Security and user management in HANA 
  • Creation of users 
  • Creation of roles 
  • Assignment privileges to roles

 

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers