R-DBMS & Oracle (Video Session)
R-DBMS, ER Diagram, Oracle with Practicals
91% of students rate this course 4 stars or above. Limited-time pricing — enroll today.
- Expert-led instruction
- Hands-on projects
- Doubt-resolution sessions
- Industry-relevant content
- Completion certificate
- 7 days money back guarantee*
Course Curriculum
40 Sessions • Structured, progressive learning path designed by industry experts.
What is Data
Session 1 — What is DataIntroduction To Data
Requirements From Data
Session 2 — Requirements From DataUnderstanding Requirments From Data
Flat File Limitations
Session 3 — Flat File LimitationsUnderstanding the limitation of using Flat Files
Functional Dependencies
Session 4 — Functional DependenciesFunctional Dependencies
Normalization
Session 5 — NormalizationNormalization 1NF, 2NF, 3NF
SQL Commands
Session 6 — SQL CommandsUnderstanding Oracle Commands
SQL DataTypes
Session 7 — SQL DataTypesUnderstanding DataTypes in Oracle
SQL Operators & Expressions
Session 8 — SQL Operators & ExpressionsUnderstanding Operators & Expressions in Oracle
DataBase Types
Session 9 — DataBase TypesUnderstanding Types of Databases
Oracle Installation
Session 10 — Oracle InstallationInstall Oracle from Scratch
Corelated SubQuery
Session 11 — Corelated SubQueryDiving into Corelated Queries
Corelated SubQuery - Exists & Not Exists
Session 12 — Corelated SubQuery - Exists & Not ExistsCorelated SubQuery - Exists & Not Exists
Joins Introduction
Session 13 — Joins IntroductionIntroduction to Joins
SQL Joins
Session 14 — SQL JoinsJoins from Join
Self Joins
Session 15 — Self JoinsSelf Join
Left Outer Joins
Session 16 — Left Outer JoinsLeft Outer Join
Right Outer Joins
Session 17 — Right Outer JoinsRight Outer Join
Full Outer Joins
Session 18 — Full Outer JoinsFull Outer Join
Foreign Key
Session 19 — Foreign KeyForeign Key
ER Diagram
Session 20 — ER DiagramER Diagram
ER Diagram-Cardinality of Relationships
Session 21 — ER Diagram-Cardinality of RelationshipsCardinality of Relationships
ER Diagram-Crow Foot Notation
Session 22 — ER Diagram-Crow Foot NotationCrow Foot Notation
ER Diagram-Relationships
Session 23 — ER Diagram-RelationshipsRelationships & Foreign Keys
TCL
Session 24 — TCLData Language-TCL
TCL
Session 25 — TCLData Language-DCL
Single Column Constraint
Session 26 — Single Column ConstraintSingle Column Constraint
DDL - Create
Session 27 — DDL - CreateCreate & Identity
Delete vs Truncate
Session 28 — Delete vs TruncateDelete vs Truncate
DML-Insert
Session 29 — DML-InsertDML-Insert
DML-Update & Delete
Session 30 — DML-Update & DeleteDML-Update & Delete
DML-Select
Session 31 — DML-SelectDML-Select
DML-Select Distinct
Session 32 — DML-Select DistinctDML-Select Distinct
DML-WHERE Clause
Session 33 — DML-WHERE ClauseDML-WHERE Distinct
DML-LIKE Operator
Session 34 — DML-LIKE OperatorDML-LIKE Operator
DML-GROUP BY Operator
Session 35 — DML-GROUP BY OperatorDML-GROUP BY Operator
DML-Date Functions
Session 36 — DML-Date FunctionsDML-Date Functions
DML-Numeric Functions
Session 37 — DML-Numeric FunctionsDML-Numeric Functions
DML-Conversion Functions
Session 38 — DML-Conversion FunctionsDML-Conversion Functions
DML-Miscellaneous Functions
Session 39 — DML-Miscellaneous FunctionsDML-Miscellaneous Functions
DML-Case Statements
Session 40 — DML-Case StatementsDML-Case Statements