Oracle administration and development in Arabic (Free)

Name: Oracle administration and development in Arabic (Free)
Rating: 4.6 (297 reviews)

Oracle administration, Oracle SQL (Views, functions and complex queries), Oracle PL/SQL

Created byMohamed Reda Al-bana

Last updated 11/2017

Arabic

What you'll learn

Oracle Adminstration
how to build complex queries
How to deal with database objects(views, procedures, functions, triggers, ...)
How to build sub programs using PL/SQL

Course content

12 sections • 74 lectures • 5h 37m total length

1-Types of users in Oracle4:08
2-Types of Oracle Clients5:38
3-How to connect to SQL*PLUS5:30
4-How to Create user using SQL*PLUS4:23

5-what are User Privileges3:38
6-What is a Schema2:42
7-Create Table using SQL*PLUS9:28
8-How to grant Object privileges to specific user7:17
9-REVOKE Object Privilege From a user2:40
10-Revoke system Privilege from a specific user2:17
11-How to Lock and Expire account3:37
12-Know Oracle Users and User Tables6:08
13(1)-How can I know my System or Object Privileges4:07
13(2)-How to grant or revoke all System or Object Privileges6:51
15-How can a regular user to grant Object Privileges4:34
16-How can a regular user to grant System Privileges3:12
17-How Can HR and SYS USERS select any Table Data3:59
18-How To Drop USER3:15

1- Can HR grants select on specific columns to Ramy4:09
2-What and Why Views4:37
3-Types Of Views and View Creation3:59
4-How To Create a simple view4:06
5-Replace existing View1:25
6-Can we do DML operation on views4:42
7-With Check option constraint in views3:20
8-With Read Only constraint in views2:10
9-What is the use of Force Keyword in views2:47
10-Complex Views Example3:36
11 - Drop Simple or Complex views1:48
12-Complex Query Examle 1 with Views11:12
13-Complex Query Example 2 with views10:14

Requirements

you should be able to use SQL (DML, DDL)
you should have basic background in programming
Download and install oracle 11g r2 EX
Download and Install JDK
Download Oracle SQL Developer

Description

Oracle administration: from How to create user then grants and revoks then how to create Roles with Examples. Oracle development: from how to create a simple PL/SQL block to how to make a not bad programs using PL/SQL. How to use SQL with PL/SQL with Administration. How to deal with complex queries and examples.

Who this course is for:

Anyone interested in databases
Anyone interested in Oracle

Oracle administration and development in Arabic (Free)

What you'll learn

Explore related topics

Course content

Introduction to Oracle Administration4 lectures • 20min

Oracle Administration User privileges14 lectures • 1hr 4min

Oracle Administration with Oracle SQL Developer4 lectures • 18min

Oracle Administration User Roles3 lectures • 13min

Oracle SQL Views13 lectures • 58min

Oracle SQL functions7 lectures • 41min

Introduction to Oracle PL/SQL4 lectures • 11min

Oracle PL/SQL Variables5 lectures • 14min

Oracle PL/SQL Functions9 lectures • 49min

Oracle PL/SQL Procedure5 lectures • 20min

Requirements

Description

Who this course is for: