SAP HANA Studio
Share |
This category contains courses related to SAP HANA Studio



Navigation:HomePrevious Topic: SAPNext Topic: SAP HANA on AWS

TutorialsDescription
*What is SAP HANA? Introduction and Overview of SAP HANAThis video explains What SAP HANA is. It talks about its components and the in-memory database.
*What is SAPGui? SAP GUI OverviewThis video explains the concept of SAPGUI a.k.a SAP GUI or Graphical User Interface
*Why SAP HANA?The topic for this video is: Why SAP HANA? This video discussed that challenges that were addressed by the creation of SAP HANA
*The Evolution of SAP HANA DatabaseIt discussed how SAP HANA was created from TREX, MaxDB, and P*Time.
*SAP HANA - The Column Oriented (Based) DatabaseThis video explains the concept of column based database or column oriented database. You will learn how SAP HANA achieved
*SAP HANA CertificationsThis video explains certification options related to SAP HANA.
*SAP HANA Studio Tutorial 1 - Getting Trial Access for SAP HANA Studio and HANA DatabaseThis video explains the steps necessary to get trial access for SAP HANA Studio and the SAP HANA Database for practice and learning purposes.
*SAP HANA Studio Tutorial 2: Adding a System in SAP HANA Studio to Connect to HANA DatabaseThis video explains how to configure SAP HANA Studio to connect to SAP HANA database. The steps are shown to add a new system and to create a new connection.
*SAP HANA Studio Tutorial 3 - Creating Tables Using SAP HANA StudioThis video explains the steps to create database tables using SAP HANA Studio.
*SAP HANA Studio Tutorial 4 - INSERT StatementThis video explains the steps to insert records in tables using SAP HANA Studio via INSERT Statement
*SAP HANA Studio Tutorial 5 - SELECT Statement's Column ListThis video explains the steps to retrieve particular columns from the tables using SAP HANA Studio via SELECT Statement
*SAP HANA Studio Tutorial 6 - SELECT Statement's WHERE ClauseThis video explains the steps to retrieve particular records from the tables using WHERE Clause in the SELECT Statement. The operations are performed in SAP HANA Studio.
*SAP HANA Studio Tutorial 7 - Using Multiple Conditions in the WHERE ClauseThis video explains how multiple conditions could be placed in a WHERE Clause of a SELECT Statement. The operations are performed in SAP HANA Studio.
*SAP HANA Studio Tutorial 8 - Creating Many to Many Relationship TableThis video explains many to many relationship concept and the steps to create a database table using SAP HANA Studio.
*SAP HANA Studio Tutorial 9 - Creating CSV File and Uploading to ServerThis video explains how a CSV file could be created containing data and uploaded to the server. Data could be imported from CSV file into a table. The operations are performed using SAP HANA Studio.
*SAP HANA Studio Tutorial 10 - Creating Control File for CSV to Table ImportThis video explains how a control file is created for importing data from a CSV file to table. The operations are performed using SAP HANA Studio.
*SAP HANA Studio Tutorial 11 - Importing CSV Data into SAP HANA TableThis video explains how data is imported from a CSV file into to table. The operations are performed using SAP HANA Studio.
*SAP HANA Studio Tutorial 12 - UPDATE StatementThis video explains how UPDATE statement works. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 13 - Implementing One to Many RelationshipThis video explains how one to many relationship implemented. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 14 - DELETE StatementThis video explains how DELETE statement works. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 15 - Cross Joins and Inner JoinsThis video explains the concepts of cross joins (Cartesian products) and inner joins. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 16 - Table AliasesThis video explains the concepts of table aliases in a SELECT statement. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 17 - Implicit and Explicit Join SyntaxThis video explains implicit and explicit join syntax. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 18 - Outer Joins (Right and Left)This video explains the concepts of outer joins (right and left). The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 19 - More Examples of Outer Joins (Right and Left)This video provides more examples outer joins (right and left). The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 20 - Full Outer JoinsThis video explains full outer joins with examples. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 21 - Inner Joins of Three TablesThis video provides demonstration of inner joins of three tables. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 22 - Right/Left Outer Joins of Three TablesThis video provides demonstration of right/left outer joins of three tables. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 23 - Full Outer Joins of Three TablesThis video provides demonstration of full outer joins of three tables. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 24 - Subqueries (Sub Queries)This video explains the concept of SELECT statement subqueries (sub queries). The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 25 - Selecting Distinct Records (Using DISTINCT Keyword)This video explains the concept of selecting distinct or unique records. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 26 - Subqueries (Sub Queries) vs JoinsThis video explains differences between subqueries (sub queries) and joins. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 27 - Multilevel Nested SubqueriesThis video provides examples of three level and four level nested subqueries. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 28 - Sorting Results Using Order By ClauseThis video explains how to sort the result of SELECT statement using Order By Clause. The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 29 - Set Operations: Union/Union AllThis video explains Union and Union All Set operations in SELECT statement .The operations are performed on SAP HANA database using SAP HANA Studio
*SAP HANA Studio Tutorial 30 - Set Operations: MinusThis video explains Minus Set operation in SELECT statement .The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 31 - Set Operations: IntersectThis video explains Intersect Set operation in SELECT statement .The operations are performed on SAP HANA database using SAP HANA Studio.
*SAP HANA Studio Tutorial 32 - Intersect vs Inner Join vs SubqueryThis video demonstrates how certain queries could be handled using intersect set operation, inner join (explicit and implicit), and subquery methods. The operations are performed on SAP HANA database



Navigation:HomePrevious Topic: SAPNext Topic: SAP HANA on AWS
Tags: SAP HANA Studio