SQL Basics for SAP HANA

Become a Certified SAP HANA Professional

Curriculum


Getting Started

  • What is SQL and SQL Script?
  • Understanding XS Advanced and HDI
  • Working with Web IDE for SAP HANA
  • Understanding the course data

SQL Logic Containers

  • Creating user-defined functions
  • Creating database procedures
  • Trapping errors in SQL Script
  • User defined libraries

Declarative Logic

  • Using declarative logic

Imperative Logic

  • Using imperative Logic

OLAP Operations

  • Using OLAP Analytic features

Working with Hierarchies

  • Working with Hierarchies

Troubleshooting and Best Practices

  • Tools for troubleshooting
  • Best Practices

Appendix: Starting from the beginning with SQL fundamentals.

  • Lesson: Understanding Motivation and Basic Concepts
  • Lesson: Using Data from a Table or View
  • Lesson: Understanding NULL Values
  • Lesson: Aggregating Data
  • Lesson: Understanding Unions and Joins
  • Lesson: Reading Data from Multiple Tables – Part 2
  • Lesson: Changing Data Stored in Tables
  • Lesson: Defining how Data is Stored
  • Lesson: Using Views for Data Access
  • Lesson: Defining Data Access
  • Lesson: Explaining Database Transactions

Course Features


LIVE, INSTRUCTOR-LED ONLINE TRAINING

Live and interactive online sessions with an industry expert instructor.

24/7 SUPPORT

Expert technical team available for query resolution.

LIFETIME LMS ACCESS

We provide lifetime Learning Management System (LMS) access, which you can access from across the globe.

PRICE MUCH GUARANTEE

The best price, aligning with the quality of our course deliverables

CERTIFICATE

After completing the course, you will appear for an assessment from Cognatrix. Once you pass, you will be awarded a course completion certificate.

FAQs


WILL I GET POST-TRAINING ACCESS TO COURSE MATERIAL?

Yes, you will get lifetime access to the LMS portal.