Database Administration


Academic Year 2017/2018

Lecturer: Michelangelo Ceci

password: dba1213

Lecture Notes:


01 - Physical organization of the data
02 - Transactions
03- Distribuited architectures
04 - Business intelligence (DW)






Lab (ORACLE DATABASE):

Lab0_DBA
Lab1_Install
Lab2_createdatabase
Lab3_Instance
Lab5_Storage
Lab4_Network
Lab6_Users
Lab7_Schema
Lab8_Data
Lab9_Undo
Lab10_Security
Lab11_Performance
Lab12_BR_Concepts
Lab13_Backups
Lab14_Recovery
Less15_Util



Academic Year 2016/2017

Lecturer: Michelangelo Ceci



Lecture Notes:


1-Introduction
2-file organization
3-durability
4-indexes
5-query processing
6-physical design
7-Concurrencycontrol






Lab (ORACLE DATABASE):

Lab0_DBA
Lab1_Install
Lab2_createdatabase
Lab3_Instance
Lab4_Network
Lab5_Storage
Lab6_Users
Lab7_Schema
Lab8_Data
Lab9_Undo
Lab10_Security
Lab11_Performance
Lab12_BR_Concepts
Lab13_Backups
Lab14_Recovery
Less15_Util



Academic Year 2015/2016

Lecturer: Michelangelo Ceci



Lecture Notes:


1-Introduction
2-file organization
3-durability
4-indexes
5-query processing
6-physical design
7-Concurrencycontrol






Lab (ORACLE DATABASE):

Lab0_DBA
Lab1_Install
Lab2_createdatabase
Lab3_Instance
Lab4_Network
Lab5_Storage
Lab6_Users
Lab7_Schema
Lab8_Data
Lab9_Undo
Lab10_Security
Lab11_Performance
Lab12_BR_Concepts
Lab13_Backups
Lab14_Recovery
Less15_Util




Exams:

Example with solutions


Academic Year 2014/2015

Lecturer: Michelangelo Ceci



Lecture Notes:


1-Introduction
2-file organization
3-durability
4-indexes
5-query processing
6-physical design
7-Concurrencycontrol






Lab (ORACLE DATABASE):

Lab0_DBA
Lab1_Install
Lab2_createdatabase
Lab3_Instance
Lab4_Network
Lab5_Storage
Lab6_Users
Lab7_Schema
Lab8_Data
Lab9_Undo
Lab10_Security
Lab11_Performance
Lab12_BR_Concepts
Lab13_Backups
Lab14_Recovery
Less15_Util




Exams:



Academic Year 2013/2014

Lecturer: Michelangelo Ceci



Lecture Notes:


1-Introduction
2-Concurrency control
3-Indexes
4-Query processing
5-Physical design






Lab (ORACLE DATABASE):

Lab1_Install
Lab2_createdatabase
Lab3_Instance.pdf
Lab4_Network
Lab5_Storage
Lab6_Users
Lab7_Schema
Lab8_Data




Exams:









Top of this page



Last Update: 19/5/2016