ANSI SPARC architecture for Database

Lecture 1

Normalization (functional dependency, 1NF, 2NF, 3NF)

Mapping of ER/EER model to Relational model

Pl/sql introduction (procedure, triggers, implicit cursors) in Oracle 19c

Sequence and index in Oracle 19c

Enhanced Entity Relationship (EER) model

ER model case study

Oracle System user's password forgotten account locked solution

Oracle tutorial part 4 (Create new user, grant and revoke privileges to user) in Oracle 19c

Oracle tutorial part 3 (Create views, perform dml operations on views) in Oracle 19c

Oracle tutorial part 2 (creating new schema, perform different sql operations) in Oracle 19c

Oracle tutorial part 1 (Introduction, Unlocking sample hr schema) in Oracle 19c

Oracle 19c and SQL developer installation on Windows

ER model part 3 (min/max cardinality, optional/mandatory modality, associative entity)

ER model part 2 (Relationships, cardinality ratio)

Entity Relationship (ER) model part 1 (entities, attributes)

Built-in functions in Sqlite (Date and string functions)

Views in database (creating view in Sqlite)

Creating new tables in Sqlite( ddl practice)

Access control using DCL commands(grant, revoke) in sql

Data definition language (DDL) in Sql

Dml (insert, update, delete) tcl (commit, rollback) practice in Sqlite.

Subquery practice in sqlite

DML (insert, update, delete) , TCL (rollback, commit) in Sql