Loading Classes
SQL Basics for SAP HANA (HA150)
- SAP
Certifications:
SAP CDS - ABAP for SAP HANA (Edition 2015)
New Age Technologies has been delivering Authorized Training since 1996. We offer SAP’s full suite of authorized courses including courses pertaining to SAP SQL Basics, Supply Chain Management (SCM), Enterprise Resource Planning (ERP), BusinessObjects, Product Lifecycle Management (PLM), and more. If you have any questions or can’t seem to find the SAP class that you are interested in, contact one of our SAP Training Specialists. Invest in your future today with SAP training from New Age Technologies.
✉ SAP Training Specialists | ☏ 502.909.0819
Current Promotion
COURSE INFORMATION
SQL Basics for SAP HANA (HA150) Course Overview:
In this course you can learn the basics of SAP HANA SQL or refresh your SQL knowledge, as well as the basics of SQL Script to create user-defined functions and database procedures in SAP HANA.
NOTE: Course based on software release – SAP HANA SPS11
Who Should Attend:
- Developer
- Developer Consultant
- Technology Consultant
- Database Administrator
SQL Basics for SAP HANA (HA150) Course Goals:
- Use basic and some advanced SQL techniques for querying and manipulating data in a SAP HANA database
- Develop user-defined functions and database procedures using SQL Script
SQL Basics for SAP HANA (HA150) Course Content:
- SQL and the relational database model
- Reading data from a table or view
- Calculated Columns and Functions
- CASE expressions
- Duplicate Elimination
- Sorting and limiting result sets
- The WHERE clause
- Aggregating and grouping data
- Reading data from multiple tables or views: Unions, Joins and Sub Queries
- Understanding NULL values
- Changing data stored in tables
- Defining how data is stored using SQL
- Creating user-defined functions and database procedures using SQL
- SQL Script basics
- Scalar user-defined functions
- Table user-defined functions
- Database procedures
- Defining data access using SQL
