Oracle SQL : Become a Certified SQL Developer From Scratch!

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.

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.

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;

1. CHAR
2. VARCHAR2
3. NUMBER
4. DATE
5. LONG
6. RAW
7. LONG RAW
8. BLOB
9. CLOB
10. BFILE
11. ROWID.

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.

This lesson covers Oracle SQL Statement Basics.

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 Concatenation ( || ) Operator.

This lesson covers Oracle SQL Arithmetic Operations like;

• Add
• Substract
• Multiply
• Divide

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 lesson we're going to learn Comparison Operators( <, >, < = , >=, <>) in Oracle Database.

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 lesson we're going to learn IS NULL Operator in Oracle Database.

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

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

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.

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.

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

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.

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.

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

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.

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.

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.

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.

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.

In this SQL tutorial, the participants will learn Nested Functions which can be placed within other Oracle functions, extending their capability in the Oracle Database.

Lecture keywords: oracle nested functions, nesting functions in Oracle SQL, nested functions in SQL.

In SQL tutorial, we are going to introduce Oracle Date Data Types which are; 

• Date Data Type,

• Timestamp Data Type

• Timestamp with Time Zone Data Type

• Timestamp with Local Time Zone data types.

And you will also see the Oracle Date Format Models in SQL.

In this SQL tutorial, students are going to learn the most commonly used Oracle SQL Date Functions such as sysdate, current_date, systimestamp, current_timestamp, etc. in the Oracle Database.

And they will also learn how to make arithmetic operations on date values.

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

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

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

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.

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.

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.

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

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

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.

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

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

In this SQL tutorial, students are going to learn Oracle Group Functions in other words Oracle aggregate functions work and how to apply them to calculate aggregates.

In this SQL tutorial, you will learn how to use the Oracle AVG() function and we will show you how to apply it to calculate average of values in various contexts.

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

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

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

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

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

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

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