E-Learning

Read, write, search, delete from a file in Python

Division operation, Aggregation operations, query tree in relational algebra

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

Oracle 19c and SQL developer installation on Windows

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

Download and run sqlite on windows

ER model case study

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

Matrix addition in Python

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

Enhanced Entity Relationship (EER) model

Built-in functions (Math module) in Python.

Introduction to sql (select, distinct, order by, limit clause)

Join in Sql ( Cross join, natural join, inner join)

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

If, If-else, elif in Python

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

Introduction to Database

Mapping of ER/EER model to Relational model

Creating new tables in Sqlite( ddl practice)

Creating tables, fields, properties in MS Access

Read, write, search, delete from a file in Python

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

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

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

Lecture 1

ER model part 2 (Relationships, cardinality ratio)

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

Sequence and index in Oracle 19c

Oracle System user's password forgotten account locked solution

Views in database (creating view in Sqlite)

Nested if else in Python

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

ANSI SPARC architecture for Database

Data definition language (DDL) in Sql

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

Subquery practice in sqlite