National Training Institute LLC | Course Detail

National Training Institute (NTI) is a market leader in creating workplace competency. We provide vocational training and employment solutions to corporates in the Sultanate.

National Training Institute LLC
+968 24228600
info@ntioman.com
PO Box 267, Postal Code 115
Madinat Al Sultan Qaboos
Sultanate of Oman

Course Details

Oracle Database: SQL Workshop

Course Overview

This course introduces Oracle Database technology and the relational database concepts and the powerful SQL programming language. This course provides you with the essential SQL skills of querying the database, the Meta data and creating database objects. In addition, the course also delves into the advanced querying and reporting techniques, data warehousing concepts and manipulating large data sets in different time zones. It also covers the Adobe Rich Media Communication Using Flash Professional objectives, and is intended to help prepare you to take the Adobe Certified Associate exam.

Designers and developers who are new to Flash. Applicable to Oracle8i, Oracle9i and Oracle Database 10g users.

Basic knowledge Database

Successful candidates will receive a certificate issued by National Training Institute LLC (NTI), attested by the Ministry of Higher Education.

Other Details

Module 1: Introduction
Module 2: Retrieving Data Using the SQL SELECT Statement
Module 3: Restricting and Sorting Data
Module 4: Using Single Row Functions to Customize Reports
Module 5: Reporting Aggregated Data Using the Group Functions
Module 6: Displaying Data From Multiple Tables
Module 7: Using Sub queries to Solve Queries
Module 8: Producing Readable Output with iSQL*Plus
Module 9: Using the SET Operators
Module 10: Manipulating Data
Module 11: Using DDL Statements to Create and Manage Tables
Module 12: Creating Other Schema Objects
Module 13: Managing Objects with Data Dictionary Views
Module 14: Controlling User Access
Module 15: Manage Schema Objects
Module 16: Manipulating Large Data Sets
Module 17: Generating Reports by Grouping Related Data
Module 18: Managing Data in Different Time Zones
Module 19: Searching Data Using Advanced Sub queries
Module 20: Hierarchical Data Retrieval
Module 21: Performing Regular Expression Support and Case Insensitive

By the end of the module the candidate will be able to

Understand the basic concepts of relational databases ensure refined code by developers.
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 row and column data from
tables.
Control privileges at the object and system level.
Create indexes and constraints; alter existing schema objects.
Create and query external tables.

Instructor-led training