SQL Course covers all areas that you need to know to work successfully with this very important language.

Topics Covered

• Introduction to Oracle SQL • Basics of RDBMS • Using SQL commands • Manipulating and sorting data • Using single row sub-function • Using group functions • Working with data from multiple tables • Using subqueries and set operators • Data Manipulation (DML) commands • Data definition (DDL) commands • Working with other objects – Views, Synonyms etc • Managing Objects with Data Dictionary Views • Controlling User Access • Manage Schema Objects • Manipulating Large Data Sets • Generating Reports by Grouping Related Data • Managing Data in Different Time Zones • Retrieving Data Using Subqueries • Hierarchical Retrieval of data • Regular Expression Report

Who should attend

* Technical Consultants * Functional Consultant * Project Managers

Pre-requisites

Basic computing knowledge

What you need to bring

Photo-id Passport photo

Key Takeaways

Sound knowledge of Oracle SQL programming Confidence in tackling all SQL programming queries