The Complete Oracle SQL Bootcamp (2022)

Become an In-demand SQL Professional! Pass Oracle SQL 1Z0-071 (OCA) Certification Exam Confidently!

4.63 (13697 reviews)
Udemy
platform
English
language
Databases
category
55,585
students
32.5 hours
content
Aug 2022
last update
$109.99
regular price

What you will learn

Pass Oracle 1Z0-071 SQL Database SQL Certification Exam easily on your first try!

Be Able to Answer any SQL Interview Questions Confidently!

Become a Job-Ready SQL Developer by Learning All the Skills You will Need!

Learn Oracle SQL by Professionally Designed Content Step by Step!

Write, Read and Analyze Any SQL Queries Easily and Learn How to Play with Data!

Solve any SQL-related Problems by Yourself Creating Analytical Solutions!

Test Your SQL Skills with Hundreds of Hands-on Examples, Quizzes, Challenges!

Lifetime Support from the Instructors. Get a Well-Organized Recap Document!

Description

Welcome to the MOST COMPREHENSIVE Oracle SQL Bootcamp Course on the planet!

Latest Course Updates:

  • (Jun 2022) : 3-Real SQL(200+ High-Quality Questions) Certification Exam Samples are added!

  • (May 2022): Brand New Content was added!

  • (Apr 2022) : 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 2022 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 (HR, SH, OE, IX, etc.)

    • 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 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 & UNDEFINE Commands

    • ACCEPT and PROMPT Commands

    • SET VERIFY ON / SET VERIFY OFF Commands

  • Using Oracle Single-Row Functions to Customize the Query Outputs

    • Introduction to Oracle Single-Row Functions

    • Character Functions

      • Case Conversion Functions

        • UPPER Function

        • LOWER Function

        • INITCAP Function

      • Character Manipulation Functions

        • SUBSTR Function in SQL 

        • LENGTH Function in SQL 

        • CONCAT Function in SQL 

        • INSTR Function in SQL 

        • TRIM Function in SQL 

        • LTRIM and RTRIM Functions in SQL 

        • REPLACE Function in SQL 

        • LPAD and RPAD Functions in SQL 

      • Numeric Functions

        • ROUND Function in SQL

        • TRUNC Function in SQL 

        • CEIL Function in SQL 

        • FLOOR Function in SQL 

        • MOD Function in SQL

      • Nested SQL Group Functions

      • Date Data Types and SQL Date Functions

        • Date Data Types

          • DATE Data Type in SQL

          • TIMESTAMP Data Type in SQL 

          • TIMESTAMP WITH TIME ZONE Data Type in SQL 

          • TIMESTAMP WITH LOCAL TIME ZONE Data Type in SQL

        • Oracle Date Functions

          • SYSDATE Function in SQL

          • CURRENT_DATE Function in SQL

          • SESSIONTIMEZONE Function in SQL

          • SYSTIMESTAMP Function in SQL

          • CURRENT_TIMESTAMP Function in SQL

        • Date Manipulation Functions

          • ADD_MONTHS Function

          • MONTHS_BETWEEN Function

          • ROUND Function

          • TRUNC Function

          • EXTRACT Function

          • NEXT_DAY Function

          • LAST_DAY Function

  • Oracle Conversion Functions

    • TO_CHAR Function in SQL

    • TO_NUMBER Function in SQL

    • TO_DATE Function in SQL

    • Null Related Functions in SQL

      • NVL Function

      • NVL2 Function

      • NULLIF Function

      • COALESCE Function

  • Conditional Expressions in SQL

    • CASE Expressions in SQL

    • DECODE Function in SQL

  • Reporting Aggregated Data Using the Group Functions

    • Introduction to Oracle Group Functions

    • AVG Function in SQL

    • COUNT Function in SQL

    • MAX Function in SQL

    • MIN Function in SQL

    • LISTAGG Function in SQL

    • Overview of Group Functions in SQL

  • Displaying Data from Multiple Tables Using Joins

    • What is a SQL Join?

    • 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

      • LEFT OUTER JOIN (LEFT JOIN)

      • RIGHT OUTER JOIN (RIGHT JOIN)

      • FULL OUTER JOIN (FULL JOIN)

    • Cross Join (Cartesian Product or Cross Product)

    • Oracle's Old Style Join Syntax (Comparison of ANSI vs. 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

    • INTERSECT Operator

    • Combining Multiple Queries Using Multiple SET Operators in Complex SQL Queries

  • Using Data Manipulation Language (DML) Statements

    • INSERT Statement

    • UPDATE Statement

    • DELETE Statement

    • MERGE Statement

    • Multiple INSERT Statements

    • Unconditional INSERT (INSERT ALL) Statements

    • Conditional INSERT ALL Statements

    • Conditional INSERT FIRST Statements

    • Pivot Insert in SQL

  • Using Transaction Control Language (TCL) Statements

    • What is a transaction in SQL?

    • 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

    • CREATE TABLE AS SELECT (CTAS) Statement in Oracle

    • ALTER TABLE Statement

    • Marking Columns Unused (Using The SET UNUSED Clause)

    • READ-ONLY Tables in SQL

    • DROP TABLE Statement

    • TRUNCATE TABLE Statement

    • COMMENT Statement

    • RENAME Statement

  • Creating, Using, Working, and Managing Constraints

    • What is a Constraint in SQL?

    • Oracle Constraint Types

    • NOT NULL Constraint

    • UNIQUE Constraint

    • PRIMARY KEY Constraint

    • FOREIGN KEY Constraint

    • The ON DELETE CASCADE Clause

    • The ON DELETE SET NULL Clause

    • CHECK Constraint

    • Adding Constraints via ALTER TABLE Statements

    • Dropping (Removing) Constraints

    • Cascading Constraints in Oracle

    • Renaming Constraints

    • Enabling / Disabling Constraints

    • Status of Constraints

    • Deferring (Deferrable) Constraints

  • Creating, Using, and Managing Database Views in Details

    • What is a Database View and What is it Used for?

    • View Types in Oracle

    • Creating Simple Views

    • Creating Complex Views

    • Modifying Views

    • Performing DML Operations with Views

    • Using the WITH CHECK OPTION Clause in SQL

    • Using the WITH READ ONLY Clause on Views

  • Managing Objects Using Oracle Data Dictionary Views

    • What are Data Dictionary views in Oracle?

    • The DICTIONARY View (The Main Dictionary)

    • USER, ALL, DBA, and V$ Prefixes in Data Dictionary Views

    • USER_OBJECTS, ALL_OBJECTS, and DBA_OBJECTS Views

    • USER_TABLES, ALL_TABLES, and DBA_TABLES Data Dictionary Views

    • USER_TAB_COLUMNS Data Dictionary View

    • USER_CONSTRAINTS Data Dictionary View

    • USER_CONS_COLUMNS Data Dictionary View

    • USER_VIEWS Data Dictionary View

    • USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views

  • Creating and Using, Working with Sequences in SQL

    • What is a Sequence?

    • 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


