Oracle SQL
In this course you will learn how a Database works: the structure of SQL, how to build queries, DML, Commit and Rollback, Subqueries, Joins and Set Operations. Also you will learn how to manipulate dates, numbers and strings with standard Functions, and how to handle null-values. It also has chapters on working witj SQL*Developer and querying in Oracle eBS.
Course Formats
This course is available as:
- Instructor led training
- e-Learning
- Book
- Any combination of the 3 options
Audience
- End User
- Implementer
- Manager
Topics
- Not only Queries
- Relational database: RDBMS
- History of data storage
- Advantages of a SQL Database
- Relations
- PLSQL
- Trigger
- Function
- Query in SQL*Developer
- Find database objects
- Datatypes
- Without Order by there is no order
- Between and IS NULL
- Sum() and Avg()
- Insert
- And many more…