SQL Fundamentals for Oracle Functional Consultants

Udemy Certificate USD 19.99
Enroll now →
SQL Fundamentals for Oracle Functional Consultants

About this course

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. The entire course has been delivered by the way of a realistic business scenario, and has been demonstrated over Oracle Applications Database. This course covers 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 + Retrieving Data using SQL from Multiple Tables + Restricting and Sorting Data

What you'll learn

  • Write basic SQL queries using Oracle Applications Database
  • Install and set up SQL Developer
  • Retrieve data using SQL SELECT statements
  • Understand database objects through Oracle Application forms
  • Identify database tables linked to Oracle Applications Views
  • Create and interpret Entity Relationship (ER) diagrams
  • Retrieve data from multiple tables
  • Sort and restrict data in queries

Skills you'll gain

Related courses

Course details are provided by the platform and may change — always confirm on the provider's site. Links may be affiliate links.