In today’s digital age, databases are the driving force behind innovation and technological development. The course ‘Introduction to Databases: Relational Databases’ offers you a gateway into this dynamic and ever-expanding world. You will learn to manage and optimise information using database management systems, from storage through to advanced programming. You will delve into the relational data model, exploring concepts such as primary keys, indexes and views, and you will master the SQL language to carry out efficient queries. Furthermore, the course will equip you with the skills to interpret entity-relationship diagrams and use object-relational databases, preparing you to tackle the challenges of today’s job market.
Cross-cutting
Digital Skills
3 pm
Introduction to Databases. Relational Databases
Digital Skills
3 pm
Introduction
Objectives
-
To understand the concepts and functions of database management systems.
-
Identify the different types of databases and their main characteristics.
-
Apply the relational data model and define primary and foreign keys.
-
Implement stored procedures and handle exceptions in databases.
Table of Contents
TEACHING UNIT 1. STORAGE OF INFORMATION
1. Files (drawings, indexed files, shortcuts, etc.)
2. Database concepts
3. Database management systems: Functions and components
4. Types of DBMS
TEACHING UNIT 2. RELATIONAL DATABASES
1. Data model
2. Data types
3. Primary keys
4. Indexes
5. The NULL value
6. Other people’s passwords
7. Views
8. Data Definition Language (DDL)
9. Data Control Language (DCL)
TEACHING UNIT 3. CARRYING OUT SEARCHES
1. The SELECT statement
2. Selection and organisation of records
3. Operators. Comparison operators. Logical operators
4. Summary enquiries
5. Grouping of records
6. Internal compositions
7. External compositions
8. Sub-queries
TEACHING UNIT 4. DATA PROCESSING
1. Inserting records
2. Deleting records. Modifying records
3. Deletions, modifications and referential integrity
4. Transactions
5. Blocking policies
TEACHING UNIT 5. DATABASE PROGRAMMING
1. Introduction. Programming language
2. Functions
3. Flow control structures
4. Stored procedures
5. Subroutines
6. Events and triggers
7. Exceptions
8. Cursors
TEACHING UNIT 6. INTERPRETING ENTITY/RELATIONSHIP DIAGRAMS
1. Entities and relationships. Cardinality
2. Weakness
3. The extended E/R model
4. Moving from the E/R diagram to the relational model
5. Normalisation of relational models
TEACHING UNIT 7. USING OBJECT-RELATIONAL DATABASES
1. Characteristics of object-relational databases
2. Definition of object types
3. Inheritance
4. References
5. Data types in a collection
6. Declaring objects and using the SELECT statement
7. Inserting objects
8. Modifying and deleting objects
More related courses
Cross-cutting
Cross-cutting
Cross-cutting