First, I created a table to store student information, including their name, birth date, gender, email, and phone number.
Secondly, I created two tables in a relational database: Courses and Enrollments.
Next, I inserted 4 students into the Students table and 3 training courses into the Courses table, each with details like names, contact info, and instructors. This helps set up initial data for testing or demonstration.
This part of the code shows how student and course data are connected using different types of joins. The INNER JOIN shows only students who are enrolled in courses. The LEFT JOIN lists all students, even if they aren’t enrolled in any course. The FULL OUTER JOIN shows all students and all courses, even if there’s no match between them
