Oracle Database SQL Expert

This course introduces you to the fundamentals of SQL using Oracle Database. Learn the concepts of relational databases and masters in 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!

Duration: 4 Full Days

Course Objectives

Learn Oracle @Intellisoft Singapore
Learn Oracle @Intellisoft Singapore

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.

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. 

Course Outline

Oracle Training @Intellisoft
Oracle Training @Intellisoft

This course covers the following 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: Oracle Database SQL Certified Expert upon passing Exam 1Z0-047 Oracle Database SQL Expert.

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

 

Pre-Requisites

General knowledge of Database concepts will help, Though not essential. We will teach the basics from the beginning, 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 looking for Formal Oracle Certification in the use of SQL – with passing the Oracle SQL Expert certification exam.

Course Objectives

Learn Oracle @Intellisoft Singapore
Learn Oracle @Intellisoft Singapore

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.

Go To Top

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. 

Go To Top

Course Outline

Oracle Training @Intellisoft
Oracle Training @Intellisoft

This course covers the following 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: Oracle Database SQL Certified Expert upon passing Exam 1Z0-047 Oracle Database SQL Expert.

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

 

Go To Top

Pre-Requisites

General knowledge of Database concepts will help, Though not essential. We will teach the basics from the beginning, 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 looking for Formal Oracle Certification in the use of SQL – with passing the Oracle SQL Expert certification exam.

Go To Top

Microsoft Access 2010 Training at Intellisoft

Claim SDF & PIC Grant

Companies sponsoring their staff for training can claim from the Skills Development Fund.

Further, they can claim 40% of training fee or 400% Tax Rebate from IRAS With PIC scheme.

skills-future-training

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

computer-training-participants

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Do You Have a Question or Need a Quotation?

Simple. Just tell us what you need below. We'll be glad to help you!

Some of the companies that experienced our trainings

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 us 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.

Learn Oracle
&
Advance Your Career

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!