BABU MADHAV INSTITUTE OF INFORMATION TECHNOLOGY, UTU
[Link].(IT) / Integrated [Link].(IT)
Semester-V
IT5017 | Database Administration Essentials |
Lesson Plan
Sub No. of Reference Chapters/ Additional Evaluation
Unit Topics
Unit Lecture(s) Reading Parameter
1 6 Database Components and Architecture Unit Test: 01
1.1 1 Database Objects TB1 - Ch.08 Pg. 386 – 388
1.2 1 Database Architecture TB1 - Ch.08 Pg. 391 – 394
1.3 1 User and Server Processes TB1 - Ch.08 Pg. 394 – 396
1.4 1 Database Instance and It’s Components TB1 - Ch.08 Pg. 396 – 403
1.5 1 Background Processes TB1 - Ch.08 Pg. 403 – 410
1.6 1 Database Storage Structures: Physical and Logical TB1 - Ch.08 Pg. 410 – 424
2 9 Database Storage and Space Management Unit Test: 01
2.1 2 Physical and Logical Storage, Data Block TB1 - Ch.10 Pg. 512 – 516
2.2 1 Managing Tablespaces TB1 - Ch.10 Pg. 516 – 534
2.3 2 Managing Data Files: Operation on Data Files, Oracle
TB1 - Ch.10 Pg. 534 – 547
Managed Files Feature
2.4 2 Managing Space: Automatic Space Management TB1 - Ch.10 Pg. 547 – 550
Features, Locally Managed Tablespaces, Automatic
Segment Space Management
BHAVIK SARANG | UKA TARSADIA UNIVERSITY PAGE 1
BABU MADHAV INSTITUTE OF INFORMATION TECHNOLOGY, UTU
[Link].(IT) / Integrated [Link].(IT)
2.5 1 Proactive Space Management, Segment Advisor TB1 - Ch.10 Pg. 553 – 562
3 11 Concurrency Management Unit Test: 01
3.1 1 Managing Data Changes TB1 - Ch.11 Pg. 570 – 572
3.2 2 Undo and Redo, Instance recovery using Undo and
TB1 - Ch.11 Pg. 572 – 575
Redo
3.3 2 Read Consistency using Undo TB1 - Ch.11 Pg. 575 – 584
3.4 2 Lock and Transaction, Lock modes TB1 - Ch.11 Pg. 585 – 590
3.5 2 Lock Conflicts TB1 - Ch.11 Pg. 590 – 593
3.6 2 Resolving Deadlocks TB1 - Ch.11 Pg. 593 – 594
4 10 Database Network Architecture Unit Test: 02
4.1 2 Network Configurations TB1 - Ch.12 Pg. 604 – 607
4.2 1 Features of Database Net TB1 - Ch.12 Pg. 607 – 610
4.3 2 Configuration of Database Net: Listener, Listener’s TB1 - Ch.12 Pg. 613 – 618
responses to connection requests
4.4 2 Database Server: Comparison between Dedicated and TB1 - Ch.12 Pg. 648 – 651
Shared Server, Advantages and disadvantages of
Shared Server
4.5 1 Database Resident Connection Pooling, Comparing TB1 - Ch.12 Pg. 661 – 666
Connection Architectures
4.6 2 Communication Between Databases TB1 - Ch.12 Pg. 666 – 668
5 6 Database Security and Audit Unit Test: 02
BHAVIK SARANG | UKA TARSADIA UNIVERSITY PAGE 2
BABU MADHAV INSTITUTE OF INFORMATION TECHNOLOGY, UTU
[Link].(IT) / Integrated [Link].(IT)
5.1 1 User Accounts, Authentication Configuration TB1 - Ch.13 Pg. 678 – 681
5.2 1 Assigning Tablespaces and Quota, Assigning Profile TB1 - Ch.13 Pg. 681 – 687
5.3 1 Granting and Revoking Privileges: Table object
TB1 - Ch.13 Pg. 687 – 690
privilege, View object privilege
5.4 1 Granting and Revoking privileges with and without
TB1 - Ch.13 Pg. 690 – 700
Grant option
5.5 1 Roles: Creating and Managing Role Privileges,
TB1 - Ch.13 Pg. 701 – 705
Default Database Roles
5.6 1 Auditing Database, Enabling and Disabling Statement
TB1 - Ch.13 Pg. 718 – 724
Auditing
6 6 Performance Management, Backup and Recovery Unit Test: 02
6.1 1 Proactive and Reactive Monitoring TB1 - Ch.14 Pg. 754 – 755
6.2 1 Optimizer statistics, Cost Based Optimizer; Collecting TB1 - Ch.14 Pg. 755 – 760
statistics Automatic and Manually
6.3 1 Automatic Workload Repository TB1 - Ch.14 Pg. 775 – 782
6.4 1 Managing Performance, Sources of Performance TB1 - Ch.14 Pg. 806 – 811
Tuning
6.5 1 Database Backup: Basic Terminology, User Managed TB1 - Ch.15 Pg. 848 – 856
Cold Backup, User Managed Hot Backup,
Introduction to RMAN Backup
BHAVIK SARANG | UKA TARSADIA UNIVERSITY PAGE 3
BABU MADHAV INSTITUTE OF INFORMATION TECHNOLOGY, UTU
[Link].(IT) / Integrated [Link].(IT)
Database Recovery: Types of Database Failure, TB1 - Ch.15 Pg. 864 – 872
6.6 1
Instance Start-up, Recovery from Instance Failure
Text Books:
1. Biju Thomas OCA Oracle Database 12c Administrator Certificate Associate, Study guide, Sybex.
Reference Books:
1. Biju Thomas OCA Oracle Database 11G Certificate Associate, Study guide, Sybex.
BHAVIK SARANG | UKA TARSADIA UNIVERSITY PAGE 4