Dozent gesucht für Auftrag - Oracle - Designer

Explaining the theoretical and pysical aspects of relational databases
Relating clauses in SQL SELECT Statement to Components of an ERD
Explaining the relationship between a database and SQL
Sorting Data
SQL-Joins
Using the ORDER BY clause in set operations
Set Operators
Managing Indexes
Managing Squences
Peforming arithmetic with date data
Manipulating numbers with ROUND, TRUNC and MOD functions
Manipulating dates with the date function
Managing Views
GROUP BY
Subqueries
Update and delete rows using correlated subqueries
Managing and control Transactions
Peforming MERGE statements
Describing and working with tables
Describing and working with columns and data-types
Creating tables
Truncating tables
Creating and using temporary tables
Creating and using external tables
Managing constraints
Working with CURRENT_DATE, CURRENT_TIMESTAMP and LOCALTIMESTAMP
Working with INTERVAL data types
Basics User and Role Management
Basics PL/SQL Stored Procedures Functions and Trigger