Oracle Database - Introduction to SQL from A-Z (عربي)

Description

يحتوي هذا الكورس علي 117 فيديو حوالي 30 ساعة تفصيليه من محاضر محترف بالاضافة لملفات التمارين

هذه الكورس يؤهلك 100% بان تكون محترف قواعد بيانات اوراكل بكل سهولة

هذا الكورس مقدم بطريقة سهلة وسلسه لتبسيط الفهم وتوصيل المعلومة بكل سهوله لك

تم ترتيب الافكار وتنسيقها لتسهيل توصيل المعلومة اليك

هذا الكورس من اقوي الكورسات اللي ممكن تشوفها

سنبدأ من الصفر في قواعد البيانات و حتى الأحتراف

ما ستتعلمه

تعلم اصعب انواع الاسترجاع مع الربط بين الجداول

استرجاع البيانات من قواعد البيانات بكل سهوله

بناء الجداول و الفيوز و الاندكسيز و السينونم

الاضافه و التعديل و الحذف من الجداول

محتوى المقرر الدراسي

عباره عن 25 قسم

مشتملين علي 117 محاضرة

وقت الكورس

28 h : 42 m

سنبدأ الاول بنتنزيل الادوات المطلوبة وتنصيب الداتابيز علي الجهاز

ومن ثم سنقوم بشرح التالي

Introduction about Oracle

       - System development life cycle

       - What is Data ?

       - What is Database ?

       - What is DBMS ?

       - What is RDBMS ?

       - What is ORDBMS ?

       - What is table ?

       - What is Data Model and ERM ?

       - What is SQL ?

       - What is SQL*PLUS / Oracle SQL Developer ?

       - Types of is SQL statements

       - HR Schema tables

History and Architecture12C

Oracle 12c Architecture

Comparison between 12c and previous Releases

Basic select

Restricting and Sorting

       - Using where clause

       - Comparison operators

       - Using between and

       - Using In operator

       - Using like operator

       - Using in null operator

       - Logical operator [ AND , OR , NOT ]

       - Order by clause

Using conversion functions

       - Implicit and explicit conversion

       - to_char

       - to_number

       - to_date

       - General function ( NVL , NVL2 , NULLIF , COALESCE )

       - Case function

       - Decode function

Substitution Variables

Character Function

Number Function

Date Function

Using the group functions

       - Multi row function

       - Types of group function

       - Group by clause

       - Guideline for using group by

What is joins and cartesian products

Types of Joins

Join in oracle DB 8i and prior

SQL 1999 joins

Oracle DB 8i and prior join syntax

       - Equijoin

       - Non Equijoin

       - Outer join

       - Self join

SQL 1999 joins

       - Cross join

       - Natural join

       - Using clause

       - On clause

       - Left outer join , right outer join , full outer join

Using Subqueries to Solve Queries

- Rules for using Subquery

- Types of Subquery

- Single Row Subquery

- Multiple Row Subquery

- Using Group function in Subquery

- Having clause in Subquery

- Single Subquery Operators

- Multiple Row Subquery Operators

- Not in and Subquery

- Exists and Not Exists

Using the Set Operators

       - Union operator

       - Guidelines when using the Union

       - Union All operator

       - Guidelines when using the Union All

       - Intersect operator

       - Guidelines when using Intersect

       - Minus operator

       - Guidelines when using Minus

       - Using the order by clause in set operators

What is DML and insert rules

Insert statement

Insert Rows with null values

Copy Rows from another tables

Common errors insert and creating script

Update statement

Using Subquery in update

Delete statement

Truncate statement

Compare between delete and truncate

Commit and Rollback

Save point

Read consistency

DB objects and data types

-What is Schema ? and create table syntax

-Default option

Including constraints [ PK , FK , UK , NOT NULL , CHECK]

Constraint guidelines

Creating table using Subquery

Alter table statement [ Add, Modify , Drop ]

Set unused option - read only - drop table

Create Char datatype without size

Null values and order by clause

Order by clause Tips

Interval functions

Many function do the same task

Long data type

Some SQL function

Best practice DDL

Alter table and constraints

Tips you should know

What is the Data Dictionary ?

Data Dictionary Structure

Naming Conversion in Data Dictionary Views

Data Dictionary Views

       - User_objects / All_objects

       - User_tables / All_tables

       - User_tab_columns

       - User_constrains

       - User_cons_columns

Adding Comments to a a table

Adding Comments to a column

Comments Dictionary Views

Creating Sequences

NextVAl and CURRVAl

Using the Sequence as Default value in Create Table

Modify the Sequence

Creating Synonyms

Creating Indexes

Dictionary Views for [Sequence , Synonyms , Indexes]

What is a view ?

Advantage of views

Creating views

Create simple view

Create complex view

Roles for performing DML operations on a view

With check option clause

With read only clause

Removing a view

How add constraints to the tables

Rename the column name in the table

Rename constraint name

DEFERRABLE Constraints

       - DEFERRABLE INITIALLY deferred

       - DEFERRABLE INITIALLY immediate

Global temporary table

SQL Loader

Retrieving Data by using Subqueries

      - Create External Tables

      - Using Subquery as a source table

      - Multiple column Subquery

      - Pairwise comparison Subquery

      - Non – Pairwise comparison Subquery

      - Scalar Subquery

      - Correlated Subquery

      - With Clause

Manipulating Data by Using Subqueries

      - Inserting by using a Subquery as a target

      - Updating by using Subquery as a target

      - Correlated update

      - Correlated delete

Controlling User Access

     - Database Security

     - Data Security

     - System Privileges

     - Objects Privileges

     - Creating a user

     - Grant System Privileges

     - What is a Role ?

     - Creating a Role

     - Granting Objects Privileges

     - Related Dictionary views

     - Revoke Statement

Introduction to Manipulating Data

Using the explicit default value in insert statement

Using the explicit default value in update statement

Copy rows from another table examples

Using the following types of multi table insert

     - Unconditional Insert

     - Conditional Insert All

     - Conditional Insert First

     - Pivoting Insert

Manipulating Data Merge Statement

Manipulating Data Flashback Statement

Managing Data in Different Time Zones

     - Time Zones

     - Timestamp Data type

     - Timestamp with time zone

     - Timestamp with local time zone

     - V$TIMEZONE_NAMES

     - DBTIMEZONE

     - SESSIONTIMEZONE

     - current_date function

     - current_timestamp function

     - localtimestamp

     - alter session set time_zone

     - Extract expression

     - TZ_OFFSET function

     - from_tz function

     - to_timestamp function

     - to_yminterval function

     - to_dsinterval function

ستجد الملفات اسفل كل فيديو

TAKE THIS COURSE