BENEFITS OF TAKING THIS SQL COURSE:

Knowing SQL can get you a better job or improve the one you have and it can earn you $100k+ per/year in the IT Industry. 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.


STUDENT REVIEWS PROVE THIS COURSE'S WORTH: 

Those who have reviewed the course have pointed out that the instruction is clear and easy to follow, as well as thorough and highly informative. 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 :-)


IMPORTANT NOTE:

Knowing SQL is "mandatory" for any IT Professional and having good SQL knowledge will be a "GREAT PLUS" for you!

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!

Screenshots

The Complete Oracle SQL Bootcamp (2022) - Screenshot_01The Complete Oracle SQL Bootcamp (2022) - Screenshot_02The Complete Oracle SQL Bootcamp (2022) - Screenshot_03The Complete Oracle SQL Bootcamp (2022) - Screenshot_04

Content

Database Concepts

What is a Database?
Why Oracle Database?
What is a Table?
UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)
Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples)
What is a Relational Database?
Entity Relationship Logic in Databases
What is Pluggable Database?
Introduction to Database Objects
The Sample (HR) Schema Used in This Course
What is SQL?

Introduction and Software Installation

About the Database Installation
Which Option to Have a Database?
Option 1: Having the Database with the Oracle Virtual Box
Option 1: How to Install the Virtual Box on Mac OS X?
Option 2: Downloading And Installing Oracle Database
Option 2: Unlocking the HR Schema
Option 2: Configuring and Using the SQL Developer
Option 3 : Using Oracle Live SQL
Option 3: Warning About Oracle Live SQL Limitations
SQL Statements Used in This Course
The Working Document
Don't Forget to Leave a Rating!
Section 1 : Quiz

