Introduction to DataBases (CYBER PRO TRAIN)

This course offers a foundational Introduction to DataBases (relational database systems), covering their purpose, core functions, and significance in computing. 

It begins with an overview and the historical evolution of relational database systems, tracing their development from abacus to modern multi-user and real-time environments. Key concepts such as its definition and its function will also be covered. The course also examines the structure of relational database systems in line with transactional processing, security, relational data structures and provides a clear understanding of the purpose and management of a relational database engine. 

About this course

Objectives

• Introduce core concepts of database systems, including relational models and SQL
• Teach database design principles, normalization, and data modeling techniques
• Explain transaction management, concurrency control, and ACID properties
• Cover database security fundamentals, including access control and encryption
• Explore performance optimization, indexing, and query tuning
• Present advanced topics like data warehousing, analytical queries, and cloud databases
• Introduce AI/ML applications for enhanced database functionality

Outcomes

• Ability to design and implement relational databases using SQL
• Competence in managing transactions and ensuring data consistency
• Skills to secure databases against common threats and enforce access policies
• Capability to optimize database performance and handle large-scale analytics
• Understanding of cloud-based database architectures and hybrid solutions
• Preparedness to leverage AI/ML tools for smarter data management

Target audience

• Professionals, including SME employees and Public Administration staff, looking to enhance their cybersecurity knowledge 

Program

• Why Databases
• Codd´s Principles
• The Standard Database. Oracle as an example. 
• SQL 
• Security
• Modeling Complexity 
• Analytics
• Databases in the Cloud 
• Intelligent Access and Automation 

Additional resources (individual study)

• Oracle 23ai for Windows (free, local installation) — Free Developer Edition database for Winx64