Database Fundamentals

• An understanding of general IT concepts
• Experience with using computers and navigating file systems
• Basic knowledge of data and file organization

Audience

• IT systems support personnel
• Database administrators
• Developers or analysts transitioning into data-related roles

Database is a structured system for storing, managing, and retrieving data efficiently. This course introduces participants to the principles of database systems, with a focus on relational database models, data normalization, and SQL-based querying.

This instructor-led, live training (online or onsite) is aimed at intermediate-level IT professionals who wish to understand database management concepts, with a focus on relational database models, and gain practical skills in working with databases.

By the end of this training, participants will be able to:

• Understand database concepts and relational database models.
• Design simple data models and understand normalization.
• Use basic SQL queries to retrieve, insert, and update data.
• Understand key concepts in database administration and security.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction to Databases

• What is a database?
• Types of databases: relational, hierarchical, NoSQL
• When and why to use databases

Database Management Systems (DBMS)

• Overview of DBMS architecture
• Popular systems (SQL Server, MySQL, PostgreSQL, Oracle)
• Responsibilities of a DBMS

Data Modeling and Design

• Entities, attributes, and relationships
• Entity-Relationship (ER) diagrams
• From models to tables

Relational Model and Normalization

• Tables, rows, and columns
• Primary and foreign keys
• 1NF, 2NF, 3NF and denormalization

Basic SQL for Data Access

• SELECT, INSERT, UPDATE, DELETE
• Filtering, sorting, and joins
• Aggregate functions and subqueries

Database Security and User Management

• User roles and permissions
• Authentication and access control
• Securing data in transit and at rest

Backup, Recovery, and Maintenance Basics

• Data backup strategies
• Disaster recovery considerations
• Routine maintenance and monitoring

Summary and Next Steps