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. You'll also have the opportunity to take a practice certification exam. We recommend that you first complete the Oracle SQL Databases Specialization.
Subqueries
Loading...
Skills You'll Learn
Database Design, Database Management, Query Languages, Data Integrity, Oracle Databases, Verification And Validation, Relational Databases, Database Theory, SQL
Reviews
4.9 (15 ratings)
- 5 stars86.66%
- 4 stars13.33%
SN
Dec 26, 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.
AZ
Mar 5, 2025
Amazing course. I recommend this course to anyone trying to elevate their sql skills.
From the lesson
Functions, Subqueries, Pseudocolumns, and Views
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.
Taught By
Rafiq Wayani