INTRODUCTION
PART I - SQL DEVELOPMENT FOR BEGINNERS
INSTALLATION
INFRASTRUCTURE ARCHITECTURE
ORACLE RDBMS ARCHITECTURE
CONNECTING TO AN ORACLE DATABASE
ORACLE DATABASE - STOP/START
BASIC SELECT STATEMENT
DBA INFO - DBA_TABLESPACES
SELECT - SELECTING SPECIFIC DATA
DBA INFO - ORACLE DATABASE USER ARCHITECTURE
CLASSIFICATION OF SQL COMMANDS
CREATING A SCHEMA
DML - DATA MANIPULATION LANGUAGE
-
BASICS OF DML (1:35)
-
DML - SELECT STATEMENT (0:36)
-
DML - INSERT STATEMENT (1:39)
-
LAB - DML - INSERT FAILS. WHY?
-
DBA INFO - METADATA (1:11)
-
DBA INFO - DATA DICTIONARY (0:34)
-
DBA INFO - DEFAULT PERMANENT TABLESPACE (3:12)
-
FIXING THE FAILED INSERT (0:28)
-
COMMANDS TO FIX THE INSERT (3:31)
-
LAB - COMMANDS TO FIX INSERT
-
DML - UPDATE STATEMENT (2:08)
-
DML - DEMO OF AN UPDATE STATEMENT (1:27)
-
LAB - DML UPDATE STATEMENT
-
DML - DELETE STATEMENT (1:08)
-
DML - DEMO OF A DELETE STATEMENT (1:09)
-
LAB - DML - DELETE STATEMENT
-
DML - MERGE STATEMENT
TCL - TRANSACTION CONTROL LANGUAGE
-
TRANSACTION CONTROL LANGUAGE - BASICS (1:17)
-
WHAT IS A TRANSACTION? (3:56)
-
DEMO OF A TRANSACTION (2:06)
-
LAB - TCL - TRANSACTIONS
-
INTERNAL HANDLING OF A TRANSACTION THROUGH REDO (3:41)
-
INTERNAL HANDLING OF A TRANSACTION THROUGH UNDO (3:07)
-
TCL - COMMIT STATEMENT (1:56)
-
TCL - COMMIT DEMO (2:54)
-
LAB - TCL - COMMIT STATEMENT
-
TCL - ROLLBACK STATEMENT (1:38)
-
LAB - ROLLBACK STATEMENT
-
TCL - SAVEPOINT STATEMENT (1:59)
-
TCL - SAVEPOINT DEMO (2:14)
-
LAB - SAVEPOINT
DCL - DATA CONTROL LANGUAGE
DDL - DATA DEFINITION LANGUAGE
-
DDL - CREATE STATEMENT (0:41)
-
DDL - ALTER STATEMENT (0:21)
-
DDL - DROP STATEMENT (0:24)
-
DDL - RENAME STATEMENT (0:25)
-
DDL - TRUNCATE STATEMENT (0:14)
-
DBA Info - TRUNCATE vs DELETE (0:30)
-
DDL - COMMENT STATEMENT (0:27)
-
DEMO OF ALL THE DDL STATEMENTS (8:24)
-
LAB - ALL THE DDL STATEMENTS
-
ADDRESSING THE OBJECTS (1:19)
DATABASE DESIGN
-
OLTP - ONLINE TRANSACTION PROCESSING SYSTEM (0:56)
-
DSS - DECISION SUPPORT SYSTEM (0:48)
-
DATA MODELING - INTRODUCTION (1:01)
-
LET'S CREATE A DATA MODEL (10:31)
-
DATA MODELING - CONCEPTUAL MODEL (0:54)
-
DATA MODELING - LOGICAL MODEL (0:56)
-
DATA MODELING - PHYSICAL MODEL (0:41)
-
ER MODEL vs ER DIAGRAM (0:30)
-
ENTITY, ATTRIBUTE, TUPLE and RALATIONSHIPS (1:51)
PART II - ORACLE SQL CERTIFICATION MATERIALS
LET'S BUILD A SELECT STATEMENT
ORACLE CERTIFICATION EXAM CONCEPTS - SELECT STATEMENT
CASE SENSITIVITY AND TERMINATORS
A QUICK RECAP
SELECT ANYTHING - EVEN THE NON-EXISTING DATA
ARITHMETIC OPERATIONS
COLUMN ALIAS AND CONCATENATION
SQL DEVELOPER - EXPLORING A SCHEMA
NULL VALUES
RESTRICTING AND SORTING DATA
COMPARISON OPERATORS
-
INEQUALITY OPERATORS - GREATER THAN & LESS THAN (2:40)
-
COMPOSITE INEQUALITY OPERATORS - GREATER/LESS THAN OR EQUAL TO (2:09)
-
COMPOSITE INEQUALITY OPERATORS -NOT EQUAL TO (1:57)
-
INEQUALITY OPERATORS ON DATE VALUES (1:53)
-
RANGE COMPARISON - BETWEEN OPERATOR (2:24)
-
SET COMPARISON - IN OPERATOR (2:18)
-
LAB - FOR THIS SECTION
PATTERN COMPARISON - LIKE OPERATOR
BOOLEAN OR LOGICAL OPERATORS
SUBSTITUTIONS - USING AMPERSANDS
FUNCTIONS
-
FUNCTIONS - INTRODUCTION (3:44)
-
NUMERICAL SINGLE ROW FUNCTIONS (6:01)
-
CHARACTER BASED SINGLE ROW FUNCTIONS (5:14)
-
LAB I - FOR THIS SECTION
-
CHARACTER FUNCTIONS WITH NUMERICAL RESULTS (2:29)
-
DATETIME FUNCTIONS INTRODUCTION (5:41)
-
DATE AND TIME FUNCTIONS - MORE FUNCTIONS (7:49)
-
DATE AND TIME FUNCTIONS - TO_DATE (3:17)
-
COMPARISON FUNCTIONS - GREATEST AND LEAST (1:37)
-
LAB II - FOR THIS SECTION
AGGREGATE FUNCTIONS
CONDITIONAL FUNCTIONS
DISPLAYING DATA FROM MULTIPLE TABLES - JOINS
-
BASICS OF A JOIN - CARTESIAN PRODUCT OR CROSS JOIN (6:15)
-
BASICS OF A JOIN - AMBIGUOUS COLUMN NAMES (2:21)
-
DEMO - CARTESIAN PRODUCT OR CROSS JOIN (1:57)
-
DEMO - AMBIGUOUS COLUMN NAMES (2:27)
-
EQUIJOIN - OLD METHOD (2:47)
-
EQUIJOIN - NEW ANSI STANDARD - JOIN ON CLAUSE (2:15)
-
EQUIJOIN - NEW ANSI STANDARD - JOIN USING CLAUSE (4:18)
-
EQUIJOIN - NEW ANSI STANDARD - NATURAL JOIN CLAUSE (2:09)
-
NON-EQUIJOINS (2:10)
-
OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS (2:36)
-
DEMO - OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS (1:52)
-
LAB - FOR THIS SECTION
USING SUBQUERIES TO SOLVE QUERIES
USING THE SET OPERATORS
MANIPULATING DATA
CONSTRAINTS
ADDITIONAL KNOWLEDGE BASE - DATABASE OBJECTS, DBA ARTICLES, SCRIPTS etc
CONCLUSION
