Udemyallar

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.

4.0(7)
34students
29h 1m
Certificate
Amr Sobhi
Amr SobhiSenior Java & Middleware Engineer[ADF,SOA,BPM]

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 SELECT statements, including:
      • WHERE clause, Comparison Operators, BETWEEN, IN, LIKE, NULL operators, Logical Operators (AND, OR, NOT)
      • ORDER BY clause
      • 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 BY clause, Guidelines for using GROUP BY
    • Joins & Set Operations:
      • Understanding Joins and Cartesian Products
      • Types of Joins: Equijoin, Non-Equijoin, Outer Joins, Self Joins, Cross Joins, Natural Joins
      • Using USING clause, ON clause, Left/Right/Full Outer Joins
      • Subqueries for complex queries
      • Set Operators: UNION, UNION ALL, INTERSECT, MINUS
      • Using set operators with ORDER BY
    • Data Modification:
      • INSERT Statement: Inserting rows with NULL values, copying rows from other tables, common errors
      • UPDATE Statement: Using subqueries in UPDATE statements
      • DELETE Statement: Comparing DELETE and TRUNCATE
      • TRUNCATE Statement
      • COMMIT and ROLLBACK
      • Savepoints
  • Database Design & Management:

    • Database Objects and Data Types
    • Understanding Schemas and CREATE TABLE Syntax
    • Default Options, Constraints (PK, FK, UK, NOT NULL, CHECK)
    • Constraint Guidelines
    • ALTER TABLE Statement: Adding, Modifying, Dropping columns
    • Setting Unused Options, Read-Only Mode, Dropping Tables
    • Character Datatypes and Size Considerations
    • Null Values and ORDER BY Clause
    • 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, WITH Clause
    • Manipulating Data with Subqueries: Inserting, Updating, Correlated Updates/Deletes
    • Controlling User Access & Security: Database Security,
$ whoami — the devs behind tutorialsearch.io

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.

5.0(6)
1h 27m
beginner
5.0(33)
3h 40m
intermediate

بوستغرس PL/PGSQL تعلم

by Mohammed N.S. Al Saadi

5.0(2)
2h 47m
all
4.9(1,157)
10h 13m
intermediate