Retrieving Data

Oracle Data Types
What is a NULL Value?
DESCRIBE Command
INFORMATION Command
SQL Statement Basics
Oracle Error Messages
Using SELECT Statements
Using Column Aliases
Quote (Q) Operator
DISTINCT and UNIQUE Operator
Concatenation Operators
Arithmetic Expressions and NULL Values
Section 2 : Quiz

Restricting Data

Using WHERE Clause
Comparison Operators
BETWEEN … AND Operator
IN Operator
LIKE Operator
IS NULL Operator
GOOD NEWS FOR YOU!
Logical Operators (AND, OR, NOT)
Rules of Precedence
Quiz
Section 3 : Quiz

Sorting Data

ORDER BY Clause
ASC and DESC Operators
NULLS FIRST and NULLS LAST Operators
Section 4 : Quiz

Single-Row Functions

Single Row Functions
Character Functions (Part 1)
Character Functions (Part 2)
Number Functions
Nesting Functions
Date Operations
Date Functions
Section 5 : Quiz

Conversion Functions

Conversion Functions
TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)
TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)
NVL, NVL2, NULLIF, COALESCE Functions
Section 6 : Quiz

Conditional Expressions

Conditional Expressions (CASE-DECODE)
Section 7 : Quiz

Group Functions

Group Functions
AVG Function
COUNT Function
MAX Function
MIN Function
SUM Function
Overview Of Group Functions
Section 8 : Quiz

Grouping Data

GROUP BY Clause
HAVING Clause
Nesting Group Functions
Section 9 : Quiz

Joining Multiple Tables

Joining Multiple Tables & Types of Joins
Natural Joins
Join with USING Clause
Handling Ambiguous Column Names
Join with ON Clause
Multiple Join Operations
Restricting Joins
Joining Unequal Tables
SELF JOIN
OUTER JOINS
LEFT OUTER JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
CROSS JOIN (Cartesian Product)
Section 10 : Quiz

Using Subqueries

Using Subqueries
Single Row Subqueries
Multiple Row Subqueries
Multiple Column Subqueries
Section 11 : Quiz

Using SET Operators

SET Operators
UNION and UNION ALL Operators
INTERSECT Operator
MINUS Operator
Matching Unmatched Queries in SET Operations
Order By with SET Operators
Section 12 : Quiz

Data Manipulation Language (DML) Statements

Data Manipulation Language (DML)
INSERT Statement (Part 1)
INSERT Statement (Part 2)
UPDATE Statement
DELETE Statement
Transaction Control Statements
COMMIT and ROLLBACK Statements
SAVEPOINT Statement
FOR UPDATE Statement
Section 13 : Quiz

Data Definition Language (DDL) Statements

Data Definition Language (DDL)
Naming Rules
CREATE TABLE Statement
ALTER TABLE Statement
DROP TABLE Statement
TRUNCATE TABLE Statement
COMMENT Statement
RENAME Statement
Section 14 : Quiz

Creating Constraints

Creating Constraints
NOT NULL Constraint
UNIQUE Constraint
PRIMARY KEY Constraint
FOREIGN KEY Constraint
CHECK Constraint
Section 15 : Quiz

