Description
The main goal of this course is to familiarize participants with relational databases, SQL (Structured Query Language), and database design. At the end of the course, participants will be able to perform simple queries, edit data in a database, and understand basic database design concepts.
Audience
This course is intended for people with no prior knowledge of databases and SQL who are interested in understanding the role of databases in software development and in learning the basics of SQL. It is suitable for newbies in the field of database management and querying.
No specific prior knowledge is required to participate in this course. It is designed as an introductory course and is therefore accessible to participants with no previous experience in databases or SQL.
Methods
The course is offered through instructor-led lessons as well as self-study. 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 programming issues.
Contents
The role of databases in software development.
Types of databases and their comparison with classic file approaches.
Perform simple SQL queries to filter, sort, and group data.
Edit data and database structure with SQL
Creating an Entity Relationship Diagram (ERD) based on unstructured sources of information.
Evaluation and modification of an existing ERD based on new information.
Identification and application of correct relationship types in a database.
Certification
Participation certificate: participants receive a certificate that they have completed this training at the end of the training.