This course is designed to help you continue learning about Oracle SQL and prepares you to take the Oracle SQL Certification Exam.
Oracle SQL Exam Prep
Instructor: Rafiq Wayani
Sponsored by Louisiana Workforce Commission
2,331 already enrolled
(11 reviews)
Recommended experience
Details to know
Add to your LinkedIn profile
5 assignments
See how employees at top companies are mastering in-demand skills
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There are 5 modules in this course
In this module, we'll introduce you to the course and discuss which topics we'll cover. We'll also explore why SQL is a powerful tool to use and some of it's uses. Then, we'll explore table design and schemas.
What's included
5 videos2 readings1 assignment
In this module, we'll explore some of the key terms you'll need to know when building SQL Databases. We will compare and contrast the ANY and ALL operators, distinguish between COMMIT and ROLLBACK, and explore pseudocolumns. We will also give examples for some of these terms.
What's included
6 videos2 readings1 assignment
In this module, we'll review primary and foreign keys, delving a little more into their constraints. We'll also explore the USING clause and what it is used for.
What's included
4 videos2 readings1 assignment
In this module, we'll take a look at INSTRING and SUBSTRING functions and demonstrate naming a column using an alias. We will also explore subqueries and take another look at pseudocolumns. Lastly, we'll discuss views and compare them with materialized views.
What's included
5 videos2 readings1 assignment
The following ungraded quiz will help you practice what you have learned before taking the Oracle SQL Certification Exam.
What's included
1 assignment
Instructor
Offered by
Why people choose Coursera for their career
Learner reviews
11 reviews
- 5 stars
83.33%
- 4 stars
16.66%
- 3 stars
0%
- 2 stars
0%
- 1 star
0%
Showing 3 of 11
Reviewed on Dec 25, 2024
Best for Beginners. The course gives a good overview of Oracle SQL DB, and the articles attached will be helpful for future reference as well.
Recommended if you're interested in Information Technology
University of Colorado System
SkillUp EdTech
Google Cloud
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy