- Level Foundation
- Duration 6 hours
- Course by LearnQuest
-
Offered by
About
This course is designed to help you learn how to navigate the Oracle Database environment. Both GUI and command-line tools will be introduced to allow you to work with the Oracle Database. It is recommended that you complete the first course in this specialization, Oracle Database Foundations, before continuing to this second course.Modules
DB Platform: Getting Started
1
Discussions
- Why Oracle?
2
Videos
- Oracle Database Platform Course Introduction
- Oracle Database Platform: Course Goals
1
Readings
- Oracle Database Platform & History
Large Datasets, Database Path, and Purpose
1
Discussions
- Food for Thought
2
Videos
- Large Datasets
- Database Path & Purpose
Database Roles, Admin Tools, and Oracle Net Architecture
1
Discussions
- Fact or Fiction?
3
Videos
- Database Roles
- Oracle Database Admin Tools
- Oracle Net Architecture
2
Readings
- Database Configuration Assistant (DBCA)
- Understanding Oracle Net Architecture
Module 2 Review
1
Assignment
- Module 2 Quiz
Oracle Graphical Interface part 1
5
Videos
- GUI Tools: SQL Developer
- SQL Developer: Oracle Connections
- SQL Developer: Indexes, Packages, and Procedures
- SQL Developer: Functions and Operators
- SQL Developer: Queues and Queues Tables
1
Readings
- Oracle Packages
Oracle Graphical Interface part 2
2
Discussions
- Changes to the Production Environment
- Synonyms
3
Videos
- SQL Developer: Triggers and Types
- SQL Developer: Sequences, Materialized Views, and Materialized View Logs
- SQL Developer: Synonyms, Public Synonyms, Database Links, and Public Database Links
2
Readings
- Creating Triggers
- Synonyms
Practice Quiz
1
Assignment
- Practice Review
Oracle Graphical Interface part 3
1
Discussions
- RDF - Something to think about
3
Videos
- SQL Developer: Directories, Editions, Java, & XML
- SQL Developer: OLAP, Analytic Views, & Scheduler
- SQL Developer: RDF Semantic Graph
3
Readings
- Developing in Java within Oracle
- Data Warehousing in Oracle
- RDF Semantic Graph
Oracle Graphical Interface part 4
4
Videos
- SQL Developer: Table Details - Column Info.
- SQL Developer Demo: Table Details
- Demo: SQL Developer - Create Table
- Demo: SQL Developer - Using SQL DDL Syntax
1
Readings
- Oracle SQL DDL
Module 3 Review
1
Assignment
- Module 3 Review
Auto Summary
Learn to navigate the Oracle Database environment with this foundational course in IT & Computer Science. Taught by expert instructors at Coursera, you'll explore both GUI and command-line tools over 360 minutes of engaging content. Ideal for beginners, this course is part of a specialization, with subscription options available for both Starter and Professional levels. Perfect for aspiring database professionals looking to build a strong foundation.

Rafiq Wayani