-
-
SQL - Oracle Lab
- Installing Oracle DataBase 10g 01:51
- Connecting To DB and Preparing Environment 07:43
- Create Simple Table without Constraints 12:38
- Create Table : NOT NULL Constraint 22:33
- Create Table : UNIQUE Constraint 15:26
- Create Table : Primary Key Constraint 11:08
- Create Table : Check Constraint 07:32
- Create Table : Default Constraint 12:08
- Create Table : Foreign Keys Constraint 35:12
- ALTER TABLE : Add Column 07:05
- ALTER TABLE : Drop Column 15:31
- ALTER TABLE : Modify Column 07:46
- ALTER TABLE : ADD Constraint 14:22
- ALTER TABLE : Drop Constraint 18:21
- ALTER TABLE : Enable and Disable Constraint 10:56
- DROP TABLE 07:44
- DESC TABLE 01:33
- INSERT INTO 01:03:03
- INSERT INTO : Date and Timestamp 29:48
- SELECT Statement 01:08:16
- UPDATE Statement 22:29
- DELETE FROM 14:30
- Sub Query 24:21
- Aggregate Functions 27:58
- GROUP BY and HAVING 39:08
- Views 57:27
- Alisas and Prefix 08:55
- Joining Tables 40:20
- Transaction Control Language 17:44
- Data Control Language 11:29
- Full Example ERD to Relational Model TO SQL Part#1 10:05
- Full Example ERD to Relational Model TO SQL Part#2 13:49
-
SQL - Oracle Lab
