SQL Basics for SAP HANA
Become a Certified SAP HANA Professional
- 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
- Using declarative logic
- Using imperative Logic
- 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
LIVE, INSTRUCTOR-LED ONLINE TRAINING
Live and interactive online sessions with an industry expert instructor.
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
After completing the course, you will appear for an assessment from Cognatrix. Once you pass, you will be awarded a course completion certificate.
WILL I GET POST-TRAINING ACCESS TO COURSE MATERIAL?
Yes, you will get lifetime access to the LMS portal.