ADVANCED DATABASE ADMINISTRATION - ETIT-427 - IP University (Hindi)

   Friday, October 10, 2025   

Starting a new Lecture Notes Series on ADVANCED DATABASE ADMINISTRATION - ETIT-427 - IP University

Youtube Lecture Playlist Credits 

Channel Name: Easy Engineering Classes

So Let Us Start to This Journey of Learning 

ADVANCED DATABASE ADMINISTRATION - ETIT-427 - IP University By Lecture Notes together!

Lecture 1: Database configuring Assistant (DBCA), Using DBCA to create, delete Database | ADBA/ADBMS Lectures

Lecture 2: Starting and Stopping database control - ETIT 427 - ADBA - IP University Syllabus

Lecture 3: Initialising parameter files - ETIT 427 - ADBA - IP University Syllabus

Lecture 4: Starting Up database instance - ETIT 427 - ADBA - IP University Syllabus

Lecture 5: Shutting Down Database Instance - ETIT 427 - ADBA - IP University Syllabus

Lecture 6: Database Storage structure, How table data is stored? - ETIT 427 - ADBA - IP University Syllabus

Lecture 7: Tablespaces and data files, Types of TableSpaces - ETIT 427 - ADBA - IP University Syllabus

Lecture 8: Creating a user, Authenticating users - ETIT 427 - ADBA - IP University Syllabus

Lecture 9: Unlocking a user account and resetting the password - ETIT 427 - ADBA - IP University Syllabus

Lecture 10: Privileges and role, System privileges, object privileges - ETIT 427 - ADBA - IP University Syllabus

Lecture 11: Data Files - ETIT 427 - ADBA - IP University Syllabus

Lecture 12: Creating Views - ETIT 427 - ADBA - IP University Syllabus

Lecture 13: Index organised tables and heap tables, creating index organised tables

Lecture 14: cluster, cluster types, Index and Hash Cluster - ETIT 427 - ADBA - IP University Syllabus

Lecture 15: What is partition and why use it? Creating a Partition, Partitioning method

Lecture 16: Creating Sequences in SQL, Using Sequences in Insert Statement of SQL

Lecture 17: Detecting and Resolving lock conflicts - ETIT 427 - ADBA - IP University Syllabus

Lecture 18: L70: Create Database, Table Command in SQL | SQL Table Constraints(NOT NULL Example)

Lecture 19: L71: ALTER Command (DDL) in SQL | Add Column, Drop Column, Change Column Datatype Examples

Lecture 20: L72: SQL DROP TABLE, DROP DATABASE, TRUNCATE TABLE Commands with Example | DBMS Lectures in Hindi

Lecture 21: L73: SQL Views, Create Views, DROP Views with examples | SQL Tutorial for Beginners

Lecture 22: L93: SQL Nested Query - Insert, Update, Select and Delete using Sub Queries | DBMS in Hindi

Lecture 23: L97: Introduction to PL-SQL in Database Management System | DBMS Lectures in Hindi

Lecture 24: L102: PL-SQL Functions, How to Create PL SQL Function using Table with Examples | DBMS Lectures

Lecture 25: L103: PL-SQL Procedure, How to Create Procedure, Call Procedure with Example | DBMS Lectures

Lecture 26: L101: PLSQL Cursor, Implicit and Explicit Cursor, How to Open, Fetch, Close Cursor | DBMS Lectures

Lecture 27: L104: PLSQL Trigger, Row and Statement Level Trigger, How to Write Trigger with Examples | DBMS

Lecture 28: L98: PL-SQL Select Into Statement with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 29: L99: PL-SQL Condition Statement - IF Then, If Then else, CASE Statement with Examples | DBMS

Lecture 30: L100: PL-SQL Loops - For Loop, While Loop, Simple PL-SQL Loop with Examples | DBMS Lectures

Lecture 31: L105: PL SQL Exception Handling | How to Raise Exception in PLSQL with Examples | DBMS Lectures

Lecture 32: Monitoring Undo, Administering Undo, Configuring Undo Retention, Sizing Undo tablespace

Lecture 33: Database transparent encryption (TDE), TDE Process, Implementing TDE

Lecture 34: SQL*Loader - Loading data with SQL *loader, Example of Loading MS-Access Data in Oracle

Lecture 35: Flashback database, Architecture, Configuring flashback Database, Monitoring Flashback database

Lecture 36: Moving data- General Architecture, Data pump, Data pump export and Import.

Lecture 37: Recovering from noncritical Losses, recovery from loss of control file, data file

Lecture 38: RMAN - Configuring Recovery Manager, using Recovery manager

Lecture 39: REDO File - Archived Redo Log Mode and NoArchive Redo Log Mode