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
17:40
Intro to RDBMS
23:14
SQL Normal Forms
14:23
Oracle Products
Oracle SQL Overview
20:00
SELECT Statement
04:56
DESCRIBE Table
31:24
SQL Operators
09:54
Precedence Rule
01:55
Column Alias
05:52
ORDER By Clause
SQL Functions & Joins
07:55
Ampersand Substitution
01:54
Oracle DUAL Table
37:51
SQL Functions
12:53
SQL Sub Queries
24:17
SQL Joins
04:31
SET Operators
Other SQL Commands
13:36
DML Commands
15:16
SQL Data Types
12:17
CREATE Table
09:44
ALTER Table
15:34
Table Constraints
10:14
TCL Commands