Curriculum

Oracle SQL Masterclass : Advanced Skills for Software Developers

Introduction

0/4

Installation

0/6

Query : Common SQL*PLUS commands

0/1

Query : Sorting Data

0/3

Query : Writing Basic SQL Statements

0/7

Query : Single Row Functions

0/10

Query : Restricting Data

0/9

Query : Displaying Data from Multiple Tables

0/7

Query : Sorting Data

0/3

Query : Aggregating Data Using Group Functions

0/5

Query : Single Row Functions

0/10

Query : Subqueries

0/7

Query : Aggregating Data Using Group Functions

0/5

DDL : Creating and Managing Views

0/1

DDL : Creating and Managing Tables

0/8

Data Manipulation Language (DML)

0/4

Data Definition Language (DDL) : Including Constraints

0/5

Data Control Language (DCL)

0/1

Transaction Control

0/2

DDL : Creating and Managing Views

0/1

Data Manipulation Language (DML)

0/4

Other Database Objects

0/3

Quiz and Free E-books

0/2

Bonus Lecture

0/3

What is Next ?

0/1

Text lesson

Introduction to Oracle SQL & Classification

SQL Classifications

SELECT	Query
INSERT UPDATE DELETE MERGE	Data Manipulation Language (DML)
CREATE ALTER DROP RENAME TRUNCATE	Data Definition Language (DDL)
GRANT REVOKE	Data Control Language (DCL)
COMMIT ROLLBACK SAVEPOINT	Transaction Control