COURSE OVERVIEW
- This course is designed for Application Developer seeking to enhance their skills and knowledge in their field.
- This course is designed for Data Modelers seeking to enhance their skills and knowledge in their field.
- If you are a BI/BW Consultant or aspiring to be one then you can take up this course.
- If you are a Data Scientist you can take up this course.
- This course is suitable for individuals working as Database Administrators.
- This course is designed for SAP HANA Support Personnel seeking to enhance their skills and knowledge in their field.
- You are required to have some previous knowledge of ANSI-92 SQL and HA100 SAP HANA Introduction course.
SAP Identity Management
COURSE INSIGHT
HA150 SAP HANA SQL And SQLScript For SAP HANA is an instructor-led or virtual course that uses SAP HANA 2.0 SPS 03 software. During your learning progress, you will be provided with free study material, some lab exercises, unlimited lab access, and hands-on training. You will delve into programming with SQL and SQL Script specifically tailored for the SAP HANA database. It covers all the essential areas necessary for writing efficient declarative and imperative code, and you will receive guidance on recommended approaches throughout the course. It is important to note that this course assumes students already possess a basic knowledge of standard SQL, with the main focus being on SQL Script. However, for those who require a refresher or are starting from scratch, the course includes comprehensive coverage of standard SQL in the appendix. It’s worth mentioning that the appendix content will not be covered during the class sessions and is provided solely for offline reference. You can however be offered a free retraining session but the passing guarantee for this course is 100% assured.
COURSE OUTLINE
- Getting Started
- Fast and effective walk through HDBSQL and SQLScript and its special functionalities
- Understanding SAP HANA extended application services and HDI to support SAP HANA development in SQL
- Learn to work with Web IDE for SAP HANA
- Quickly finding the right way to SQL solutions
- SQL Essentials
- SQL Logic Containers
- Creating user-defined functions
- Creating database procedures
- Trapping errors in SQLScript
- User defined libraries, functions and stored procedures
- Declarative Logic
- Using declarative logic
- Imperative Logic
- Using imperative logic if needed
- How to implement transactional save points
- Working with temporal tables
- OLAP operations
- Using OLAP analytic features
- Working with hierarchies
- Troubleshooting and best practices
- Tools for troubleshooting and creating professional performance tuning
- Best practices and how to reduce code volume while leveraging smart SAP HANA functionalities
- Appendix: Starting from the beginning with SQLfundamentals
The Benefits of Studying HA150 SAP HANA SQL And SQLScript For SAP HANA
- You will gain skills to push down data-intensive tasks to the SAP HANA database using SQL and SQL Script.
- You will be equipped with advanced SQL Script techniques for coding.
- You will gain a better understanding of recommended practices for writing optimised SQL and SQL scripts.
- You will be able to develop, debug and analyse SQL and SQL Script.
Dates And Prices
Start Date | Timing | Days | Duration | Mode Of Training | Request Price/Future Dates |
---|---|---|---|---|---|
01.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
08.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
10.07.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
15.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
22.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
24.07.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
29.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
05.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
07.08.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
12.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
19.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
21.08.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
26.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
02.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
04.09.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
09.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
16.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
18.09.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
23.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
30.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online |