+- studentsuvidha (https://studentsuvidha.com/forum)
+-- Forum: Student Stuffs (https://studentsuvidha.com/forum/Forum-Student-Stuffs)
+--- Forum: Indraprastha University IPU notes and papers (https://studentsuvidha.com/forum/Forum-Indraprastha-University-IPU-notes-and-papers)
+---- Forum: IPU B.tech/ B.E. papers and Notes -free downloads (https://studentsuvidha.com/forum/Forum-IPU-B-tech-B-E-papers-and-Notes-free-downloads)
+----- Forum: IPU B.tech/ B.E. IT papers and Notes -free downloads (https://studentsuvidha.com/forum/Forum-IPU-B-tech-B-E-IT-papers-and-Notes-free-downloads)
+------ Forum: 7th semester IPU B.tech IT papers and Notes -free download (https://studentsuvidha.com/forum/Forum-7th-semester-IPU-B-tech-IT-papers-and-Notes-free-download)
+------ Thread: Advanced Database Administration IPU IT notes and question paper free download (/Thread-Advanced-Database-Administration-IPU-IT-notes-and-question-paper-free-download)
Advanced Database Administration IPU IT notes and question paper free download - Dipesh S - 05-01-2017
SYLLABUS:-
UNIT-I
Creating a Database – Database configuring Assistant (DBCA), Password management, Using DBCA to delete a database.
Managing the database instance – Management framework, starting and stopping database control, Initialising parameter files, starting up and shutting down database instance.
Managing Database storage structure – Storage structure, How table data is stored? Tablespaces and data files, Space Management in Tablespaces, Tablespace management.
UNIT-II
Database user security – Creating a user, Authenticating users, Unlocking a user account and resetting the password, Privileges and role, System privileges, object privileges.
Managing Schema Objects – Table types, Action with tables, creating views, sequences, What is partition and why use it? Creating a Partition, Partitioning method, Index organised tables and heap tables, creating indexorganised tables, cluster, cluster types, sorted hash cluster.
Managing data and concurrency – Manipulating with data through SQL, function procedure, packages, Triggers, locking concepts, detecting and resolving lock conflicts.
UNIT-III
Managing undo Data – Monitoring Undo, Administering Undo, Configuring Undo Retention, Sizing Undo tablespace.
Implementing database security – database transparent encryption (TDE), TDE Process, Implementing TDE.
Performance management - troubleshooting, tuning.
UNIT-IV
Performing Backup and Recovery – Configuring Recovery Manager, using Recovery manager, Recovering from noncritical Losses , recovery from loss of control file , data file and redo file.
Performing flashback – Flashback database , Flashback database Architecture, Configuring flashback Database using enterprise manager, Monitoring Flashback database
Moving data- General Architecture , Loading data with SQL *loader , Data pump , Data pump export and import.