Oracle SQL : Become a Certified SQL Developer From Scratch!
4.5 (3,825 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
18,440 students enrolled

Oracle SQL : Become a Certified SQL Developer From Scratch!

Become an In-demand SQL Professional! Get ready to pass Oracle SQL 1Z0-071 (OCA) Certification Exam on your first try!
Bestseller
4.5 (3,825 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
18,429 students enrolled
Last updated 5/2020
English
English [Auto-generated], Italian [Auto-generated], 1 more
  • Polish [Auto-generated]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 17 hours on-demand video
  • 9 articles
  • 15 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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!
Course content
Expand all 133 lectures 17:22:12
+ Database Concepts
11 lectures 01:04:32

In this lecture, our students going to learn what a database is and why we need to use the databases.

Preview 07:37
Why Oracle Database?
07:00

In this lecture, our students going to learn what a table is and why we need to use the tables.

Preview 03:38

This lecture is about how to use the Udemy platform. And also includes some useful tips to get most of out the course.

UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)
05:01
Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples)
00:34
What is a Relational Database (RDBMS)?
07:52
Entity Relationship Logic in Databases
03:46

In this lecture, you're going to learn what the pluggable database (multitenant architecture) is in Oracle Database.

What is Pluggable Database?
03:13
Introduction to Database Objects
13:26
The Sample (HR) Schema Used in This Course
07:23

==========================================================

                                         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".

Section 1 : Quiz
10 questions
+ Software Download & Installation
12 lectures 01:32:48
Which Option to Have a Database?
09:18

This lecture shows how to get Oracle database without installing, downloading and much more efforts.

We've prepared a virtual machine that contains a completely running Oracle database in it for you.

So you don't need to install Oracle database at all.

All you have to do is just to install the Oracle Virtual Box image.

Then, you'll get your database easily.

Option 1: Having the Database with the Oracle Virtual Box
16:29
Option 1: How to Install the Virtual Box on Mac OS X?
01:41

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".

Preview 18:18

In this lecture, our students are going to learn how to unlock the HR schema to practice throughout the course.

Option 2: Unlocking the HR Schema
07:34

This lecture covers how to download and configure Oracle SQL Developer software and how to connect to the Oracle Database 19c.

Option 2: Configuring and Using the SQL Developer
22:14
Option 3 : Using Oracle Live SQL
07:40
Option 3: Warning About Oracle Live SQL Limitations
00:33

