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
Cross-cutting
55 hours
Social Media Management: Facebook, TikTok, Instagram, X and LinkedIn
View course →Your questions answered
Why choose Educa.Pro?
Educa.Pro enables organisations to centralise training management, personalise learning and gain clear insights into the impact of training programmes. Thanks to its AI-powered technology, organisations can optimise their learning strategies, enhance talent development and make data-driven decisions.
Can the courses be taken at your own pace?
Yes. Most of the courses on Educa.Pro are self-paced and on-demand, allowing users to progress at their own pace without missing out on progress tracking or assessments, which makes it easier to fit them around work or study commitments.
What levels of security and compliance does the platform offer?
Educa.Pro complies with security standards designed to protect user and organisational data. Furthermore, it supports the traceability of certifications, digital signatures and the management of assessments, thereby ensuring regulatory and legal compliance in both educational and corporate environments.
What support and guidance does Educa.Pro offer?
The Educa.Pro team offers comprehensive support throughout implementation, roll-out and adoption, ensuring that organisations get the most out of the platform and achieve measurable results from day one.