Welcome to the MOST
Latest Course Updates:
Welcome to the MOST
Latest Course Updates:
(Apr 2024) : Brand New Content (Managing Oracle Privileges and Roles) was added.
(Jan 2024) : Brand New Content (Using Oracle
(Dec 2023) : 3-Real SQL(Over 200+ High-Quality Questions) Certification Exam Samples are added.
(Nov 2023) : More Quiz Questions were added.
Important Notice: This course will be continuously getting updated with more lectures, quizzes, and assessments to enhance your knowledge of Oracle SQL.
Are you a student ready to learn SQL for your lessons?
Do you want to get a better job?
Are you bored with watching a lot of stuff, but could not learn anything?
Do you think you know SQL, but you cannot write SQL codes?
Are you looking for a really professional course?
Then this is the course you are looking for.
You are in the right place.
In this course, all the subjects are explained in professional order.
If you are new to SQL, no problem. You can easily learn all the details of SQL. If you already know SQL and want to improve, this course explains all the details including all of the subjects.
After completing this course, you will learn all that you need to know. If you don't see something in this course, it means you really don't need to know it for now.
Coding can be learned with coding. A course that has no example is not a course at all. And there are hundreds and hundreds of codes in this course.
So come on, what are you waiting for?
Get this course, and go get a better job.
Topics covered in the Complete Oracle SQL Bootcamp 2023 Course:
Database Concepts & Terminologies
What is a Database?
What is the Oracle Database?
What is a pluggable database?
What is SQL?
What is a database table?
What is Relational-Database Management System (RDBMS)?
What is the Entity-relationship model in SQL?
What is a database schema?
Installing Oracle Sample Schemas ()
Introduction to Database Objects
Downloading and Installing the Oracle Database (Version 12c, 18c, 19c, 21c, etc.)
Downloading the Oracle Database Installation File
Installing Oracle Database into Your Local Computer
Working with a Database via a Virtual Machine
Downloading and Installing a Virtualization Software (Virtual Box, VMWare)
Downloading Pre-built Virtual Machine Image
Importing Virtual Machine into Virtualization Software
Configuring, Using, and Working with Virtual Machines through Virtualization Software
Downloading, Installing, Configuring, and Using the Oracle SQL Developer Software
Connecting to the Oracle Database Using SQL Developer and SQL Plus
Configuring SQL Developer for the first use
Configuring Network Connections to work with Oracle Sample Schemas
Working with Oracle Live SQL
Introduction to Oracle Live SQL Platform
How to use Oracle Live SQL
Retrieving Data from the Database Using SELECT Statements
What is NULL?
SELECT Statements
Using Column Aliases in SQL
DISTINCT and UNIQUE Operators in SQL
Concatenation Operators in SQL
The Quote (q) Operator in SQL
Filtering & Restricting Data returned by SQL Queries using the WHERE Clause
Using the WHERE Clause in SQL
Using Oracle Comparison Operators in SQL
BETWEEN AND Operator in SQL
IN Operator in SQL
LIKE Operator in SQL
IS NULL Operator in SQL
Logical Operators in SQL:
AND Logical Operator
OR Logical Operator
NOT Logical Operator
Oracle Rules of Precedence in SQL
Sorting Data using the ORDER BY Clause
Using the ORDER BY Clause
Using the ASC and DESC Operators
Using the NULLS FIRST and NULLS LAST Operators
Using the FETCH Clause
Using Oracle Substitution Variables
What are Substitution Variables?
Double Ampersand (&&) and DEFINE &
Join Types in Oracle SQL
How to Create a Join in SQL
Natural Join
Join with the USING Clause
Handling Ambiguous Column Names While Joining Multiple Tables
Inner Join (Join with the ON Clause)
Multiple Join Operations
Restricting Joins
Self-Join
Non-Equijoins (Joining Unequal Tables)
Outer Joins in SQL
Non-ANSI SQL Join Syntaxes)
Using & Building & Analyzing Subqueries
What is a Subquery in SQL?
How to Use Subqueries in SQL?
Subquery Types in SQL:
Single-Row Subqueries in SQL
Multiple-Row Subqueries in SQL
Multiple-Column Subqueries in SQL
SCALAR Subqueries in SQL
Correlated Subqueries in SQL
Using Subqueries as a Table
Using the EXISTS Operator (Semijoins in SQL)
Using the NOT EXISTS Operator
Working with Oracle SET Operators
What are SET Operators and Why are They Used?
UNION Operator
UNION ALL Operator
MINUS Operator
TCL Commands
COMMIT and ROLLBACK Statements in SQL
Row Locking Mechanism in SQL
SAVEPOINT Statement in SQL
FOR UPDATE Statement in SQL
Using Data Definition Language (DDL) Statements
What are Data Definition Language Statements
Naming Rules & Naming Conventions in Oracle
Creating Tables using the CREATE TABLE statements
Oracle Constraint Types
NOT NULL Constraint
UNIQUE Constraint
PRIMARY KEY Constraint
View Types in Oracle
Creating Simple Views
Creating Complex Views
Modifying Views
Performing DML Operations with Views
Using the
The
Creating Sequences
Modifying Sequences
Using Sequences
Using Sequences as Default Values
Sequence Caching
The USER_SEQUENCES View
Using the IDENTITY Column in Oracle
Creating and Using Synonyms
Working with Indexes
Managing Schema Objects
Retrieving Data By Using Subqueries
Manipulating Data By Using Subqueries
Controlling User Access in Details
Managing Data in Different Time Zones
It's a skill that will put you more in demand in the biggest technology companies in the IT industry, and make your software life easier, this is why it's so popular and backed by Oracle.
This course will help you quickly get up to speed with Oracle SQL. I will demystify the query skill and help you understand the essential concepts of how to write SQL codes easily and think analytically against the problem in your company.
Other students enjoy the use of relevant examples throughout the course, as these make the content even easier to comprehend.
Many students had also taken other SQL courses in the past, only to find that this SQL course was their favorite. They enjoyed the structure of the content and the high-quality audio/video.
Check out all of the great reviews in the review section ... a lot of happy students :-)
If you want to Become a Job-Ready SQL Professional who can pass any Oracle SQL Exam confidently, this course will be the next step for you.
So let’s do this. I'll see you in the first lecture.
In this SQL tutorial, the Complete Oracle SQL Bootcamp course participants will learn about what a database is and why we need to use databases with real-world examples.
In this lecture, our students going to learn what a table is and why we need to use the tables.
This lecture is about how to use the Udemy platform. And also includes some useful tips to get most of out the course.
In this lecture, this course participants will be able to claim & download their special quick recap document for The Complete Oracle SQL Bootcamp course.
In this lecture, you're going to learn what the pluggable database (multitenant architecture) is in Oracle Database.
==========================================================
Section: Database Fundamentals Quiz
==========================================================
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "SQL Database Concepts quiz".
In this SQL tutorial, the participants will learn how to get a database to proceed with the Complete Oracle SQL Bootcamp 2022 course.
In this SQL tutorial, the participants will learn how to download and install two virtualization software programs which are VMware and VirtualBox step by step.
In this tutorial, the participants will learn how to download the virtual machine image 19c.
In this tutorial, the participants will learn how to download the virtual machine image.
In this SQL tutorial, the participants will learn how to import the virtual machine image they downloaded into the VMware virtualization software as well as how to configure the virtual machine to get the most out of it.
In this SQL tutorial, the participants will learn how to import the virtual machine image they downloaded into the Oracle VirtualBox virtualization software as well as how to configure the virtual machine to get the most out of it.
In this SQL tutorial, the participants will learn how to configure SQL Developer inside of the Virtual Machine image that they downloaded step by step.
For the students who could succeed to complete the Option-1
In this lecture, students are going to learn the oracle database 19c installation.
Lecture keywords: "oracle", "oracle sql", "oracle database", "oracle database installation", "oracle database 19c installation".
In this lecture, our students are going to learn how to unlock the HR schema to practice throughout the course.
This lecture covers how to download and configure Oracle SQL Developer software and how to connect to the Oracle Database 19c.
In this SQL tutorial, the course participants will learn about the easiest way how to install Oracle Sample Schemas to be able to work with many database sample schemas provided by Oracle.
This code includes the SQL script to generate the HR schema with all its data.
Note 1: You can use this script if you could not have the HR schema properly.
Note 2: Just select all the script and execute in one step when connected as the SYS or SYSTEM user.
Introduces which SQL statements we are going to use in this course. (Oracle's specific SQL details are in next lessons.)
This lecture introduces shows how much we appriciate your thoughts.
In this lesson, we're going to talk about Oracle Data Types which are;
In this lecture, students are going to learn one of the most important concepts of the database terminology which is called "Null". We've explained what a NULL value is in this lecture in details.
This lesson includes Oracle DESC or DESCRIBE Command.
This lesson teaches how to see a better description and some statistics of a table using the INFO[RMATION] and INFO[RMATION]+ Commands.
Includes the code samples used in the INFORMATION Command lecture
This lesson covers Oracle SQL Statement Basics.
This lecture includes the code samples we used within the previous lecture
This lecture explains how to read the Oracle (ORA) error messages and how to take an action to solve your code problems
This lesson covers Oracle SELECT Statements.
This lesson covers Oracle Column Aliases.
This lesson covers Oracle Quote (q) Operator.
This lesson covers the Oracle Distinct (DISTINCT) and UNIQUE operators.
This tutorial explains the solution to the related SQL coding exercise.
In this SQL tutorial, we cover the Concatenation ( || ) Operator in Oracle SQL with various examples.
This lesson covers Oracle SQL Arithmetic Operations like;
and covers NULL values.
You can test your sql skills with our quizzes.
Keywords: "SQL", "sql programming", "quiz", "sql quiz".
In this lesson, students are going to learn the WHERE clause and how to use the WHERE clause in SQL statements and the Oracle Database with its various examples.
In this SQL tutorial, the Complete SQL Bootcamp course participants will learn about Comparison Operators ( <, >, < = , >=, <>) in Oracle SQL with hands-on examples.
In this lesson we're going to learn BETWEEN ... AND Operator in Oracle Database.
In this lesson we're going to learn IN Operator in Oracle Database.
In this lesson we're going to learn LIKE Operator in Oracle Database.
In this SQL tutorial, the Complete Oracle SQL course participants will learn about what the IS NULL Operator is and how to use the IS NULL operator in Oracle SQL.
In this lesson, students are going to learn Oracle Logical Operators which are;
AND Logical Operator
OR Logical Operator
NOT Logical Operator
This lecture includes the SQL code samples we used within the previous lecture
In this lesson, we're going to learn Rules of Precedence in Oracle Database.
Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression.
Operator, Operation
+, -
identity, negation
*, /
multiplication, division
+, -, ||
addition, subtraction, concatenation
=, !=, <, >, <=, >=, IS NULL, LIKE, BETWEEN, IN
comparison
NOT
exponentiation, logical negation
AND
conjunction
OR
disjunction
========================================================
Section: Restricting Data Quiz
========================================================
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "Restricting data quiz".
In this lesson, students are going to learn the ORDER BY Clause in SQL and how to use the ORDER BY Clause in the Oracle Database by its various examples.
This lesson covers the ASC (Ascending) and DESC (Descending) operators in SQL and how to use them in the Oracle Database.
In this lesson, students are going to learn the NULLS FIRST and NULLS LAST Operators in the Oracle Database.
In this lecture, students are going to learn what is ROWID and ROWNUM in SQL, what the ROWID vs ROWNUM differences are.
Lecture keywords: #oracle #sql #rownum #rowid
This lesson introduces students to the FETCH clause in Oracle SQL, which is also known as the row limiting clause, that is used to limit rows returned by a query.
========================================================
Section: Sorting Data Quiz
========================================================
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "Sorting data quiz".
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.