Development and management of Databases

Databases are a fundamental element in computer applications and systems of all kinds, levels and scales. This course is oriented to the students of the careers of Systems and Telematics and Engineering in Computer Sciences so that they deepen the knowledge in this subject.

 Objective

Train students on the development and management of Oracle databases

 Specific objectives

• Use SQL with Oracle database to carry out educational and commercial applications.
• Build and manage a data repository.

Course methodology

The course will be taught in person on Monday, Tuesday, Wednesday and Thursday. The basic concepts of Oracle will be explained, as well as structure and SQL statements. Subsequently, the elements of database architecture will be addressed to finally conclude with PL-SQL programming.

Duration: 48 hours (32 contact hours, 16 hours of autonomous work)

Curricular content

1. Introduction (6 Hours)

1.1. Oracle Basics

1.2. Installing the 10g database

1.3. Creation of a database

1.4. basic SQL

1.5. advanced SQL

1.6. Database interface

1.7. Process management

2. Database architecture (4 Hours)

2.1. Storage structure management

2.2. Security Administration (users, roles, privileges)

2.3. Database objects (Tables, primary keys, foreign keys, checks)

2.4. Database objects

3. PL-SQL Programming (6 Hours)

3.1. Variables, Statements, Interfaces

3.2. Control Structures, Composite Data Types

3.3. Explicit Cursors

3.4. Exception Control

3.5. subprograms

3.6. packages

Once the activities and requirements for the development of the course have been fulfilled, the participants will receive the approval certificate as long as the participant meets the approval requirements.

Teachers and students of the University of Azuay

mgt. Marcos Orellana Cordero

Free for UDA students and staff

University of Azuay

Ing. Miriam Briones García: formacion.continua@uazuay.edu.ec