Brief Summary
This course is all about writing basic SQL queries using Oracle Applications Database, which is super helpful for becoming an awesome Oracle Functional Consultant. It covers everything you need to know, from setting up SQL Developer to retrieving and sorting data!
Key Points
-
Learn to write basic SQL queries on Oracle Applications Database
-
Install SQL Developer and get familiar with its features
-
Retrieve data using SQL SELECT Statement
-
Understand database objects through Oracle Application forms
-
Explore the relationship between database tables and views
Learning Outcomes
-
Write basic SQL queries to gather data effectively
-
Navigate Oracle Applications Database confidently
-
Install and use SQL Developer for your queries
-
Understand how database tables and views work together
-
Sort and restrict data for better analysis
About This Course
Learn to write basic SQL queries on Oracle Applications Database to be successful in job of Oracle Functional Consultant
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
Terry B.
Excellent course!!! Need a little more time to explain self joins.