Training Schedule Training Schedule

(HA150) SAP HANA 2.0 SPS03 SQL and SQLScript for SAP HANA
Code: HA150 v15
Type: null
Tuition (USD): $1500
Length: 2 Days
Have a question?

Contact Us

character(s) remaining

Location Date Guaranteed to Run
Live Virtual, US 02/20/2019
Live Virtual, US 05/20/2019
Newtown Square, PA 06/24/2019

Not finding any suitable dates? Contact us for additional availability: training@dunnsolutions.com

Skills Gained:
1) Push down data intensive tasks to the SAP HANA database using SQL and SQL Script 2) Understand how to code using advanced SQL Script techniques 3) Follow recommended practices for writing optimal SQL and SQL Script 4) Debug and analyze SQL and SQL Script code
Who Should Attend?
Application Developer Data Modeler BI / BW Consultant Data Scientist Database Administrator SAP HANA Support Personnel
Prerequisites:
  • Recommended : HA100; Previous knowledge of ANSI-92 SQL
What You Will Learn:
  • 1) Getting Started
  • a) What is SQL and SQL Script?
  • b) Understanding XS Advanced and HDI
  • c) Working with Web IDE for SAP HANA
  • d) Understanding the course data
  • 2) SQL Logic Containers
  • a) Creating user-defined functions
  • b) Creating database procedures
  • c) Trapping errors in SQL Script
  • d) User defined libraries
  • 3) Declarative Logic
  • a) Using declarative logic
  • 4) Imperative Logic
  • a) Using imperative Logic
  • 5) OLAP Operations
  • a) Using OLAP Analytic features
  • 6) Working with Hierarchies
  • a) Working with Hierarchies
  • 7) Troubleshooting and Best Practices
  • a) Tools for troubleshooting
  • b) Best Practices
  • 8) Appendix: Starting from the beginning with SQL fundamentals.
  • Notes
  • • This course assumes students already have a basic knowledge of standard SQL and the focus is on SQL Script. But the course does include excellent and comprehensive coverage of standard SQL in the appendix for those who need to start from the very beginning. The appendix content will not be covered in class and is for offline use only.
  • • This course is based on SAP HANA 2.0 and uses Web IDE / XSA but is useful for customers working with SAP HANA 1.0 using Studio / XS
Course Info:
Course based on software release: SAP HANA 2.0 SPS03

Course notes and announcements:

1) In order to maximize the performance of data models and applications running on SAP HANA, it is essential that all data related tasks are programmed at the database level. The language used is SQL and its very special extended variant called SQL Script. This short course covers programing with SQL and SQL Script on the SAP HANA database and includes all key areas for writing efficient declarative and imperative code. You will also be guided on the use of recommended approaches.

2) This course assumes students already have a basic knowledge of standard SQL and the focus is on SQL Script. But the course does include excellent and comprehensive coverage of standard SQL in the appendix for those who need to start from the very beginning. The appendix content will not be covered in class and is for offline use only.

3) This course is based on SAP HANA 2.0 and uses Web IDE / XSA but is useful for customers working with SAP HANA 1.0 using Studio / XS


This is a SAP CERTIFIED Course. Your course will include Full Class Delivery of the comprehensive standard SAP curriculum agendas, SAP Certified Instructor, Demonstration and Presentation, Student Hands on exercises, Access to SAP Hosted servers/training environment, SAP Certified e-book participant guides and SAP Certified Hard copy participant guides.

This 2 day instructor led course qualifies for 16 CPE Credits. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.

With virtual live classroom training you get comprehensive training from SAP experts using seamless over-the Web connectivity. The same content delivered in SAP's traditional "brick and mortar" classrooms is presented during virtual live classroom deliveries. As in SAP's traditional classrooms, SAP virtual live classroom stresses hands-on learning providing each registered student with exclusive access to live SAP systems throughout each course. Each Virtual Live class is taught by a SAP Certified Instructor and will include an e-book student guide for you to download and keep. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.

Not finding any suitable dates? Contact us for additional available dates: training@dunnsolutions.com