Fundamentals of Relational Databases Training
Level
BeginnerDuration
32h / 4 daysDate
Individually arrangedPrice
Individually arrangedFundamentals of Relational Databases Training
The Fundamentals of Relational Databases training is an introductory course aimed at familiarizing participants with the foundational concepts of relational databases. The topics include table structure, primary and foreign keys, data normalization, SQL queries, and database design basics. Participants will gain practical knowledge required to create, manage, and query relational databases—an essential skill in computer science and information systems. The course includes hands-on exercises so that participants can apply what they have learned in practice.
Work Environment
- Containerization
- Linux operating system (virtual environment acceptable)
- Windows
Requirements
- Basic programming knowledge is welcome.
- The course uses one of the following databases: MySQL, MariaDB, PostgreSQL, Microsoft SQL Server, Oracle Database.
What will you learn?
- Participants will obtain practical knowledge of relational database fundamentals.
- Participants will be able to design database structures, create relationships between objects, manage data, and query it based on specific conditions.
- Participants will also learn about additional database objects such as views and indexes, and basics of administration.
Who is this training for?
Anyone who wants to learn the basics of relational databases and start using them in their daily work.-
Recommended for roles such as DevOps, Developer, Data Engineer, Data Scientist.
Training Program
-
Introduction to Databases
- What is a database?
- Relationships
- Best practices in database design
- Setting up the working environment (optional)
-
Creating Data Structures
- Creating and modifying tables
- Attributes and constraints
- Relationships (primary and foreign keys)
- Dropping tables
- Inserting data into tables
-
Basics of Data Retrieval
- SELECT keyword
- Unique rows
- Sorting and aliases
- Limiting returned rows
-
Built-in Functions
- Numeric and mathematical functions
- Text functions
- Date and time functions
- Converting and formatting functions
-
Filtering Data
- WHERE clause
- Logical operators
- BETWEEN and IN operators
- IS NULL and LIKE operators
-
Grouping Data
- Aggregate functions
- GROUP BY clause
- HAVING clause
-
Data Sets and Joins
- Subqueries
- JOIN operations
- UNION of data sets
-
DML Commands
- Updating data (UPDATE)
- Deleting data (DELETE)
-
Programming Basics
- Functions
- Procedures
- Triggers
-
Database Objects
- Views
- Indexes
- Temporary tables
-
ACID and Permissions
- Creating users
- Granting and revoking permissions
- Understanding the ACID acronym
- Transactions
