Relational Database Management Systems (RDBMS) Training in Madrid, Spain

This course provides a comprehensive introduction to Relational Database Management Systems (RDBMS), focusing on database design, SQL querying, optimization, transactions, and security. Participants will learn how to structure and manage relational databases efficiently, optimize queries for performance, and apply best practices in database administration.

Introduction to RDBMS and SQL Fundamentals

• Module 1: Introduction to RDBMS

  • What is an RDBMS?
  • Key components: Tables, Schemas, Keys, Relationships
  • Comparison with NoSQL databases
  • Popular RDBMS software (MySQL, PostgreSQL, SQL Server, Oracle)

• Module 2: SQL Basics

  • Overview of SQL and its role in RDBMS
  • Data types and constraints
  • Creating and managing tables
  • Basic CRUD operations (INSERT, SELECT, UPDATE, DELETE)

• Module 3: Data Retrieval and Filtering

  • SELECT queries with WHERE, ORDER BY, GROUP BY
  • Aggregate functions (COUNT, SUM, AVG, MIN, MAX)
  • Using DISTINCT, LIKE, and LIMIT

Advanced SQL, Normalization, and Indexing

• Module 4: Joins and Subqueries

  • INNER, LEFT, RIGHT, FULL OUTER JOIN
  • Using subqueries in SELECT, INSERT, UPDATE, DELETE
  • Common Table Expressions (CTEs)

• Module 5: Database Normalization and Relationships

  • Importance of normalization in database design
  • Normal forms (1NF, 2NF, 3NF, BCNF)
  • Implementing primary and foreign keys
  • Referential integrity and cascading operations

• Module 6: Indexing and Query Optimization

  • Types of indexes (Clustered, Non-clustered, Unique, Composite)
  • Indexing strategies for performance improvement
  • Analyzing query execution plans

Transactions, Backup, and Security

• Module 7: Transaction Management and Concurrency

  • Understanding ACID properties
  • Implementing transactions with COMMIT and ROLLBACK
  • Concurrency issues and isolation levels (Read Committed, Serializable, etc.)

• Module 8: Stored Procedures, Functions, and Triggers

  • Creating and using stored procedures
  • Writing user-defined functions (UDFs)
  • Implementing database triggers

• Module 9: Database Backup, Recovery, and Security

  • Types of backups (Full, Incremental, Differential)
  • Restoring databases from backups
  • User roles and access control
  • Security best practices (Preventing SQL injection, auditing, encryption)

• Hands-On Labs