Training Schedule Training Schedule

(HA150) SAP HANA 2.0 SPS02 SQL and SQLScript for SAP HANA
Code: HA150 v14
Type: null
Tuition (USD): $2250
Length: 3 Days
Have a question?

Contact Us

character(s) remaining

Contact us for upcoming dates.
Skills Gained:
1. Use SQL techniques to query and manipulate data in an SAP HANA database 2. Develop Scalar and Table User-Defined Functions using SQLScript 3. Trap errors in SQLScript, customize error conditions and control program flow to deal with errors 4. Create and use database procedures using SQLScript and understand how to debug them 5. Manage data access control at SQL level 6. Understand database index management 7. Understand database transactions in SAP HANA
Who Should Attend?
Application Consultant Database Administrator Developer Developer Consultant Technology Consultant
Prerequisites:
  • Essential
  • None
  • Recommended
  • None
What You Will Learn:
  • 1) Motivation and Basic Concepts
  • a) Understanding SQL and relational model
  • 2) Data from a Table or View
  • a) Using Data from a Table or View
  • 3) Aggregation of Data
  • a) Understanding NULL Values
  • b) Aggregating Data
  • 4) Data from Multiple Tables
  • a) Understanding Unions, Joins and Subqueries
  • 5) Data Stored in Tables
  • a) Changing Data Stored in Tables
  • 6) Data Storage
  • a) Defining How Data is Stored
  • 7) Views for Data Access
  • a) Using Views for Data Access
  • 8) OLAP Operations
  • a) Using OLAP Analytic Features
  • 9) SQL Script Functions and Procedures
  • a) Creating User-Defined Functions
  • b) Creating Database Procedures
  • 10) Data Access
  • a) Defining Data Access
  • 11) Database Transactions
  • a) Explaining Database Transactions
Course Info:
Course based on software release: SAP HANA 2.0 SPS 02

Course notes and announcements:

1) In this course, you will learn about the SAP HANA SQL or refresh your SQL knowledge. We will also take a deep dive into SQLScript and learn how to embed data-intensive application logic into SAP HANA using user- defined functions and database procedures.

2) This course is designed for consultants with no/little knowledge of SQL as well as for those who wants to learn about the SQL extension SAP HANA SQLScript.c

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 3 day instructor led course qualifies for 24 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