SQL Course covers all areas that you need to know to work successfully with this very important language. It builds the base on which you can build your future career as a Oracle developer
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
None
What you need to bring
1. Photo-id 2. Passport size photo
Key Takeaways
Oracle SQL programming knowledge