Oracle SQL Exam Prep
- Offered byCoursera
- Public/Government Institute
Oracle SQL Exam Prep at Coursera Overview
Duration | 7 hours |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
Oracle SQL Exam Prep at Coursera Highlights
- Earn a Certificate upon completion from LearnQuest
Oracle SQL Exam Prep at Coursera Course details
- This course is designed to help you continue learning about Oracle SQL and prepares you to take the Oracle SQL Certification Exam
- We'll review methodologies and terminology that we presented in the Oracle Specialization courses, show some demos and give in-depth explanations
Oracle SQL Exam Prep at Coursera Curriculum
SQL and Table Design
Introduction To The Course
Why SQL?
Table Design (Part 1 of 2)
Table Design (Part 2 of 2)
Schema Building Exercise
Activity: Creating a Schema
Reading: Schemas
Module 1 Quiz
Database Terms (Part 1 of 6)
Database Terms (Part 2 of 6)
Database Terms (Part 3 of 6)
Database Terms (Part 4 of 6)
Database Terms (Part 5 of 6)
Database Terms (Part 6 of 6)
SQL Database Terms
More Database Terms to Know
Module 2 Quiz
Key Constraints and the USING Clause
Primary Key Constraint (Part 1 of 2)
Primary Key Constraint (Part 2 of 2)
Foreign Key Constraint
Foreign Key Constraint and the Using Clause
Primary Key Constraints
Foreign Keys and the USING Clause
Module 3 Quiz
Using SQL Functions within Queries
Subqueries
More on Subqueries and Pseudocolumns
Views
Materialized Views
Subqueries Further Explained
View versus Materialized View
Module 4 Quiz
Practice SQL Certification Exam
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?