Introduces which SQL statements we are going to use in this course. (Oracle's specific SQL details are in next lessons.)

SQL Statements Used in This Course
05:29
The Working Document
00:16

This lecture introduces shows how much we appriciate your thoughts.

Don't Forget to Leave a Rating!
00:13
+ Retrieving Data
12 lectures 01:33:21

In this lesson, we're going to talk about Oracle Data Types which are;

  1. CHAR
  2. VARCHAR2
  3. NUMBER
  4. DATE
  5. LONG
  6. RAW
  7. LONG RAW
  8. BLOB
  9. CLOB
  10. BFILE
  11. ROWID.
Oracle Data Types
06:54

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.

What is a NULL Value?
05:10

This lesson includes Oracle DESC or DESCRIBE Command.

DESCRIBE Command
04:25

This lesson teaches how to see a better description and some statistics of a table using the INFO[RMATION] and INFO[RMATION]+ Commands.

INFORMATION Command
08:13

This lesson covers Oracle SQL Statement Basics.

SQL Statement Basics
13:56

This lecture explains how to read the Oracle (ORA) error messages and how to take an action to solve your code problems

Oracle Error Messages
06:51

This lesson covers Oracle SELECT Statements.

Using SELECT Statements
06:00

This lesson covers Oracle Column Aliases.

Using Column Aliases
07:26

This lesson covers Oracle Quote (q) Operator.

Quote (Q) Operator
08:53

This lesson covers the Oracle Distinct (DISTINCT) and UNIQUE operators.

Preview 07:42

This lesson covers Concatenation ( || ) Operator.

Concatenation Operators
07:46

This lesson covers Oracle SQL Arithmetic Operations like;

  • Add
  • Substract
  • Multiply
  • Divide

and covers NULL values.

Arithmetic Expressions and NULL Values
10:05

You can test your sql skills with our quizzes. 

Keywords: "SQL", "sql programming", "quiz", "sql quiz".

Section 2 : Quiz
4 questions
+ Restricting Data
9 lectures 01:09:58

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.

Using WHERE Clause
04:41

In this lesson we're going to learn Comparison Operators( <, >, < = , >=, <>) in Oracle Database.

Comparison Operators
06:33

In this lesson we're going to learn BETWEEN ... AND Operator in Oracle Database.

BETWEEN … AND Operator
05:48

In this lesson we're going to learn IN Operator in Oracle Database.

IN Operator
11:10

In this lesson we're going to learn LIKE Operator in Oracle Database.

LIKE Operator
11:21

In this lesson we're going to learn IS NULL Operator in Oracle Database.

IS NULL Operator
05:21

In this lesson, students are going to learn Oracle Logical Operators which are;

  1. AND Logical Operator

  2. OR Logical Operator

  3. NOT Logical Operator

Logical Operators (AND, OR, NOT)
14:23

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

Rules of Precedence
10:41
Oracle SQL Quiz about Section 2 : Retrieving Data with using SQL.
Preview 12 pages

========================================================

                                              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".

Section 3 : Quiz
10 questions
+ Sorting Data
5 lectures 55:21

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.

ORDER BY Clause
15:12

This lesson covers the ASC (Ascending) and DESC (Descending) operators in SQL and how to use them in the Oracle Database.

ASC and DESC Operators
09:55

In this lesson, students are going to learn the NULLS FIRST and NULLS LAST Operators in the Oracle Database.

NULLS FIRST and NULLS LAST Operators
04:24

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

ROWNUM & ROWID in SQL
12:48

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.

Oracle FETCH Clause
13:02

========================================================

                                                 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".

Section 4 : Quiz
5 questions
+ Using Substitution Variables
4 lectures 51:06

In this SQL tutorial, students are going to learn a brand new section called "Substitution Variables".

This lecture covers "What a Substitution Variable is" in Oracle and how to use Substitution Variables in SQL Queries with various examples.


What is a Substitution Variable?
15:50

In this SQL tutorial, participants are going to learn how to use double ampersand (&&) characters as substitution variables in SQL. And also they will learn the DEFINE and UNDEFINE commands to define and undefine substitution variables explicitly.

Double Ampersand (&&) and DEFINE & UNDEFINE Commands
18:52

In this SQL tutorial, students are going to learn how to use ACCEPT and PROMPT commands with substitution variables in SQL.

ACCEPT and PROMPT Commands
08:17

In this SQL tutorial, our expert SQL instructors are going to demonstrate how to use SET VERIFY ON and SET VERIFY OFF commands to turn off or turn on substitution operations while performing special operations like the data warehouse operations, data migration, etc.

SET VERIFY ON / SET VERIFY OFF Commands
08:07
+ Single-Row Functions
11 lectures 02:17:52

In this lesson, students are going to learn what the function is in the programming context and in Oracle Database.

They will also learn function types in Oracle which are Single-Row Functions and Multiple-Row functions (also called Group Functions).

This lecture is just an overview of Single-row functions in Oracle Database.

In the upcoming lectures, students will see all the subtypes of single-row function in Oracle one by one in detail.

Single Row Functions
12:33

In this SQL tutorial, students are going to learn Case Conversion Functions which are the subtype of the Character Functions in Oracle Database.

And we will cover Case conversion functions below;

  1. LOWER function 

  2. UPPER function 

  3. INITCAP function

Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios
15:12

In this SQL tutorial, students are going to learn the Oracle Character Manipulation Functions which are the subtype of Oracle String Functions.

Character Manipulation Function in Oracle has 8 functions which are;

  1. SUBSTR function

  2. LENGTH function

  3. CONCAT function

  4. INSTR function

  5. TRIM function

  6. REPLACE function

  7. LPAD function

  8. RPAD function.

In this SQL lesson, students are going to learn; 

  • How to use the Oracle SUBSTR() function to extract a substring from a string,

  • How to use the Oracle LENGTH() function that returns the number of characters of a specified string,

  • And lastly, they will also see the Oracle CONCAT function that concatenates two strings and returns the combined string.

Character Functions - Character Manipulation Functios (Part 1)
14:27

In this SQL tutorial, students are going to learn the Oracle INSTR() function that searches for a substring in a string and returns the position of the substring in a string.

Character Functions - Character Manipulation Functions Part 2 (INSTR Function)
11:06

In this SQL Character Functions lecture series, we are going to continue to learn Character Manipulation Functions in SQL.

This SQL tutorial covers;

  1. TRIM function

  2. LTRIM function

  3. RTRIM function and their example usages.

Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)
20:15

In this SQL Character Functions lecture series, we are going to continue to learn the last part of the Character Manipulation Functions in SQL.

This SQL tutorial covers;

  1. REPLACE function

  2. LPAD function

  3. RPAD function and their example usages.

Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)
11:37

In this SQL tutorial, students are going to learn SQL Numeric Functions in other words, SQL Number Functions in the Oracle Database.

The numeric functions we covered in this lecture are; 

  • Round Function

  • Trunc Function

  • Ceil Function

  • Floor Function

  • Mod Function

Also, the participants will learn how to use other numeric functions in their SQL statements.

Numeric Functions
16:32
GOOD NEWS FOR YOU!
00:32

In this lesson we're going to learn Nesting Functions in Oracle Database.

Nested Functions
07:59

In this lesson we're going to learn Date Operations in Oracle Database.

Date Operations
19:51
In this lesson we're going to learn Date Functions in Oracle Database.
Date Functions
07:48

========================================================

                                         Section:  Single-Row Functions Quiz

========================================================

You can evaluate your SQL knowledge and skills with our quizzes.

Related Keywords: "SQL", "SQL programming", "SQL quiz", "Single-row functions quiz".

