Completed
SQL DDL Commands - CREATE, ALTER , DROP TABLE - DEMO - Using ORACLE
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
SQL Tutorial - Oracle Database 11g with PL/SQL Programming
Automatically move to the next video in the Classroom when playback concludes
- 1 Installation - Oracle Database 11g Release 2 Express Edition for Windows 64
- 2 SQL DDL Commands - CREATE, ALTER , DROP TABLE - DEMO - Using ORACLE
- 3 SQL - DML Commands - Operators (Relational - Like & Between) -Demo using ORACLE
- 4 SQL - String Handling Functions - Demo using Oracle
- 5 SQL Date Data type (Oracle) - Use of SQL Date data type and its functions
- 6 SQL - Group by, Having - Order by Clause - Demo Using Oracle
- 7 SQL - Primary Key Constraint - Demo using Oracle
- 8 SQL - Column Level Vs Table Level Constraints - Demo using Oracle
- 9 SQL - Foreign Key Constraint - Introduction and Demo using Oracle
- 10 SQL - Foreign Key - On Delete Cascade - On Delete Set Null
- 11 SQL - Joins Demo - Using Oracle
- 12 SQL - Views - Database Management Systems - Demo using Oracle
- 13 SQL - Introduction to Sub Queries (using Oracle) - Nested Sub Queries, ALL - ANY Keywords
- 14 Pl/SQL Session 1 - Introduction , Anonymous block, Procedures, Conditional and Case Statements
- 15 PL/SQL - Session 2 (for, while and simple Loop) GOTO and NULL statements
- 16 PL/SQL Session 3 - Select into Statement , Procedures - IN , OUT, IN OUT parameters - Demo
