Contact
Request a demo

Introduction to Databases. Relational Databases

Cross-cutting
Digital Skills

Digital Skills

Duration

3:00 p.m.

PRESENTATION

In today’s digital age, databases are the heart that drives innovation and technological development. The course “Introduction to Databases: Relational Databases” offers you a gateway into this dynamic and ever-expanding world. You’ll learn to manage and optimize information using database management systems, from storage to advanced programming. You’ll delve into the relational data model, exploring concepts such as primary keys, indexes, and views, and you’ll master the SQL language to perform efficient queries. In addition, the course will equip you with skills in interpreting entity-relationship diagrams and using object-relational databases, preparing you to tackle the challenges of today’s job market.

Objectives

  • 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.

Syllabus

TEACHING UNIT 1. INFORMATION STORAGE 1. Files (flat, indexed, direct access, among others) 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. Foreign keys 7. Views 8. Data Definition Language (DDL) 9. Data Control Language (DCL) LEARNING UNIT 3. EXECUTING QUERIES 1. The SELECT Statement 2. Selecting and Sorting Records 3. Operators. Comparison Operators. Logical Operators 4. Summary Queries 5. Grouping Records 6. Inner Joins 7. Outer Joins 8. Subqueries TEACHING UNIT 4. DATA PROCESSING 1. Inserting Records 2. Deleting Records. Modifying Records 3. Deletions, Modifications, and Referential Integrity 4. Transactions 5. Locking 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. Transition from the E/R Diagram to the Relational Model 5. Normalization of Relational Models TEACHING UNIT 7. USING OBJECT-RELATIONAL DATABASES 1. Characteristics of object-relational databases 2. Defining object types 3. Inheritance 4. References 5. Collection data types 6. Declaring objects and using the SELECT statement 7. Inserting objects 8. Modifying and deleting objects
Request for Information

Related MOOCs

Course

Workplace Risk Prevention, Ergonomics, and Mental Health

The Course on Workplace Risk Prevention, Ergonomics, and Mental Health addresses the growing need to ensure environments...
Read more
Course

Digital Disconnection and Legal Compliance in the Workplace

In the age of remote work, hyperconnectivity has put companies under the scrutiny of the Labor Inspectorate....
Read more
Course

The Right to Digital Disconnection, Health, and Work Ethics

In a world of global digitization, hyperconnectivity has gone from being an advantage to becoming a challenge...
Read more

Are the Educa PHAROS courses eligible for credit?

Many courses can be credited toward the master's programs at Structuralia.
Specialized Courses Catalog

Facts about our area

+ 1.483

Hours

+88.999

Minutes

264

Courses

Educa PHAROS is a next-generation training model that places a company’s human capital at the forefront. Through a platform that adapts to each company’s corporate identity and offers a total of more than 900 courses, it provides tailored training for each organization. The unlimited flat-rate plan provides each company with the number of courses that best suits its needs, as well as the ability to determine which employees will have access.
Scroll to Top