Training Courses

search courses

OCDB: Oracle Database SQL

Guaranteed to Run Scheduled Fully Booked
Location
Wellington
Aug 2022
15
Nov 2022
14
Code: OCDB
Length: 5 Days
Overview

Delivery format(s)
On-Site
On-Site
Classroom
Classroom
OBJECTIVES
a. Relational Database conceptsb. Retrieving Data using the SQL SELECT Statementc. Restricting and Sorting Datad. Using Single-Row Functions to Customize Outpute. Using Conversion Functions and Conditional Expressionsf. Reporting Aggregated Data Using Group Functionsg. Displaying Data from Multiple Tablesh. Using Subqueries to Solve Queriesi. Using SET Operatorsj. Managing Tables using DML statementsk. Managing Indexes Synonyms and Sequencesl. Use DDL to manage tables and their relationshipsm. Managing Viewsn. Controlling User Accesso. Managing Objects with Data Dictionary Viewsp. Managing Data in Different Time Zones

Enquiry Form