The Complete Oracle SQL Bootcamp (Udemy.com)
From Beginner to Oracle SQL Developer: Get Ready for Oracle Certification Exam 1Z0-071 and Become Oracle SQL Certified
Created by: Tareq Alkhateeb
Last updated June 2024
What you will learn
- Master the Contents Required to Pass Oracle SQL Exam 1Z0-071
- The Full Track of Oracle Database SQL 18c
- Have the Ability to Solve any Oracle SQL Problem
- Downloading and Installing Oracle Database 18c Express Edition
- Installing Oracle SQL Developer
- Connecting to the Database using Oracle SQL Developer and SQLPlus
- Retrieving Data Using SELECT statement
- Restricting and Sorting Data Using WHERE and ORDER BY Clause
- Using Single-Row Functions to Customize Output
- Reporting Aggregated Data Using the Group Functions
- Displaying Data From Multiple Tables Using Joins
- Using Subqueries Part I
- Using Set Operators
- Manipulating Data Using DML Statements Part I
- Data Definition Language (DDL) / Creating Tables
- Data Dictionary Views
- Data Definition Language (DDL) / Creating Views
How it compares
Against the other 388 rated Udemy courses in SQL on CourseDuck:
- Rating4.5 out of 5higher than 48% of them
- Reviews371#236 of 389 by number of reviews
- Length15.8 hourslonger than 87% of them
- Last updatedJune 2024more recently than 55% of them
Course Description
Welcome to the Complete Oracle SQL Bootcamp 2024.
If you want to get ready and become a professional Oracle SQL Developer and Prepare for an Oracle SQL Certification Exam 1Z0-071: Oracle Certified Associate (OCA), then this course is the best for you.
Do you want to get a better job?
Are you bored with watching a lot of stuff, but could not learn anything?
Are you looking for a really professional course?
Then this is best Oracle SQL course you are looking for.
You have come to the right place!
If you are new to Oracle SQL, no problem! You can easily learn with all the details of SQL. If you already know SQL and want to improve you skills, this course explains all the details including all of the subjects.
Get this course, and go get a better job!
In this course, all the subjects are explained in a professional way.
All practices and solutions are in the lessons. you can pause the video and complete the practice before resuming to watch the solution. Make sure you solve the practice on your own before moving on to the solution!
Topics covered in this course:
Downloading and installing Oracle database express 18c in details
Downloading and installing Oracle SQL Developer
Connecting to Oracle Database using SQL Developer and SQLPlus
Retrieving data using the select statement
Restricting / Filtering Data
Sorting Data
Using Substitution Variables
Using Single-Row Functions to Customize Output
Reporting Aggregated Data Using the Group Functions
Displaying Data from multiple tables using joins
Using Subqueries to Solve Queries Part I
Using the Set Operators
Manipulating tables using DML Statements ( Insert, Update, Delete )
Using Data Definition Language / Creating tables
Managing objects with data dictionary views
Creating Views in details
Creating sequences, synonyms, and indexes
Managing Schema Objects
Retrieving Data By Using Subqueries Part II
Manipulating Data By Using Subqueries
Controlling User Access in details
Manipulating Data using DML Part II
Managing Data in Different Time Zones
Instructor Details
- 4.5 Rating
371 Reviews
Tareq Alkhateeb
Oracle Technology Track Lead and Trainer with 12+ years of experience, supporting huge and critical databases, designing and implementing database solutions that improve business functionality, availability and continuity, upgrading and migrating existing database solutions, conducting certified oracle technology trainings.
Proficient in Oracle Database, Oracle RAC, Oracle Data Guard, Oracle Performance Tuning, Oracle Application Sever, RMAN Backup and Recovery, Oracle E-Business Suite, Oracle Golden Gate and Oracle database security (AVDF)
More SQL courses
SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2025)
4.8 (2,153 Reviews)
Provider: Udemy
Time: 19.7h
$94.99
SQL Server High Availability and Disaster Recovery (HA/DR) (2026)
4.8 (1,810 Reviews)
Provider: Udemy
Time: 88.3h
$16.99
70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (2025)
4.8 (1,094 Reviews)
Provider: Udemy
Time: 3.6h
$12.99
Modern Event-Driven Spring Boot: Kafka & Spring Cloud Stream (2026)
4.8 (494 Reviews)
Provider: Udemy
Time: 13.4h
$10.99
Oracle Database 12c Backup and Recovery using RMAN (2024)
4.8 (428 Reviews)
Provider: Udemy
Time: 20.1h
$34.99
Reviews
By David Ilatov on 6/24/2023
Your explanation in the videos is very clear and understandable. In addition, the practice is helping to understand the oracle sql. Thank's for your course :)
By Raushan kumar on 8/17/2022
nice video and easy language for understanding
By Eduardo Romero on 2/3/2022
I haven't finished the course yet, but at this point it's so understable, in despite of you don't understand English that's not a problem, because Tareq explains pretty well
By Peter Kosmas on 11/27/2021
Good but there are some tricky questions in the exam which this course does not include.
By Otieno Samson Ochieng on 9/28/2021
Worth 5* rating......!!!!
By Gaurav on 8/23/2021
Only started...looks good
By Jawad on 5/18/2021
Amazing Course , Very informative and smooth explanation ,the instructor take you directly to the main points in a very professional way
By Abdul Waheed on 4/18/2021
Instructor is highly knowledgeable and experienced. Well designed course and excellent course delivery. I would highly recommend this course who want to learn Oracle SQL.
By Emad AbuGhazaleh on 4/6/2021
All the best for you Tareq, it is really a very high quality training. All is good all is clear. Thanks for the great slides too.
By James Mbuga on 4/4/2021
This is a good match for my career endeavors!
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 90 / 100






