Oracle 12c SQL Fundamentals

Master writing SQL queries to interact smoothly with database

Count

Construct, Query & Retrieve Data from the Database

From database design to querying a database, there is only one universal language - SQL. This course is designed for absolute beginners who have never interacted with database. Each lecture is carefully crafted to make you speak with Oracle database smoothly. Writing efficient queries and retrieving data from the database tables is fun in itself.

What you will learn

Database design, modeling and data normalization
Query from single and multiple tables with filters
Join multiple tables to retrieve common data
Group, Sort, Filter, Merge, Select and query Oracle database

Getting Started

Intro to RDBMS

17m

SQL Normal Forms

23m

Oracle Products

14m

Oracle SQL Overview

SELECT Statement

20m

DESCRIBE Table

4m

SQL Operators

31m

Precedence Rule

9m

Column Alias

1m

ORDER By Clause

5m

SQL Functions & Joins

Ampersand Substitution

7m

Oracle DUAL Table

1m

SQL Functions

37m

SQL Sub Queries

12m

SQL Joins

24m

SET Operators

4m

Other SQL Commands

DML Commands

13m

SQL Data Types

15m

CREATE Table

12m

ALTER Table

9m

Table Constraints

15m

TCL Commands

10m