Database Administration
Lecture Slides
Lectures
Video Lectures
Lecture 122 August 2026
Introduction to Oracle Database Administration and Storage
Introduction to database administration, Oracle Database, DBMS concepts, database users and DBA responsibilities, database security, data types, Oracle storage management, tablespaces, datafiles, and indexes
Lecture 229 August 2026
Oracle Users, PDBs, Privileges, and Schema Management
Oracle software components, application developers and database users, multitenant architecture with CDBs and PDBs, SQL*Plus commands, user creation, authentication privileges, tablespace quotas, schemas, and object access control
Lecture 35 September 2026
Oracle Transaction Control and Database User Management
Oracle transaction control using COMMIT and ROLLBACK, DML operations, DELETE statements, transaction behavior, and querying database user information with the DBA_USERS data dictionary view
Lecture 412 September 2026
SQL Number Functions and Group Functions
Oracle SQL number functions including ROUND, TRUNC, and MOD, aggregate group functions such as AVG, COUNT, MAX, MIN, and SUM, DISTINCT with group functions, GROUP BY, multiple-column grouping, and HAVING for filtering groups
Lecture 519 September 2026
Single Row Character Functions
Understanding Oracle single-row character functions, including case conversion and character manipulation functions such as LOWER, UPPER, INITCAP, CONCAT, SUBSTR, LENGTH, INSTR, LPAD, RPAD, and TRIM
Lecture 626 September 2026
Single Row Character Functions
Understanding Oracle single-row character functions, including case conversion and character manipulation functions such as LOWER, UPPER, INITCAP, CONCAT, SUBSTR, LENGTH, INSTR, LPAD, RPAD, and TRIM
Lecture 73 October 2026
MongoDB Overview
Understanding MongoDB as a document-oriented NoSQL database, including its data hierarchy, flexible schema, key features, advantages, and basic MongoDB Query Language (MQL) operations
Lecture 810 October 2026
Subqueries in Oracle SQL
Understanding SQL subqueries and nested queries in Oracle, including inner and outer queries, single-row and multiple-row subqueries, comparison operators, IN, ANY, ALL, and correlated subqueries with practical examples