Oracle SQL Mastery Guide

Learn Oracle SQL and Gain Data Management Skills

4.8(83)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

Basics

5 lectures

Introduction to Oracle SQL12:01
Working with the Work Environment15:02
Basics of SELECT Queries9:39
Using WHERE Query Conditions15:48
Sorting Results Using ORDER BY12:50

Functions and Queries

7 lectures

Single Row Functions13:01
Single Row Functions10:21
Data Conversion Functions10:34
Writing Conditional Statements6:15
Advanced Grouping Techniques19:12
Understanding Table Joins19:55
Basic Subqueries12:57

Grouping and Joins

3 lectures

Working with Set Operators13:56
Data Manipulation Language (DML) - Part 116:29
Data Manipulation Language (DML) - Part 26:22

Data Management

4 lectures

Introduction to Data Definition Language DDL25:03
Exploring the Database Dictionary12:52
Creating Sequences in Oracle15:38
Creating Indexes and Synonyms8:54

Creation and Administration

4 lectures

Managing Views15:48
Advanced Subqueries10:31
User Access Management15:49
Advanced Data Manipulation Techniques7:00

Instructor

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.

3,945 students28 courses

Related courses

4.9(76)|1,002|2h 42m
Microsoft Access
Learn to Create Databases and Reports
Ahmed Hassan Khamis
$19.99
Start your journey now
4.4(82)|715|16h 18m
Key Logger Spyware Design
Spyware Design Using C++ Language
Eng. Mohamed Ali Mansour
$19.99
Start your journey now
4.7(74)|2,667|17h 30m
Adobe Animate & Action Script
Learn to Create Cartoon Films and Interactive Games
Ahmed Hassan Khamis
$19.99
Start your journey now
4.4(90)|863|12h 40m
Deep Learning
Simulating the Human Mind in Thinking
Eng. Amr Abdel Fattah
$25.99
Start your journey now