No certificate is given for this course
Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database.
SQL provides statements for a variety of tasks, including:
+ Querying data
+ Inserting, updating, and deleting rows in a table
+ Creating, replacing, altering, and dropping objects
+ Controlling access to the database and its objects
+ Guaranteeing database consistency and integrity
By the end of this course you will be able to write basic SQL queries using Oracle Applications Database. This will ultimately complement your job of an Oracle Functional Consultant.
This course covers the 'Part 1 - Basic Level', and includes following sub-modules within it:
+ Overview of Oracle Applications Database and SQL
+ Download and Install SQL Developer
+ Retrieving Data using the SQL SELECT Statement
+ Finding information about database objects from front-end Oracle Application forms
+ Finding database tables linked to Oracle Applications database Views
+ Entity Relationship (ER) Diagrams for Oracle Applications database tables
+ Functional Implementer
+ End Users
+ IT Consultants who are looking for making career as Oracle Functional Consultant
This course helps to prepare for following Oracle Certification:
+ Exam Number: 1Z0-047
+ Exam Name: Oracle Database SQL Expert
Kabeer is a seasoned Oracle professional and has been working with Oracle Applications since last 20 years. He is proficient in Oracle E Business Suite, Oracle Fusion Applications Cloud and Solution Architecture. Originally from India, he has traveled extensively on consulting assignments across South Asia and Australasia. He has worked with some of the well known large corporations, including Oracle Corporation in their Consulting Services division.
He started his career by learning Oracle Applications on 10.6 Character and 10.7 Smart Client versions. Since then he has extensively worked on Oracle E Business Suite releases 11, 11i and up until the latest release 12i.
Since last couple of years Kabeer has been working on Oracle E-Business Suite, Oracle Fusion Applications Cloud, Virtualization using VM, Solution Architecture and Cloud Computing on leading cloud provides such as Oracle, AWS, Google, Microsoft Azure etc.
Kabeer likes to work out in gym a couple of times in a week, and loves to go on hiking to natural bushes, beaches and countryside over the weekend.
View Kabeer's Profile on LinkedIn