Section 5 : Quiz
5 questions
+ Conversion Functions
4 lectures 45:32

In this lesson we're going to learn Conversion Functions in Oracle Database.

It contains;

  1. Implicit Data Type Conversion
  2. Explicit Data Type Conversion

  1. TO_CHAR Function
  2. TO_DATE Function
  3. TO_NUMBER Funtion

Conversion Functions
07:06

In this lesson we're going to learn

  1. TO_CHAR Function in Oracle
  2. TO_DATE Function in Oracle
  3. TO_NUMBER Function in Oracle.
TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)
13:37

In this lesson we're going to learn

  1. TO_CHAR Function in Oracle
  2. TO_DATE Function in Oracle
  3. TO_NUMBER Function in Oracle.
TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)
12:29

In this lesson we're going to learn

  1. NVL Function in Oracle
  2. NVL2 Function in Oracle
  3. NULLIF Function in Oracle
  4. COALESCE Function in Oracle.
Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions
12:20

========================================================

                                    Section:  SQL Conversion Functions Quiz

========================================================

You can evaluate your SQL knowledge and skills with our quizzes.

Related Keywords: "SQL", "SQL programming", "SQL quiz", "Conversion functions quiz".

Section 6 : Quiz
6 questions
+ Conditional Expressions
1 lecture 17:38

In this lesson we will mention about these topics below;

  1. IF...THEN...ELSE Expressions in Oracle Database.
  2. CASE Expression in Oracle Database.
  3. DECODE Expressions in Oracle Database.
Conditional Expressions (CASE-DECODE)
17:38

=========================================================

                                       Section: Conditional Expressions Quiz

=========================================================

You can evaluate your SQL knowledge and skills with our quizzes.

Related Keywords: "SQL", "SQL programming", "SQL quiz", "Conditional expressions quiz".

Section 7 : Quiz
5 questions
+ Group Functions
7 lectures 28:55

In this lesson we are going to learn Oracle Group Functions

Group Functions
04:28

In this lesson we are going to learn AVG Function in Oracle Database.

AVG Function
04:36

In this lesson we are going to learn COUNT Function in Oracle Database.

COUNT Function
05:06

In this lesson we are going to learn MAX Function in Oracle Database.

MAX Function
04:04

In this lesson we are going to learn MIN Function in Oracle Database.

MIN Function
04:33

In this lesson we are going to learn SUM Function in Oracle Database.

SUM Function
03:09

In this lesson we will look at overview of Oracle Group Functions.

Overview Of Group Functions
02:59

=========================================================

                                         Section:  Group Functions Quiz

=========================================================

You can evaluate your SQL knowledge and skills with our quizzes.

Related Keywords: "SQL", "SQL programming", "SQL quiz", "Group functions quiz".

Section 8 : Quiz
5 questions
Requirements
  • Nothing more than a working computer; all PC, Mac or Linux, etc. users are all welcome.
  • No previous programming experience is required!
  • No paid tools are required!
Description

Course Updates: (May, 2020)

  • 3 Real SQL Certification Exam Samples are added!

  • Many brand new lectures are added!

This course is not just easily explained, but also prepared in a professional way with all the details and so many examples. You are in the right place to make you a job-ready SQL Developer.

If you get this course, please try to write and run all the examples with me. If you follow what I said in this course, "You will become a certified SQL Developer just in 7 weeks."

  • You can ask any questions about this course from the discussion board.

  • Your questions will be answered immediately.

=============================================================

Are you a student to learn SQL for your lessons?

Do you want to get a better job?

Are you bored in watching a lot of stuff but could not learn anything?

Do you think you know SQL, but can not write code?

Are you looking for a really professional course?

Then this is the course you are looking for.

In this course, all the subjects are explained with a professional order.

   If you are new in sql, you can learn easily with all the details. If you already know sql and want to improve it, this course explains all the details of including subjects.

   After finishing this course, you will learn what you need to learn at all. If you don't see anything in this course, that means you really don't need to know it for now.

   Coding can be learned with coding. A course which has no example is not a course at all. And there are hundreds and hundreds of codes in this course.

And something more. Are you not good at English? No problem.

All of our videos are supported with "English Subtitle".

So come on, what are you waiting for?

Get this course, and go get a better job!

Benefits of Taking This SQL Course:

Knowing SQL can get you a better job or improve the one you have and it provides to earn you $80-100k+ 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, that's 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 how to write SQL codes easily and thinking 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 :-)


No Risk – Money-Back Guarantee:

Finally, there is no risk. You can preview 10% of the course for free. Once you purchase the course, if for some reason  you are not happy with the course, Udemy offers a 30-day money back guarantee.

So you have nothing to lose, sign up for this course and learn how to write SQL code easily from scratch to master level!

Who this course is for:
  • Anyone willing to step into the software development career!
  • Anyone dreaming to get a well-paid SQL Development Job!
  • Anyone planning to Pass the Oracle 1Z0-071 (OCA) exam!
  • Anyone who wants to Become an in-demand SQL Professional!