3. SAP HANA Row vs Column store tables

CHECK PLAY LIST FOR FULL COURCE

*** This is the first comprehensive online course on SAP HANA SQL & SQL Scripting ***

Welcome to comprehensive SAP HANA SQL & SQL Scripting course. You want to learn how to develop SQL skills on HANA? This course is for you.
It is the perfect time to learn HANA technologies. There are a lot of requirement for HANA Developers,
as many SAP clients moving from traditional databases to HANA. This comprehensive tutorial teaches required skills to become HANA SQL Developer.
This course covers almost all features SQL and SQL Script with real-world example (including Design time objects and Core Data Services)

Here are few highlights of the course:

1. Introduce HANA Express Edition (HXE) which is a free HANA Developer version for learning and prototyping purpose.
2. Walk you through steps to setup your HANA studio for the first time.
3. Key HANA concepts (Row store vs Column store and Delta Merge)
4. Multiple sample databases created by us for learning and practice
5. Start with very basic SELECT SQL statements to advanced stored procedures using SQL scripting.
6. Covers each and every key word of SQL & SQL scripting.
7. More than 5 ways to create a table.
8. Imperative and Declarative statements.
9. Extensive content on SQL scripting.
Scalar UDF's
Table UDF's
Stored Procedures
Scripted Calculation views.
Table Variables, Input Parameters etc..
10. Provided detailed explanation on best practices to follow and real world examples.
11. HANA Certification SQL part is covered.
12. Special features like IDENTITY, Dynamic Filters, Exception handling and much more.
13. Development Objects and Designtime Objects.
14. Core Data Services (CDS).
15. By end of this course, you will be very confident on SQL & SQL scripting.

This is a comprehensive course and we'll keep adding the content when new features available as part of new HANA versions.

Please feel free to check out course content to know more about this course.

[srinua]

Nicely explained the concepts column store and row store and the differences between those, thanks for your efforts and sharing this video. One can easily understand the concepts.

[anv.]

Excellent! well appreciated your contribution. finally understood this apparently simple but considerably so complex topic. Thanks

[kunalp]

Excellent explanation of row and column store tables

[cristobalcolombo]

Thank you very much, very well explained!

[pratyushpradhan]

Thanks sir. Really understood the concept. :)

[nagarajudiddi]

Excellent! Very well explained, How it will read the compressed columns..?

[anilkumarmk]

2 Doubts please!
1. Do you mean business analytics is just only with whole colomn operation.
2. Is this computer concept is new after such long adaptations of RDBMS? And is this a new INNOVATION by SAP?

[krzysztofcierpia]

Why only select ? What about insert, update, delete. In insert rows are way faster same for update and delete. Best approach is to have a mixture not all in columns or rows.

[gt-gauravtaluja]

how to truncate 123465489 to 123465 in sap hana sql?

[kamalb]

It is still not clear why it is faster, i can see the number of hops is the same for both col and row. Another question when data is compressed (in col)how the system will know where is the end of the record?

[rajsharma]

what is a CAMPETAR ?? is it part of KALAMS ?? and please explain ADAR also in detail