PythonFullStackCourse/Day21/SQL/data.sql at main · GODSROBOT/PythonFullStackCourse · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
-- Students

INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Rahul', 20, 'A', 'rahul@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Sneha', 19, 'B', 'sneha@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Arjun', 21, 'A', 'arjun@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Priya', 18, 'C', 'priya@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Karan', 22, 'B', 'karan@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Neha', 20, 'A', 'neha@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Ravi', 23, 'D', 'ravi@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Ananya', 19, 'B', 'ananya@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Vikram', 21, 'C', 'vikram@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Meera', 18, 'A', 'meera@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Siddharth', 20, 'B', 'siddharth@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Pooja', 19, 'C', 'pooja@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Aditya', 22, 'A', 'aditya@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Komal', 21, 'B', 'komal@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Manoj', 23, 'C', 'manoj@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Divya', 20, 'A', 'divya@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Rohan', 18, 'B', 'rohan@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Aditi', 19, 'A', 'aditi@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Vivek', 22, 'D', 'vivek@example.com');
INSERT INTO `school`.`student` (student_name, age, grade, email) VALUES ('Shreya', 21, 'B', 'shreya@example.com');


-- Courses
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (1, 'Introduction to Programming with Python', 4);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (2, 'Data Structures and Algorithms', 4);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (3, 'Database Management Systems (DBMS)', 3);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (4, 'Operating Systems', 3);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (5, 'Computer Networks', 3);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (6, 'Software Engineering', 3);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (7, 'Object-Oriented Programming with Java', 4);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (8, 'Web Development (HTML, CSS, JavaScript)', 3);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (9, 'Full Stack Development with MERN', 4);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (10, 'Artificial Intelligence (AI)', 4);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (11, 'Machine Learning', 4);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (12, 'Deep Learning and Neural Networks', 4);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (13, 'Data Science with Python', 4);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (14, 'Big Data Analytics', 3);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (15, 'Cloud Computing (AWS, Azure, GCP)', 3);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (16, 'Cybersecurity and Ethical Hacking', 3);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (17, 'DevOps and CI/CD Tools', 2);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (18, 'Blockchain Technology', 3);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (19, 'Internet of Things (IoT)', 3);
INSERT INTO `school`.`courses` (course_id, course_name, credits) VALUES (20, 'Natural Language Processing (NLP)', 4);