Oracle SQL Mastery Guide

Learn Oracle SQL and Gain Data Management Skills

5h 5m23 lectures5 sections

What you'll learn

  • Understand database fundamentals
  • Learn to write effective SQL queries
  • Master using functions for data processing
  • Learn to create tables and indexes
  • Acquire skills in joining tables
  • Apply concepts in practical projects

About this course

This course provides you with a deep and comprehensive understanding of database programming using Oracle SQL. You will learn the fundamentals of database management, query writing, and the use of advanced functions. Additionally, you will gain practical experience in data management and creating tables and indexes, enhancing your skills in working with professional databases.

Expected outcomes

  • Familiarity with basic and advanced SQL concepts.
  • Ability to write complex queries for data management.
  • Understanding aggregation techniques, table joins, and using Set Operators.
  • Creating and managing professional databases using Oracle SQL.
  • Developing skills that qualify you to work as a database developer.
  • Implementing practical database projects that simulate real needs.

Course content

1

Basics

5 lectures
  1. Introduction to Oracle SQL12:01
  2. Working with the Work Environment15:02
  3. Basics of SELECT Queries9:39
  4. Using WHERE Query Conditions15:48
  5. Sorting Results Using ORDER BY12:50
2

Functions and Queries

7 lectures
  1. Single Row Functions13:01
  2. Single Row Functions10:21
  3. Data Conversion Functions10:34
  4. Writing Conditional Statements6:15
  5. Advanced Grouping Techniques19:12
  6. Understanding Table Joins19:55
  7. Basic Subqueries12:57
3

Grouping and Joins

3 lectures
  1. Working with Set Operators13:56
  2. Data Manipulation Language (DML) - Part 116:29
  3. Data Manipulation Language (DML) - Part 26:22
4

Data Management

4 lectures
  1. Introduction to Data Definition Language DDL25:03
  2. Exploring the Database Dictionary12:52
  3. Creating Sequences in Oracle15:38
  4. Creating Indexes and Synonyms8:54
5

Creation and Administration

4 lectures
  1. Managing Views15:48
  2. Advanced Subqueries10:31
  3. User Access Management15:49
  4. Advanced Data Manipulation Techniques7:00

Instructor

Eng. Azab Mohamed Azab

Eng. Azab Mohamed Azab

Lecturer at the Arab Academy for Science, Technology and Maritime Transport, and the Egyptian Ministry of Interior, specializing in technology and information.
7,309 students28 courses

Related courses

  • Microsoft Access
    4.6|5,337|0h 0m

    Microsoft Access

    Learn to Create Databases and Reports

    Ahmed Hassan Khamis
    Ahmed Hassan Khamis
    $19.99
    Buy now
  • Key Logger Spyware Design
    4.5|5,026|0h 0m

    Key Logger Spyware Design

    Spyware Design Using C++ Language

    Eng. Mohamed Ali Mansour
    Eng. Mohamed Ali Mansour
    $19.99
    Buy now
  • Adobe Animate & Action Script
    4.7|6,962|16h 58m

    Adobe Animate & Action Script

    Learn to Create Cartoon Films and Interactive Games

    Ahmed Hassan Khamis
    Ahmed Hassan Khamis
    $19.99
    Buy now
  • Deep Learning
    4.5|5,162|12h 40m

    Deep Learning

    Simulating the Human Mind in Thinking

    Eng. Amr Abdel Fattah
    Eng. Amr Abdel Fattah
    $25.99
    Buy now