Database Administration

Database Administration

Course title
Database Administration
Course tag
10024
Semester
3
Course status
Mandatory
ECTS
4
Lectures
15
Practice
30
Independent work
75
Total
120
Teachers and associates
PhD Goran Đambić, Senior Lecturer
Msc Mario Fabijanić, Lecturer
Zlatko Stanić, Instructor
The course aims
Get students acquainted with general tasks and challenges that arise in relational database administration. Make students capable of executing basic administrative tasks on SQL Server and Oracle.
Content
Introducing variety of tasks in database administration. Installing and upgrading DBMS. Purpose of data cache. Physical organization of tables and indexes. Creating and configuring databases and storage structures. Creating tables and indexes. Managing database size. Data transfer. Creating database users. Granting permissions to work with data and database objects. Introducing mechanism which enables transactability and recoverability. Making backups and recovering databases. Introducing database optimization techniques. Monitoring database servers. Automating administrative tasks.
Literature:
1. Oracle PL/SQL by Example, Third Edition, Prentice Hall, 2003.
2. Implementing a Microsoft SQL Server 2005 Database (2779)
Supplementary literature
1. SQL Server 2005 Bible by Paul Nielsen
2. M. Gunderloy, Joreden: SQL server 2000, Sybex Inc., 2000.

Minimum learning outcomes

  1. Install and configure SQL Server instance according to requirements.
  2. Set database files size and growth, their physical location and amount of free space - both initially when creating database, as well as later when database is working.
  3. Set suitable permissions to access SQL Server instance, databases and database objects according to requirements.
  4. Perform backups and recovery of SQL Server databases.
  5. Use built-in tools to monitor SQL Server database server performance and automate the most common administrative tasks.
  6. Solve storing preferred credentials with Enterprise Manager Database Control Manage console process for Enterprise Manager Database Control Connect to Enterprise Manager Database Control console.
  7. Navigate to Net Services Administration page in Enterprise Manager. Managing listener process with Listener Control Utility. Managing Oracle instance status with Enterprise Manager.
  8. Identify storage structures in Oracle database. Create and modify tablespace. Managing database users:creating, modifying attributes, unlocking account, resetting password and granting privileges.
  9. Managing database tables, indexes and views: creating, modifying and dropping. Configuring backup settings and flash recovery area. Perform whole database backup and Oracle suggested backup. Managing flashback table and flashback drop.

Preferred learning outcomes

  1. Install SQL Server Reporting Services component. Upgrade SQL Server instance.
  2. Solve the problem when database stops because of lack of space.
  3. Enable users from one SQL Server instance to access databases and database objects on another instance.
  4. Recommend a suitable backup strategy for a SQL Server database according to customer's requirement regarding recovery point and recovery time.
  5. Figure out whether a SQL query can execute faster by creating an indeks.
  6. Managing administrative privileges in Enterprise Manager Database Control. Managing blackout periods in Enterprise Manager Database Control.
  7. Create Local Naming configuration with Net Manager. Create Local Naming configuration with Enterprise Manager. Determine values of initialization parameters using Enterprise Manager. Manage database memory parameters.
  8. Multiplexing redo log files. Managing undo structures in database. Managing roles: creating and granting.
  9. Loading dana from external sources into the database. Performing database restore and recovery. Manage database backups.