Oracle Database 12c Introduction to SQL/ بالعربي
4.9 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
48 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle Database 12c Introduction to SQL/ بالعربي to your Wishlist.

Add to Wishlist

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

مقدمة في قواعد البيانات اوراكل اس كيو ال..الدوره التي تؤهلك لاجتياز امتحان 061 و 071 بكل سهوله ..انها الدورة الاقوى
4.9 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
48 students enrolled
Created by Khaled Alkhudari
Last updated 11/2016
English
Curiosity Sale
Current price: $10 Original price: $150 Discount: 93% off
30-Day Money-Back Guarantee
Includes:
  • 30 hours on-demand video
  • 63 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • استرجاع البيانات من قواعد البيانات بكل سهوله
  • تعلم اصعب انواع الاسترجاع مع الربط بين الجداول و التجميعات
  • الاضافه و التعديل و الحذف من الجداول
  • بناء الجداول و الفيوز و الاندكس و السينونم
  • ستكون محترف في كل معنى الكلمه
  • ستجناز الامتحان من اوراكل
View Curriculum
Requirements
  • هذه الدوره لا تحتاج اي متطلب سابق فهي تبدا من الصفر و حتى الاحتراف
  • جهاز كمبيوتر او لابتوب عليه وندوز 64 بت
  • الدوره تؤهلك لأجتياز امتحانين من الاوراكل مئه في المئه
  • ابقاء المحتوى بالانجليزي و الشرح عربي
Description

تحتوي هذه الدورة أكثر من 125 درس و أكثر من 30 ساعة من الفيديوهات التفصيليه من محاضر محترف بالاضافه للشروحات و ملفات التمارين و حل لأسئلة امتحان 061 كاملا مع الشرح التفصيلي للأمتحان

هذه الدوره تغطي اكثر بكثير من منهاج الاوراكل ينوفيرستي و تؤهلك 100% بان تكون محترف وان تجتاز امتحان 061 و 071 بكل سهولة

ستوفر عليك هذه الدوره مجهود شهور من الدراسه المنفرده...طريقك للاحتراف في هذه الدوره الأقوى على مستوى الوطن العربي و ربما العالم.

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

Who is the target audience?
  • الاشخاص المهتمين في قواعد البيانات اوراكل
  • طلاب الجامعات في تخصصات علوم الحاسوب و تكنولوجيا المعلومات
  • الاشخاص الذبن يردون البدأ قي البرمجه و يجب ان تعرف ان كل المبرمجين يجب ان يكون لديهم معلومات عن قواعد البيانات
  • المبرمجين الذين ليس لديهم الخبره في اوراكل 12 و يريدون مراجعه معلوماتهم
  • الذين يردون النجاح في امتحان الاوراكل
Students Who Viewed This Course Also Viewed
Curriculum For This Course
125 Lectures
29:47:43
+
Introduction
3 Lectures 46:22
  • System development life cycle and many other things like:
  • What is Data? 
  • What is DBMS?
  • What is RDBMS?
  • what is ERM
Preview 14:11

what is the PK?

what is the FK?

types of SQL statements and many.

HR tables that will be used in training

Introduction part 2
16:26

Oracle history.

oracle 12c architecture.

comparison between oracle 12c and prior

oracle history and 12 c
15:45
+
Installing oracle 12c on windows
1 Lecture 18:25

Installing oracle 12c on windows

Installing oracle 12c on windows
18:25
+
First connection and unlock HR account
2 Lectures 30:51

What is TNSNAMES.ORA? 

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

Preview 15:06

Steps to unlock the HR account.

Make the second connection by User HR on the pluggable database 

First connection and unlock HR account 2
15:45
+
Retrieving data using the select statement
2 Lectures 36:23

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

Retrieving data using the select statement 1
19:58

this is the second part of retrieving data using the SELECT 

Retrieving data using the select statement 2
16:25
+
Restricting and Sorting Data
4 Lectures 01:10:24

Using WHERE clause.

Character string and Dates.

Comparison operators.

Using Between and

Restricting and Sorting Data 1
15:12

using the IN operator 

like and not like 

logical operators ( and , or , not )

Preview 19:42

more examples about logical operators.

order by clause

Restricting and Sorting Data 3
17:17

more examples about the order by clause.

fetch statement

Restricting and Sorting Data 4
18:13
+
substitution variables
2 Lectures 23:26

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

Preview 08:26

more examples about substitution variables 

substitution variables part 2
15:00
+
Using Single-Row Functions to Customize Output
5 Lectures 01:19:22

character functions part 1

1-character functions part 1
17:40

character functions part 2

1-character functions part 2
18:41

number functions in oracle with many examples and practices

2-number functions
15:39

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

3-date functions part 1
11:30

date functions in oracle with many examples and practices  part 2


3-date functions part 2
15:52
+
Using Conversion Functions and Conditional Expressions
5 Lectures 01:15:05

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

Using Conversion Functions &Conditional Expressions 1
14:08

continue part 2 

Using Conversion Functions &Conditional Expressions 2
10:56

continue part 3

Using Conversion Functions &Conditional Expressions 3
19:57

continue part 4

Using Conversion Functions &Conditional Expressions 4
14:16

continue part 5

Using Conversion Functions &Conditional Expressions 5
15:48
+
Reporting Aggregated Data Using the Group Functions
2 Lectures 36:34

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

Preview 19:06

continue for the group functions and more examples 

Reporting Aggregated Data Using the Group Functions 2
17:28
+
Displaying Data from multiple tables using joins
9 Lectures 01:58:12

what is join and what is Cartesian Products ?

1- what is join and what is Cartesian Products ?
10:51

Types of Joins.

old joins and 1999 syntax

2- Types of Joins
05:06

what is Equijoin?

3- what is Equijoin?
16:18

what is Nonequijoin?

4-what is Nonequijoin?
11:13

Outer Join

left outer join and right outer join

5- Outer Join
11:28

what is self join in oracle ?

6- Self Join
15:59

syntax 1999 join

comparison between old join new join 1999

7- syntax 1999 join
19:51

practice 1

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

8- practice part 1
19:26

practice 2

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

9- practice part 2
08:00
15 More Sections
About the Instructor
Khaled Alkhudari
4.7 Average rating
63 Reviews
339 Students
4 Courses
Sr Oracle Developer/ Sr system analyst with 12 years....exp.

My name is Khaled Al Khudari, I graduated in 2003 in computer science.

I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat  and many others )

I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others )

I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft  and desire to learn .

I believe in success through hard work & dedication.

My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’.