Oracle SQL
In this chapter we will explain the basics of payroll processing, such as what processing options are available, and the sequencing for processing employees’ payments. We will also define important terms and concepts, essential for day to day payroll administration. By the end of this chapter you will be able to run basic tasks such as creating a new payroll, a new assignment set,
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…