Duration
3 days
(7 hours per day – 9 a.m. – 5p.m.)
Date
4th – 6th August 2021
(Remote Online Learning)
Goals
This course will prepare you to:
- Find smart ways in HANA to push down data intensive tasks to SAP HANA with SQLScript
- Understand how to code using advanced SQLScript techniques with guided best practices
- Follow recommended best practices in data models for writing in- memory optimized SQL code
- Debug and analyze SQL and SQLScript code to generate solutions at higher quality
Audience
- Application Developer
- Data Modeler
- BI / BW Consultant
- Data Scientist
- Database Administrator
- SAP HANA Support Personnel
Prerequisites
Essential
- Previous knowledge of ANSI-92, ANSI-99 or ANSI-2003 SQL Recommended
- HA100
Day 1
9am-10:30am
- Getting Started
- Fast and effective walk through HDBSQL and SQLScript and its special functionalities
- Understanding XS Advanced and HDI to support HANA development in SQL
10:30am-10:45am Morning break 10:45-12:30pm
- Learn to work with Web IDE for SAP HANA
- Finding quickly the right way to SQL solutions
12:30pm-1:30pm Lunch 1:30-3:30pm
- SQL Essentials
- SQL Logic Containers
- Creating user-defined functions
3:30pm-3:45pm Afternoon Break 3:45pm-5:00pm
- Creating database procedures
- Trapping errors in SQLScript
- User defined libraries-, functions and stored procedures
Day 2
9am-10:30am
- Declarative Logic
- Using declarative logic
10:30am-10:45am Morning break 10:45-12:30pm
- Imperative Logic
- Using imperative Logic
- How to implement transactional save points
12:30pm-1:30pm Lunch 1:30-3:30pm
- Working with Temporal Tables
3:30pm-3:45pm Afternoon Break 3:45pm-5:00pm
- OLAP Operations
- Using OLAP Analytic features
Day 3
9am-10:30am
- Working with Hierarchies
10:30am-10:45am Morning break 10:45-12:30pm
- Troubleshooting and Best Practices
- Tools for troubleshooting
12:30pm-1:30pm Lunch 1:30-3:30pm
- Best Practices
3:30pm-3:45pm Afternoon Break 3:45pm-5:00pm
- Appendix: Starting from the beginning with SQL fundamentals.
Programme scope, delivery arrangements and suitability are confirmed during enquiry.