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
Course Contents
Welcome to the course!
Available in
days
days
after you enroll
Introduction to RDBMS and data modeling
Available in
days
days
after you enroll
Database Normalization
Available in
days
days
after you enroll
Introduction to (SQL)
Available in
days
days
after you enroll
Oracle SELECT Statement
Available in
days
days
after you enroll
Oracle SQL Operators
Available in
days
days
after you enroll
Precedence Rule & Records Sorting
Available in
days
days
after you enroll
-
SQL Operators Precedence rule
(4:51)
-
Precedence rule example 1
(5:24)
-
Precedence rule example 2
(4:09)
-
Column Alias in Oracle
(5:42)
-
Table Alias in Oracle
(2:53)
-
ORDER BY clause - sorting data
(6:30)
-
ORDER BY clause example 1
(1:31)
-
Ampersand substitution
(7:25)
-
Ampersand substitution example 1
(3:57)
-
Double Ampersand substitution
(5:37)
-
Oracle DUAL table
(3:31)
SQL Functions
Available in
days
days
after you enroll
-
Single Row Functions
(2:32)
-
Character functions
(16:29)
-
Numeric functions
(6:15)
-
Date functions
(10:56)
-
Group Functions
(5:34)
-
AVG function
(0:59)
-
COUNT function
(2:17)
-
MINIMUM and MAXIMUM functions
(3:09)
-
SUM function
(0:38)
-
GROUP BY clause
(7:12)
-
HAVING clause
(5:06)
-
Data type conversion functions
Test Your Progress
Available in
days
days
after you enroll
SQL Sub-Queries
Available in
days
days
after you enroll
Oracle SQL Joins
Available in
days
days
after you enroll
-
Introduction to SQL join
(3:24)
-
Types of SQL join
(7:54)
-
SQL joins article link
(1:06)
-
Join syntax
(3:26)
-
INNER join and NATURAL join
(5:21)
-
LEFT OUTER join and RIGHT OUTER join
(9:51)
-
FULL OUTER join
(0:42)
-
CARTESIAN join or CROSS join
(0:51)
-
INNER join and NATURAL join - lab practice
(12:58)
-
LEFT OUTER join - lab practice
(6:11)
-
RIGHT OUTER join - lab practice
(5:53)
-
FULL OUTER join - lab practice
(2:13)
-
CARTESIAN join or CROSS join - lab practice
(1:14)
-
LEFT and RIGHT OUTER join - Traditional join method
(1:51)
Oracle SET Operators
Available in
days
days
after you enroll
Other DML Commands
Available in
days
days
after you enroll
Data Type in Oracle
Available in
days
days
after you enroll
DDL Commands in Oracle
Available in
days
days
after you enroll
-
Table level constraints
(10:07)
-
CREATE table
(8:59)
-
CREATE table - lab practice
(6:20)
-
ALTER table
(6:25)
-
DROP and TRUNCATE table
(3:28)
-
RENAME table
(0:28)
-
COMMENT on table and column
(3:56)
-
CREATE table with constraints
(14:24)
-
Testing table constraints
(7:55)
-
Add table constraint using ALTER table command
(2:25)
TCL and DCL Commands
Available in
days
days
after you enroll
Bonus section
Available in
days
days
after you enroll
Meet Your Instructor!
Hi there! I'm Arun Kumar, owner and instructor at DBA Genesis. I created this platform to share my DBA knowledge with all of you. My vision is to simplify DBA learning in order to make you become more competent in your professional career.
Apart from database, I love swimming, filming and business automation!