Oracle

2014★★★★★(4.8)• 31 students enrolled• 15k views

Instructor

Professor Mohammed Safder Ali

Course language

English

COURSE DETAILS

Dive deep into Oracle Database — one of the world's most powerful enterprise-grade RDBMS. Covers installation, PL/SQL, performance tuning, security, and real-world DBA skills.

WHAT YOU'LL LEARN

✓Oracle Database Architecture and core concepts.

✓PL/SQL programming fundamentals.

✓DDL and DML operations in Oracle.

✓Advanced querying with Oracle-specific functions.

✓Database security, users, and privileges.

REQUIREMENTS

Skills in understanding elementary-level English.

COURSE CONTENT

∨Chapter 1 - Course Introduction

1 lecture

Live SQL Training

∨Chapter 2 - Introduction to Software Applications

9 lectures

Application Software Software Development Life Cycle Database Components Database Platforms GUI tools for SQL Development Tansy Cloud Business Application Assignment: Analyzing Slack Business Application Assignment - Analyzing Twitter Social Application Assignment: Analyzing Uber Mobile Application

∨Chapter 3 - Database Tables, Columns and Rows

5 lectures

Database Table ROWs and COLUMNs SQL Assignment - List Tables and Columns - Library Management System Assignment - List Tables and Columns - Facebook Application System

∨Chapter 4 - Setup Sample Database

2 lectures

Oracle Query Editor Database Hosting

∨Chapter 5 - DDL (Data Definition Language)

12 lectures

CREATE TABLE ALTER TABLE DROP TABLE Data Types JSON Data Type NUll vs NOT NULL CHECK Constraint DEFAULT Constraint UNIQUE Constraint AUTO INCREMENT DDL ASSIGNMENT1 - Library Management System DDL ASSIGNMENT2 - Facebook Application

∨Chapter 6 - DML (Data Manipulation Language)

8 lectures

INSERT SELECT INTO UPDATE UPSERT DELETE TRUNCATE SQL DML ASSIGNMENT1 - Library Management System SQL DML ASSIGNMENT2 - Facebook Application System

∨Chapter 7 - DQL (Data Query Language)

44 lectures

SELECT * WHERE Clause FETCH OFFSET DISTINCT ORDER BY BETWEEN Operator CONCAT IN Operator NOT IN Operator IS NULL Operator IS NOT NULL Operator 'AND' and 'OR' Operators '>' and '<' Operator (greater than, less than) '< >' or '!=' Operator (not equal) '=' (equal to) Operator LIKE Operator NOT LIKE Operator EXISTS, ANY and ALL Clause SQL Aliases GROUP BY HAVING Clause COUNT, SUM, AVG, MIN, MAX Functions CASE statement INNER JOIN LEFT JOIN RIGHT JOIN UNION and UNION ALL PIVOT Sub Queries GROUP RANK JSON SELECT Arithmetic Operators Comparison Operators Logical Operators STRING functions DATE functions NUMERIC functions SQL Execution Order CAST COALESCE DQL ASSIGNMENT1 - Library Management System DQL ASSIGNMENT2 - Facebook Application System DQL ASSIGNMENT3 - SQL Logic for Dashboard Reporting in a Library Management System DQL Assignment 4 - Oracle SQL Logic for Dashboard Reporting in a Facebook Application

∨Chapter 8 - RDBMS Concepts

15 lectures

What is RDBMS Primary Key Foreign Key Cardinality Normalization Second Normal Form Third Normal Form Business key, Natural key and Candidate Key Surrogate Key Database Index Index Types Structured VS Unstructured ERD (Data Model) SQL Data Model Assignment - Library Management System SQL Data Model Assignment - Facebook Application

∨Chapter 9 - Advanced Topics

6 lectures

Database View Oracle Stored Procedure DB Function DB Trigger Common Table Extensions (CTE) SQL Window Functions

∨Chapter 10 - Projects

2 lectures

Final Capstone Project 1: Library Management System in Oracle Final Capstone Project 2: Facebook Application in Oracle

∨Chapter 11 - Oracle Certifications

1 lecture

SQL certifications

STUDENT REVIEWS

No Review Found