Introduction to Relational Databases Training

Infoshare is the largest tech community in CEE and the organizer of the leading tech conference in Gdańsk. It connects startups, investors, corporations, and innovation enthusiasts. It promotes entrepreneurship, knowledge sharing, and networking. Through events, competitions, and programs, it supports the development of the tech ecosystem in Poland and the region.

• The relational database fundamentals training is an introductory course aimed at familiarizing participants with the fundamental concepts related to relational databases. Topics covered include table structure, primary and foreign keys, data normalization, SQL queries, and the basics of database design. Participants gain practical knowledge necessary for creating, managing, and querying relational databases, which is an essential skill in the field of computer science and information systems. The training also includes practical exercises to enable participants to apply the acquired knowledge in practice. The course is based on one of the databases: MySQL, MariaDB, PostgreSQL, Microsoft SQL Server, Oracle Database. Programming background is welcome.
• Working Environment:
• Containerization
• Linux operating system (acceptable virtual environment)
• Windows

• The training is aimed at anyone who wants to learn the basics of relational databases and how to use them in their daily work.
• Recommended training for positions: devops, developer, data engineer, data scientist.

• The participant will have practical knowledge of the fundamentals of relational databases.
• They will be able to create a database structure, establish relationships between objects, manage data, and display it according to specified conditions.
• They will know additional objects such as views, indexes, and the basics of administration.

1. INTRODUCTION TO DATABASES
    • what is a database?
    • relationships
    • best practices for database design
    • installation of the working environment (optional)

2. CREATING DATA STRUCTURE
    • creating and modifying tables
    • attributes and constraints
    • relationships (primary and foreign key)
    • deleting tables
    • adding data to tables

3. BASICS OF DATA QUERYING
    • SELECT keyword
    • unique rows
    • sorting and aliases
    • limiting returned rows

4. BUILT-IN FUNCTIONS
    • mathematical/numeric functions
    • text functions
    • date and time functions
    • converting and formatting functions

5. FILTERING DATA
    • WHERE keyword
    • logical operators
    • operators: BETWEEN and IN
    • operators: IS NULL and LIKE

6. GROUPING DATA
    • aggregate functions
    • GROUP BY keyword
    • HAVING keyword

7. DATA SETS
    • subqueries
    • JOIN operation
    • UNION operation

8. DML COMMANDS
    • updating data (UPDATE)
    • deleting data (DELETE)

9. BASICS OF PROGRAMMING
    • functions
    • procedures
    • triggers

10. DATABASE OBJECTS
     • views
     • indexes
     • temporary tables

11. ACID AND PERMISSIONS
     • creating users
     • adding and removing permissions
     • ACID acronym
     • transactions

32 h/ 4 days