Duration
40 hours, 5-day training workshop
Delivery
Face to face training or online training
Course Inclusive
Description
This training teaches you how to write sub queries, combine multiple queries into a single query using SET operators and report aggregated data using group functions.
Course Content
- Introduction to Oracle Database
- Retrieve Data using the SQL SELECT Statement
- Learn to Restrict and Sort Data
- Usage of Single-Row Functions to Customize Output
- Invoke Conversion Functions and Conditional Expressions
- Aggregate Data Using the Group Functions
- Display Data From Multiple Tables Using Joins
- Use Sub-queries to Solve Queries
- The SET Operators
- Data Manipulation Statements
- Use of DDL Statements to Create and Manage Tables
- Other Schema Objects
- Control User Access
- Management of Schema Objects
- Manage Objects with Data Dictionary Views
- Manipulate Large Data Sets
- Data Management in different Time Zones
- Retrieve Data Using Sub-queries
- Regular Expression Support