About this Course

Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects.

*This course prepares the participants for the Oracle Database: SQL Database Certified SQL Expert Exam (Exam Code : 1Z0-047)

Course Outline:

1. Retrieving Data Using the SQL SELECT Statement

2. Restricting and Sorting Data

3. Using Single-Row Functions to Customize Output 

4. Reporting Aggregated Data Using the Group Functions

5. Displaying Data from Multiple Tables 

6. Using Subqueries to Solve Queries 

7. Using the Set Operators 

8. Manipulating Data 

9. Using DDL Statements to Create and Manage Tables 

10. Creating Other Schema Objects  

11. Managing Objects with Data Dictionary Views

12. Controlling User Access 

13. Managing Schema Objects 

14. Manipulating Large Data Sets 

15. Generating Reports by Grouping Related Data 

16. Retrieving Data Using Subqueries

17. Hierarchical Retrieval

18. Regular Expression Support 

Prerequisites:

Familiarity with data processing concepts and techniques Data processing

Certificate Of Attendance:

Certificate Of Attendance will be awarded to participants completing the course achieving minimum 75% attendance.

Training Duration:

Full-time: 5 Weekdays / 5 Sats         Time : 9.30am - 5.30pm 

Part-time: 10 Sessions                     Time : 7.00pm - 10.00pm (twice a week)

Rate this course:

Log in to submit

Comments