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