Oracle Database - Introduction to SQL from A-Z (عربي)
Learn Oracle SQL from scratch to expert level! This Arabic course covers database fundamentals and advanced techniques. Master Oracle database skills.
Course Content
Oracle Database - Introduction to SQL from A-Z (عربي) is an all-levels Udemy course taught by Amr Sobhi. It runs 29h 1m, is taught in Arabic, and includes a certificate of completion. Learners rate it 4.0 out of 5 from 7 reviews, with 34 students enrolled. It is a paid course, last updated April 2022.
Master Oracle Databases: A Comprehensive 30-Hour Training
Unlock your potential as an Oracle database expert with this in-depth, 30-hour course! Featuring 117 detailed video lectures from a seasoned professional, this course provides a clear, step-by-step path to mastering Oracle database fundamentals and advanced techniques. You'll receive practical exercises to solidify your understanding and gain 100% proficiency.
What You'll Learn:
This comprehensive curriculum is structured into 25 sections, covering everything from the basics to advanced database management. We start with a solid foundation and progress to real-world applications.
Oracle Fundamentals & Architecture:
- Introduction to Oracle Database Systems
- System Development Life Cycle (SDLC)
- Understanding Data, Databases, and DBMS
- Exploring RDBMS and ORDBMS Concepts
- Database Object: Tables, Data Models, and ERM
- Introduction to SQL and SQL*Plus / Oracle SQL Developer
- SQL Statement Types
- Oracle 12c Architecture: A detailed comparison with previous releases.
Data Manipulation Language (DML):
- Data Retrieval: Mastering
SELECTstatements, including:WHEREclause, Comparison Operators,BETWEEN,IN,LIKE,NULLoperators, Logical Operators (AND,OR,NOT)ORDER BYclause- Conversion Functions:
TO_CHAR,TO_NUMBER,TO_DATE,NVL,NVL2,NULLIF,COALESCE,CASE,DECODE - Substitution Variables, Character, Number, and Date Functions
- Group Functions: Multi-row functions,
GROUP BYclause, Guidelines for usingGROUP BY
- Joins & Set Operations:
- Understanding Joins and Cartesian Products
- Types of Joins: Equijoin, Non-Equijoin, Outer Joins, Self Joins, Cross Joins, Natural Joins
- Using
USINGclause,ONclause, Left/Right/Full Outer Joins - Subqueries for complex queries
- Set Operators:
UNION,UNION ALL,INTERSECT,MINUS - Using set operators with
ORDER BY
- Data Modification:
INSERTStatement: Inserting rows with NULL values, copying rows from other tables, common errorsUPDATEStatement: Using subqueries inUPDATEstatementsDELETEStatement: ComparingDELETEandTRUNCATETRUNCATEStatementCOMMITandROLLBACK- Savepoints
- Data Retrieval: Mastering
-
- Database Objects and Data Types
- Understanding Schemas and
CREATE TABLESyntax - Default Options, Constraints (
PK,FK,UK,NOT NULL,CHECK) - Constraint Guidelines
ALTER TABLEStatement: Adding, Modifying, Dropping columns- Setting Unused Options, Read-Only Mode, Dropping Tables
- Character Datatypes and Size Considerations
- Null Values and
ORDER BYClause - Interval Functions
- SQL Function Best Practices
- DDL (Data Definition Language) and Constraint Tips
- The Data Dictionary: Structure, Naming Conventions, Conversion, Views (
User_objects,All_objects,User_tables,All_tables,User_tab_columns,User_constrains) - Adding Comments to Tables and Columns
- Comments Dictionary Views
- Creating Sequences:
NEXTVAL,CURRVAL, Using Sequences as Default Values - Creating Synonyms
- Creating Indexes
- Dictionary Views for Sequences, Synonyms, and Indexes
- Understanding Views: Advantages, Creating Simple and Complex Views, Roles for DML Operations on Views
- Removing Views
- Adding and Renaming Constraints and Columns
- Deferrable Constraints
- Global Temporary Tables
- SQL Loader
Advanced Techniques:
- Retrieving Data with Subqueries: Creating External Tables, Multiple Column Subqueries, Pairwise/Non-Pairwise Subqueries, Scalar/Correlated Subqueries,
WITHClause - Manipulating Data with Subqueries: Inserting, Updating, Correlated Updates/Deletes
- Controlling User Access & Security: Database Security,
- Retrieving Data with Subqueries: Creating External Tables, Multiple Column Subqueries, Pairwise/Non-Pairwise Subqueries, Scalar/Correlated Subqueries,
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.