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!
UTAP Funding: NTUC Members can utilize UTAP to offset 50% of the remaining fees*.
Duration: 4 Full Days
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.
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.
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.
This course is well suited for the following audience:
- Application Developers
- Forms Developers
- PL/SQL Developers
- Reports Developers
- Technical Consultant
- End Users
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.
This course is well suited for the following audience:
- Application Developers
- Forms Developers
- PL/SQL Developers
- Reports Developers
- Technical Consultant
- End Users
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.
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.
Claim SDF Grant
Companies sponsoring their staff for training can Claim SDF Funding, subject to SSG Eligibility Criteria.
Applicable for Company Sponsored Singaporeans & PRs.
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!
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 Any Questions or Need a Quotation?
Simple. Just tell us what you need. 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 6250-3575 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.