Description
The main goal of this course is to introduce participants to the basic concepts of relational databases and SQL queries. At the end of the course, participants will understand what databases are, how they are used in software development and how SQL is used to manage data in relational databases.
Audience
This course is intended for participants who want to gain a conceptual understanding of relational databases and SQL query language. It's suitable for software developers, IT professionals, and other interested parties who want to understand how databases work without getting deeply technical.
No specific prior knowledge is required to participate in this course. Some experience with programming in any programming language can be an advantage, but it is not necessary.
Methods
The course is offered through instructor-led lessons. Participants will receive practical exercises and assignments to practice their skills. The emphasis is on hands-on learning, where participants are actively writing code and solving issues.
Contents
The role of a database in software development.
Introduction to different database types and comparison with classic file-based approaches.
Basic use of SQL (Structured Query Language) and CRUD (Create, Read, Update, Delete) operations.
Structuring data into tables (entities) and understanding relationships between tables.
Read and interpret Entity-Relationship Diagrams (ERD) to understand database design and structure.
Certification
Participation certificate: participants receive a certificate that they have completed this training at the end of the training.