HA150 SAP SQL Basics for HANA

Price
$2,697.00
Duration
 2 Days
Delivery Methods
 VILT    Private Group

This course refreshes your SQL knowledge and enables you to use advanced SQL techniques for querying and manipulating data in SAP HANA database.

 

Upcoming Class Dates and Times

This class is not currently scheduled.
Contact us and we will help you get the training you need!

Who Should Attend

Application Consultants with focus on modeling and Developers

Agenda

1 - Module 1
  • Motivation & Basic Concepts
2 - Module 2
  • Reading from a table or view
3 - Module 3
  • SELECT Clause
4 - Module 4
  • Functions
5 - Module 5
  • Tuple Variables
6 - Module 6
  • Case Expression
7 - Module 7
  • Duplicate Elimination
8 - Module 8
  • Sorting
9 - Module 9
  • WHERE Clause
10 - Module 10
  • Aggregate Expressions
11 - Module 11
  • Grouping
12 - Module 12
  • Reading data from multiple tables or views
13 - Module 13
  • Union and Join
14 - Module 14
  • Sub Queries
15 - Module 15
  • Changing database access
16 - Module 16
  • INSERT, UPDATE, DELETE statements
17 - Module 17
  • Data definition and access control
18 - Module 18
  • Data Types
19 - Module 19
  • CREATE, ALTER, DROP table
20 - Module 20
  • Renaming Columns
21 - Module 21
  • Views
22 - Module 22
  • Granting and Revoking privileges
23 - Module 23
  • Access Paths and Indexes
24 - Module 24
  • Database transactions
25 - Module 25
  • COMMIT, ROLLBACK
26 - Module 26
  • Multi-user mode and synchronization
27 - Module 27
  • NULL values
 

Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with United Training