Oracle Database 12c Introduction to SQL/ بالعربي

Installing oracle 12c on windows

What is TNSNAMES.ORA? 

Making the First connection by SYS user on the container DB.

Steps to unlock the HR account.

Make the second connection by User HR on the pluggable database 

•Capabilities of SQL SELECT statement.
•Basic SELECT Statement.
•Selecting ALL columns.
•Selecting Specific Columns.
•Columns Heading Default.
•Arithmetic Expressions.
•Null Values.
•Defining Column Alias.
•Literal Character String.
•Using Distinct.
•Display Table Structure.
•And many other info.

this is the second part of retrieving data using the SELECT 

Using WHERE clause.

Character string and Dates.

Comparison operators.

Using Between and

using the IN operator 

like and not like 

logical operators ( and , or , not )

more examples about logical operators.

order by clause

more examples about the order by clause.

fetch statement

•What is the substitution variables.
•Where we can use the substitution variables.
•Use the DEFINE command to create and assign a value to a variable.
•Use the UNDEFINE command to remove a variable.
•Using the Double-Ampersand Substitution Variable.
•Use the VERIFY command to toggle the display of the substitution variable.
•using set define off/on.
•And many other info.

more examples about substitution variables 

character functions part 1

character functions part 2

number functions in oracle with many examples and practices

date functions in oracle with many examples and practices ( part 1)

date functions in oracle with many examples and practices  part 2

•Conversion Functions.
•Implicit and explicit conversions.
•TO_CHAR.
•TO_NUMBER.
•TO_DATE.
•General Functions ( NVL, NVL2, NULLIF,COALESCE)
•Case Function.
•Decode function.
•And many other info.

continue part 2 

continue part 3

continue part 4

continue part 5

•Multi Row Functions.
•What are the Group functions?
•Types of Group Functions.
•Group By clause.
•Guidelines for using Group By.
•And many other info.

continue for the group functions and more examples 

what is join and what is Cartesian Products ?

Types of Joins.

old joins and 1999 syntax

what is Equijoin?

what is Nonequijoin?

Outer Join

left outer join and right outer join

what is self join in oracle ?

syntax 1999 join

comparison between old join new join 1999

practice 1

here will make comparison between the old join and the new join

practice 2

here will make comparison between the old join and the new join