The Oracle Database: SQL Workshop I training course introduces participants to Oracle Database 12c database technology. This training will equip participants with major concepts of relational databases and the perks of SQL programming language.
The course will deliver essential SQL skills to developers that will help them to write queries against single and multiple tables, manipulate data in tables, and create database objects. The participants are also introduced to Oracle Database Exadata Express Cloud Service.
Completion of this training course will enable candidates in:
Course Benefits:
Attaining certification of this course will make participants deploy Oracle SQL Developer as the main environment tool for writing SQL. This course introduces SQL*Plus as an optional tool.
1. Introduction
2. Retrieving Data using the SQL SELECT Statement
3. Restricting and Sorting Data
4. Using Single-Row Functions to Customize Output
5. Using Conversion Functions and Conditional Expressions
6. Reporting Aggregated Data Using the Group Functions
7. Displaying Data from Multiple Tables Using Joins
8. Using Subqueries to Solve Queries
9. Using the SET Operators
10. Managing Tables using DML statements
11. Introduction to Data Definition Language
The Oracle Database: SQL Workshop I is ideal for:
Name | Code | Fee |
---|
ENQUIRY FORM
OR