Certification training
168Lectures
6h 18m 46sDuration
OracleVendor
1z0-0711z0-071: Oracle Database SQL
Prepare for your Oracle exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.
Best seller
Oracle certification training
1z0-071
168 lessons arranged in a guided course path
Course overview
Study with a clear path.
Move through focused sections, review lecture timing, and return directly to the objectives that need more work.
Sequenced lessons
Follow the course in order or jump directly to the section you need to revisit.
Video-first prep
Use concise lecture blocks for technical review before moving into exam practice.
Fast access
Your purchased course becomes available in the member area after confirmed payment.
Curriculum
Course sections.
42 sections, 168 lessons, and lecture-level duration details.
01
Introduction
4m 35s
01
Installing Oracle 12c in Windows 10
11m 49s
02
Using SQL Developer
2m 5s
03
Troubleshooting Connection Issues
3m 16s
01
Client Server Architecture
2m 8s
02
Different types of Clients
3m 53s
01
Quick Overview of Oracle RDBMS Architecture
5m
01
Connecting to an Oracle Database
2m 13s
02
Demo - Connecting as SYSDBA
1m 59s
01
DEMO - Stopping an Oracle Database
1m 13s
02
DEMO - Starting an Oracle Database
3m 6s
01
What is a Table?
1m 31s
02
Data Types
1m 43s
01
Basics of a SELECT Statement
2m 24s
02
DESCRIBE Command - DESC
1m 31s
03
SELECT COUNT - Find the total number of Rows
38s
01
DBA_TABLESPACES
52s
01
Selecting Particular Columns
1m 31s
02
WHERE Clause - Basics
2m 9s
01
Oracle Database User Architecture
5m 36s
02
Schema Vs User
35s
03
How objects are stored?
53s
04
Accessing the Objects
39s
01
Classification of SQL Commands
2m 36s
01
Create a User
2m 14s
02
Create a Table
1m 9s
01
Basics of DML
1m 3s
02
DML - SELECT STATEMENT
24s
03
DML - INSERT STATEMENT
1m 22s
04
DBA Info - METADATA
45s
05
DBA Info - DATA DICTIONARY
15s
06
DBA Info - DEFAULT PERMANENT TABLESPACE
2m 38s
07
DML - Fixing the Failed INSERT
16s
08
Demonstration of the commands to fix the INSERT
3m 11s
09
DML - UPDATE STATEMENT
1m 51s
10
Demo of an UPDATE STATEMENT
1m 12s
11
DML - DELETE STATEMENT
46s
12
Demo - DELETE STATEMENT
1m
01
TCL - Basics
1m 2s
02
What is a Transaction?
3m 33s
03
Demo of a Transaction
1m 45s
04
DBA Info - Internal handling of Transaction through REDO
3m 19s
05
DBA Info - Internal handling of Transaction through UNDO
2m 53s
06
TCL - COMMIT STATEMENT
1m 30s
07
TCL - COMMIT Demo
2m 22s
08
TCL - ROLLBACK STATEMENT
1m 10s
09
TCL - SAVEPOINT STATEMENT
1m 33s
10
TCL - SAVEPOINT Demo
2m 2s
01
DCL - GRANT STATEMENT
29s
02
DCL - SYSTEM PRIVILEGES
20s
03
DCL - OBJECT PRIVILEGES
26s
04
DCL - ROLE PRIVILEGES
46s
05
DCL - REVOKE STATEMENT
13s
06
DCL - GRANT and REVOKE - FULL DEMO
5m 29s
07
DBA Info - Find the DBAs
48s
01
DDL - CREATE STATEMENT
28s
02
DDL - ALTER STATEMENT
6s
03
DDL - DROP STATEMENT
7s
04
DDL - RENAME STATEMENT
11s
05
DDL - TRUNCATE STATEMENT
5s
06
DDL - TRUNCATE vs DELETE
21s
07
DDL - COMMENT STATEMENT
15s
08
ALL THE DDL STATEMENTS - FULL DEMO
7m 46s
09
Addressing the Objects
1m 3s
01
OLTP - Online Transaction Processing System
40s
02
DSS - Decision Support System
33s
03
DATA MODELING - ENTITY RELATIONSHIP MODEL or ER MODEL
44s
04
ER MODEL - CREATION & NORMALIZATION
10m 10s
05
ER MODEL - CONCEPTUAL MODEL
32s
06
ER MODEL - LOGICAL MODEL
39s
07
ER MODEL - PHYSICAL MODEL
28s
08
ER MODEL vs ER DIAGRAM
15s
09
ENTITY, ATTRIBUTE, TUPLE & RELATIONSHIPS
1m 30s
01
SELECT EVERYTHING
35s
02
SELECT PARTICULAR COLUMNS
20s
03
Filtering Data using WHERE Clause
18s
04
JOIN Two Tables
1m 43s
01
PROJECTION, SELECTION & JOINING
57s
02
Mandatory and Optional Clauses of a SELECT Statement
22s
03
ORACLE RESERVED WORDS
41s
01
LOWER and UPPER CASE in SQL Statements
2m 40s
02
SQL STATEMENT TERMINATORS
1m 36s
01
STRUCTURE OF A TABLE - DESCRIBE COMMAND
1m 21s
02
SELECT EVERYTHING - SELECT *
1m 10s
03
FIND THE TOTAL NUMBER OF ROWS - COUNT (*)
40s
01
To Quote or Not to Quote..!
2m 17s
02
DUAL has a DUMMY with an X – Wait, What?
1m 27s
03
Excuse me, Who am I and What is today's date please? - SYSDATE
45s
01
Additions and Subtractions ( + and - )
1m 7s
02
Multiplication and Division ( * and / )
56s
03
Order of Precedence between Multiple Operators
2m 44s
04
Changing the Order of Precedence using Parenthesis
1m 13s
05
Arithmetic Operations on Tables
1m 7s
01
Alias for Columns
2m 30s
02
CONCATENATION - Creating Sentences from the Data
2m 6s
03
Exception for Inner Single Quotes
1m 26s
04
Replacing the Quote Delimiters
2m 47s
01
DISTINCT - Avoiding Duplicates in the Results
1m 22s
01
Unlocking the HR Schema and Connecting
2m 33s
02
Explore a Schema using SQL Developer
1m 50s
01
NULL Values
2m 38s
02
Retrieving NULL Values - IS NULL
1m 33s
03
Retrieving NON-NULL Values - IS NOT NULL
55s
04
Arithmetic Operations on NULL Values
1m 45s
05
Concatenation on NULL Values
2m 25s
06
Substituting NULL Values in the Results
2m 14s
01
Use the ORDER BY clause to sort SQL query results
2m 10s
02
Sorting NULL Values and Expressions
1m 59s
03
Positional and Composite Sorting
2m 33s
04
Limiting the Rows with a WHERE clause
2m 58s
05
Column based and Date based Conditions in WHERE clause
3m 30s
01
INEQUALITY OPERATORS - GREATER THAN & LESS THAN
2m 27s
02
COMPOSITE INEQUALITY OPERATORS - GREATER/LESS THAN OR EQUAL TO
1m 53s
03
COMPOSITE INEQUALITY OPERATORS -NOT EQUAL TO
1m 46s
04
INEQUALITY OPERATORS ON DATE VALUES
1m 39s
05
RANGE COMPARISON - BETWEEN OPERATOR
2m 9s
06
SET COMPARISON - IN OPERATOR
2m 3s
01
LIKE OPERATOR - WITH WILDCARDS % AND _ (UNDERSCORE)
3m 17s
02
LIKE OPERATOR - HANDS ON
5m 3s
03
PATTERN COMPARISON - ESCAPE CHARACTER
3m 12s
01
BOOLEAN or LOGICAL OPERATORS - CONCEPTS
2m 28s
02
BOOLEAN OPERATOR - OR
4m 51s
03
BOOLEAN OPERATOR - AND
2m 35s
04
BOOLEAN OPERATOR - NOT
2m 6s
05
BOOLEAN OPERATORS - HANDS ON DEMO
4m 26s
01
SUBSTITUTIONS - USING AMPERSANDS, DEFINING AND UNDEFINING THE VARIABLES
2m 18s
02
SUBSTITUTIONS - DOUBLE AMPERSANDS
4m 24s
01
FUNCTIONS - INTRODUCTION
3m 32s
02
NUMERICAL SINGLE ROW FUNCTIONS
5m 49s
03
CHARACTER BASED SINGLE ROW FUNCTIONS
5m
04
CHARACTER FUNCTIONS WITH NUMERICAL RESULTS
2m 14s
05
DATETIME FUNCTIONS INTRODUCTION
5m 26s
06
DATE AND TIME FUNCTIONS - MORE FUNCTIONS
7m 31s
07
DATE AND TIME FUNCTIONS - TO_DATE
3m 5s
08
COMPARISON FUNCTIONS - GREATEST AND LEAST
1m 25s
01
AGGREGATE FUNCTIONS - GROUPS and SUBGROUPS
4m 3s
02
AGGREGATE FUNCTIONS - EXAMPLES
5m 40s
03
FILTERING AGGREGATE FUNCTIONS - HAVING CLAUSE
2m 26s
01
CONDITIONAL FUNCTIONS - NVL, NVL2 and NULLIF
3m 3s
02
CONDITIONAL FUNCTIONS - DECODE and CASE
2m 17s
01
BASICS OF A JOIN - CARTESIAN PRODUCT OR CROSS JOIN
6m 1s
02
BASICS OF A JOIN - AMBIGUOUS COLUMN NAMES
2m 8s
03
DEMO - CARTESIAN PRODUCT OR CROSS JOIN
1m 45s
04
DEMO - AMBIGUOUS COLUMN NAMES
2m 16s
05
EQUIJOIN - OLD METHOD
2m 32s
06
EQUIJOIN - NEW ANSI STANDARD - JOIN ON CLAUSE
2m 2s
07
EQUIJOIN - NEW ANSI STANDARD - JOIN USING CLAUSE
4m 5s
08
EQUIJOIN - NEW ANSI STANDARD - NATURAL JOIN CLAUSE
1m 55s
09
NON-EQUIJOINS
1m 56s
10
OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS
2m 22s
11
DEMO - OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS
1m 37s
01
SUBQUERIES - DEFINITION AND SUBQUERY IN THE SELECT CLAUSE
2m 57s
02
SUBQUERY - IN THE WHERE CLAUSE
3m 23s
03
SUBQUERY - IN THE FROM CLAUSE
1m 54s
04
SUBQUERY - IN DMLs - IN INSERT UPDATE DELETE
3m 3s
01
UNION - COMBINING ROWS FROM TWO QUERIES WITHOUT DUPLICATES
4m 37s
02
UNION ALL - COMBINING ROWS FROM TWO QUERIES WITH DUPLICATES
2m 43s
03
INTERSECT - FETCHING THE COMMON ROWS FROM THE RESULTS
1m 53s
04
MINUS - FIRST RESULT SET MINUS SECOND RESULT SET
3m 37s
01
INSERT - VARIOUS METHODS OF INSERTING DATA
4m 32s
02
UPDATE - VARIOUS METHODS OF UPDATING DATA
3m 22s
03
DELETE - VARIOUS METHODS OF DELETING DATA
1m 48s
01
NULL - DEFAULT
1m 41s
02
NOT NULL CONSTRAINT
1m 51s
03
UNIQUE CONSTRAINT
3m 43s
04
PRIMARY KEY CONSTRAINT
2m 39s
05
FOREIGN KEY CONSTRAINTS
5m 18s
01
INDEXES
2m 11s