About this Course

This course introduces you to the fundamentals of SQL using Oracle Database. Learn the concepts of relational databases and master SQL programming language.

Get the essential SQL skills that allow you to write queries against single and multiple tables, manipulate data in tables, and create database objects on your own.

Learn and Prepare for the SQL Expert Certification Exam in this Training. Be a Oracle Certified SQL Expert!

Course Objectives

You will also learn to use single row functions to customize output, use conversion functions and conditional expressions. Usage of group functions to report aggregated data is also covered in detail. Practical, hands-on exercises reinforce the fundamental concepts.

• Display data from Single Tables
  
• Display data from multiple tables using JOIN syntax.
  
• USe SQL functions to generate customized data.
  
• Create reports of aggregated data easily
  
• Use the SET operators to create subsets of data.
  
• Run data manipulation statements (DML) in Oracle Database 11g.
  
• Run data definition language (DDL) statements to create schema objects.
  
• Identify the major structural components of Oracle Database 11g.
  
• Retrieve data from tables, views
  
• Create reports of sorted and restricted data using specific SQL Syntax.
  

Course Outline

This course covers the followig topics in depth:

• Introduction to Oracle Database
  
• Retrieve Data using the SELECT statement, from a single table.
  
• Learn to Restrict and Sort Data in different ways
  
• Usage of Single-Row Functions to Customize Output
  
• Invoke Conversion Functions and Conditional Expressions
  
• Aggregate Data Using the the Group Functions
  
• Display Data from Multiple Tables Using Join Statement.
  
• Use Sub-queries to create simpler Queries
  
• The SET Operators to restrict different sets of data
  
• Data Manipulation Statements to modify data in the Oracle database
  
• Use of Data Definition Language (DDL Statements) to Create and Manage Tables
  
• Other Schema Objects
  
• Control User Access
  
• Management of Schema Objects
  
• Manage Objects with Data Dictionary Views
  
• Manipulate Large Data Sets within Oracle database
  
• Data Management in different Time Zones
  
• Retrieve Data Using Sub-queries in different ways
  
• Regular Expression Usage in Oracle
  

Certification & Registration

After attending this training, you will have the required skills and ability to take the Oracle Certification Exam 1Z0-047 Oracle Database SQL Expert.

Target Audience

This course is well suited for the following audience:

• Application Developers
  
• Forms Developers
  
• PL/SQL Developers
  
• Reports Developers
  
• Technical Consultant
  
• End Users
  

This course is appropriate if you are using Oracle 10g or Oracle 11g database. 

Prerequisites

General knowledge of Database Concepts will help, though not essential. We will teach the basics from the begining, and make sure that the foundation is strong.

Familiarity with data processing concepts and techniques will be good also.

This course is well suited for beginners and advanced users of Oracle, who are vying for Formal Oracle Certification in the use of SQL - with passing the Oracle SQL Expert certification exam.

How To Register:

To Register for Oracle SQL Expert Training, Simply Register Online, and book your seat today by  sending an online enquiry today. You can call Vinai at (65) 6296-2995 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming class of Oracle SQL Expert Certification Training.

We also offer Corporate Trainings for Oracle Database SQL Expert Certification.

If you have a group of people, we can arrange to conduct the Oracle 10g or 11g database training at your office location too. Just contact us for details.

Certification: 

Oracle Database SQL Certified Expert upon passing Exam 1Z0-047 Oracle Database SQL Expert.

Duration: 

4 Full Days

Rate this course:

Log in to submit

Comments