This Oracle Database: Introduction to SQL training teaches you how to write subqueries, combine multiple queries into a
single query using SET operators and report aggregated data using group functions.
Expert Oracle University instructors will help you explore how to control privileges at the object and system level.
MODULE 1
Introduction to Oracle Database
MODULE 2
Retrieve Data Using the SQL SELECT Statement
MODULE 3
Learn to Restrict and Sort Data
MODULE 4
Usage of Single-Row Functions to Customize Output
MODULE 5
Invoke Conversion Functions and Conditional Expressions
MODULE 6
Aggregate Data Using the Group Functions
MODULE 7
Display Data From Multiple Tables Using Joins
MODULE 8
Use Sub-queries to Solve Queries
MODULE 9
The SET Operators
MODULE 10
Data Manipulation Statements
MODULE 11
Use of DDL Statements to Create and Manage Tables
MODULE 12
Other Schema Objects
MODULE 13
Control User Access
MODULE 14
Management of Schema Objects
MODULE 15
Manage Objects with Data Dictionary Views
MODULE 16
Manipulate Large Data Sets
MODULE 17
Data Management in Different Time Zones
MODULE 18
Retrieve Data Using Sub-queries
MODULE 19
Regular Expression Support
Benefits to You:
You’ll also learn to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered.
Learn To:
- Create reports of sorted and restricted data.
- Run data manipulation statements (DML).
- Control database access to specific objects.
- Manage schema objects.
- Manage objects with data dictionary views.
- Retrieve data from tables.
- Create indexes and constraints and alter existing schema objects.
- Create and query external tables.
- Use the regular expression support in SQL.
Course attendance certificate issued by Semos Education