Conclusion + Bonus

Conclusion
Bonus: Code Samples
Where to next?
Course Bonuses (SQL Cheatsheet & SQL Certification Exam Samples)

Appendix

Appendix 1: Oracle Database 12c Installation into Your Computer
Appendix 2: How to Unlock the HR Schema in the Oracle Database 12c?
Appendix 3: Configuring and Using Oracle SQL Developer for Oracle Database 12c

Reviews

Srilatha
July 13, 2022
Oracle course is really Awesome. Even beginners can understand and its the best material. The course content is above expectations.
Vikas
July 11, 2022
this is awesome course and i really appretiate the teacher to make the course.this course helps me a lot to learn and this is a best course i have ever seen so, thank you.
Kevin
July 10, 2022
The course went over the material very well and in detail, with multiple illustrative examples. As a native English speaker I had no trouble understanding Mr Omer after the first few lectures, and kept Closed Captioning off for the remainder of the course. It would have been extremely helpful if there had been more exercises at the end of each section, particularly covering edge cases. The instructor alluded to a section on Indexes in future lectures, however after completing the course I realized no such section exists. It's important that section be added, as the Oracle SQL Developer Certification exam touches on this topic in detail. Another topic not covered by the course is the WITH clause. It is simple enough to learn on one's own, however it could have been covered in a short 5-10min lecture. Overall, I enjoyed the course and would take more courses by this instructor again in the future. I will update this review soon after I have taken the certification exam.
Abdul
June 30, 2022
It was a great experience. The Course was very thorough and each and every concept was explained in detail.
Gauri
June 29, 2022
I had been with the organization for a number of years and wanted to experience a new environment to continue growing.
Jerome
June 25, 2022
So far the explanations and visuals are very helpful for understanding what the instructor is talking about.
Kaiwen
June 16, 2022
Overall very decent course. Taking 1 star off due to incomplete PDF. Any PPTs after constraint are not included in that PDF. Also, I have no idea why instructor mentioned trigger in his cheat note but not at all in any lecture.
Francisco
June 15, 2022
The instructor was very clear with the explanations and the examples in the Oracle db were really good
Ayanda
June 13, 2022
Very clear, engaging and very good in establishing the context of why things are done the way they are.
Yuri
June 13, 2022
The instructor is simply the best for Oracle certification training course! He explains all topics so well with practices/examples. Another outstanding point is he explains how database deals with things behind the scenes, which most beginners are not aware of. This course is not only good for exam preparation but also for people who want to learn how database works in general. He also answers questions in timely manners. His sincere approaches to his students let me finish his entire course with ease. I learned so much from this course. Thank you so much!
Sheri
June 11, 2022
I am learning a lot and taking notes, but I wish there were more practice exercises or challenges for me to try what I have learned on my own.
Candela
June 9, 2022
Claramente lo fue, me siento cómoda y me gusta como explica el hombre. Tengo ganas de seguir aprendiendo.
Douglas
June 8, 2022
All the way around, this was an outstanding course. It gave a comprehensive overview of basic Oracle SQL syntax and usage. Looking forward to other classes from The Oracle Masters Team.
BATHULA
May 17, 2022
This was too good, beginners who want to start from basics of SQL this course should be there first choice.
NISAR0402
May 9, 2022
GOOD BUT IT WILL BE USEFUL IF U PROVIDE ANY NOTES FOR EVERY VIDEO TO REVISE THE TOPICS,OTHERWISE IF WE HAVE ANY DOUBT WE HAVE TO WATCH THE COMPLETE VIDEO

Charts

Price

The Complete Oracle SQL Bootcamp (2022) - Price chart

Rating

The Complete Oracle SQL Bootcamp (2022) - Ratings chart

Enrollment distribution

The Complete Oracle SQL Bootcamp (2022) - Distribution chart
549998
udemy ID
7/9/2015
course created date
9/6/2019
course indexed date
Bot
course submited by