SAP Library - SQL Tutorial

Start Level 1 Node: SQL Tutorial

End Level 1 Node: SQL Tutorial

Start Level 2 Node: Demo Data for the SQL Tutorial

Demo Data for the SQL Tutorial

End Level 2 Node: Demo Data for the SQL Tutorial

Start Level 3 Node: SQL Statements for the HOTEL Demo Schema

SQL Statements for the HOTEL Demo Schema

End Level 3 Node: SQL Statements for the HOTEL Demo Schema

Start Level 3 Node: Explanation of the Tables in the HOTEL Demo Schema

Explanation of the Tables in the HOTEL Demo Schema

End Level 3 Node: Explanation of the Tables in the HOTEL Demo Schema

Start Level 2 Node: Data Query

End Level 2 Node: Data Query

Start Level 3 Node: Selecting, Arranging and Renaming Columns

Selecting, Arranging and Renaming Columns

End Level 3 Node: Selecting, Arranging and Renaming Columns

Start Level 3 Node: Selecting and Arranging Rows

Selecting and Arranging Rows

End Level 3 Node: Selecting and Arranging Rows

Start Level 3 Node: Conditions: Comparison, AND, OR, BETWEEN, IN

Conditions: Comparison, AND, OR, BETWEEN, IN

End Level 3 Node: Conditions: Comparison, AND, OR, BETWEEN, IN

Start Level 3 Node: Searching for Character Strings: LIKE

Searching for Character Strings: LIKE

End Level 3 Node: Searching for Character Strings: LIKE

Start Level 3 Node: Negative Conditions: NOT

Negative Conditions: NOT

End Level 3 Node: Negative Conditions: NOT

Start Level 3 Node: Creating Groups: GROUP BY, HAVING

Creating Groups: GROUP BY, HAVING

End Level 3 Node: Creating Groups: GROUP BY, HAVING

Start Level 3 Node: Arithmetic Operations

Arithmetic Operations

End Level 3 Node: Arithmetic Operations

Start Level 3 Node: Functions

End Level 3 Node: Functions

Start Level 3 Node: Set Functions

End Level 3 Node: Set Functions

Start Level 3 Node: Date and Time Calculations

Date and Time Calculations

End Level 3 Node: Date and Time Calculations

Start Level 3 Node: Converting Values

Converting Values

End Level 3 Node: Converting Values

Start Level 3 Node: Changing Character Strings

Changing Character Strings

End Level 3 Node: Changing Character Strings

Start Level 3 Node: Information About Character Strings

Information About Character Strings

End Level 3 Node: Information About Character Strings

Start Level 3 Node: Subquery: Inner Queries

Subquery: Inner Queries

End Level 3 Node: Subquery: Inner Queries

Start Level 3 Node: Joins: Information From Several Tables

Joins: Information From Several Tables

End Level 3 Node: Joins: Information From Several Tables

Start Level 3 Node: Set Operations: UNION, INTERSECT, EXCEPT

Set Operations: UNION, INTERSECT, EXCEPT

End Level 3 Node: Set Operations: UNION, INTERSECT, EXCEPT

Start Level 2 Node: Data Definition

Data Definition

End Level 2 Node: Data Definition

Start Level 3 Node: Tables

End Level 3 Node: Tables

Start Level 3 Node: Constraints

End Level 3 Node: Constraints

Start Level 3 Node: Primary key

End Level 3 Node: Primary key

Start Level 3 Node: Foreign Key Dependencies Between Tables

Foreign Key Dependencies Between Tables

End Level 3 Node: Foreign Key Dependencies Between Tables

Start Level 3 Node: View Tables

End Level 3 Node: View Tables

Start Level 3 Node: Indexes

End Level 3 Node: Indexes

Start Level 3 Node: Domains

End Level 3 Node: Domains

Start Level 3 Node: Database Procedures

Database Procedures

End Level 3 Node: Database Procedures

Start Level 3 Node: Database Functions

Database Functions

End Level 3 Node: Database Functions

Start Level 3 Node: Database Triggers

Database Triggers

End Level 3 Node: Database Triggers

Start Level 3 Node: Number Generators for Tables

Number Generators for Tables

End Level 3 Node: Number Generators for Tables

Start Level 3 Node: Number Generator for a Single Table Column

Number Generator for a Single Table Column

End Level 3 Node: Number Generator for a Single Table Column

Start Level 2 Node: Data Manipulation

Data Manipulation

End Level 2 Node: Data Manipulation

Start Level 3 Node: Inserting, Updating and Deleting Rows

Inserting, Updating and Deleting Rows

End Level 3 Node: Inserting, Updating and Deleting Rows

Start Level 2 Node: Authorization

End Level 2 Node: Authorization

Start Level 3 Node: Database Users and Their Privileges

Database Users and Their Privileges

End Level 3 Node: Database Users and Their Privileges

Start Level 3 Node: Roles

End Level 3 Node: Roles

Start Level 3 Node: Schemas

End Level 3 Node: Schemas

Start Level 2 Node: Evaluating System Tables (Examples)

Evaluating System Tables (Examples)

End Level 2 Node: Evaluating System Tables (Examples)