Coding

Database using SQL, relational databases

This module covers the fundamentals of databases, including the difference between relational databases and other types of databases, using MySQL and SQLite. Students will learn how to create and manage databases, as well as how to establish a connection between a program and a database.

In this course, you will learn how to create a database and tables, insert data into tables, and establish relationships between tables using constraints. You will also explore how to retrieve data from multiple tables using various join techniques. Additionally, the course covers how to retrieve data based on specific conditions using operators, and how to apply aggregate functions to obtain more meaningful results. Finally, you will learn how to establish a connection between your program and the database.

Content

Introduction to Databases
Relational Databases and Representation with UML
Creating and Deleting a Database
Creating, Deleting, and Altering Tables
Constraints
Operators
Retrieving Data Based on Conditions and Updating Data in Tables
Aggregate Functions
Joining Tables
Limiting Data
Connecting Our Program to the Database and Interacting with it

Learning Outcomes
  • Represent a relational database using UML diagrams.
  • Create a relational database from scratch.
  • Manipulate data by updating information based on specific conditions.
  • Use aggregate functions to analyze data with additional conditions.
  • Connect a program (using C or C++) to a database to manipulate data.
  • Apply constraints to define rules for data integrity.
  • Retrieve data from multiple tables using different querying techniques.
Training Method

This course will employ problem-solving techniques, encouraging learners to collaborate in building advanced algorithms. This approach will enhance both communication skills and interactive learning, motivating learners to identify and complete the missing pieces in coding challenges.

Organised By
Digital Learning Hub Luxembourg
Digital Learning Hub Luxembourg
Certification
Participation Only
Prerequisites

Strong knowledge in C or C++ is required or having completed module 1  - Programming in C: From Basics to Advanced and module 2 Database using SQL, relational databases

 


Planning and location
Session 1
17/02/2025 - Monday
10:00 - 16:00
Session 2
18/02/2025 - Tuesday
10:00 - 16:00
Session 3
19/02/2025 - Wednesday
10:00 - 16:00
Session 4
20/02/2025 - Thursday
10:00 - 16:00
Learning Track

This course is part of the following learning track(s) and can be booked as a stand-alone training or as part of a whole:

Available Edition(s):

https://www.dlh.lu/web/image/product.template/1476/image_1920?unique=9b31285

This combination does not exist.

80.00 € 80.0 EUR 80.00 €

80.00 €

Not Available For Sale

Your trainer(s) for this course
Vanessa AL DAHAM