{"id":674,"date":"2025-08-18T05:02:36","date_gmt":"2025-08-18T05:02:36","guid":{"rendered":"https:\/\/aasiftoday.com\/?page_id=674"},"modified":"2025-08-18T17:18:58","modified_gmt":"2025-08-18T17:18:58","slug":"sql-student-project","status":"publish","type":"page","link":"https:\/\/aasiftoday.com\/?page_id=674","title":{"rendered":"SQL Student Project"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\n\n\n \n Lab Description<\/title>\n <style>\n html, body {\n margin: 0;\n padding: 0;\n background-color: black;\n font-family: \"Courier New\", Courier, monospace;\n font-size: 22px;\n font-weight: bold;\n color: #ffffff;\n line-height: 2;\n width: 100%;\n }\n\n .content {\n max-width: 100%;\n padding: 60px;\n box-sizing: border-box;\n }\n <\/style>\n<\/head>\n<body>\n\n <div class=\"content\">\n First, I created a table to store student information, including their name, birth date, gender, email, and phone number. \n\n <\/div>\n\n<\/body>\n<\/html>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c66a385 e-flex e-con-boxed e-con e-parent\" data-id=\"c66a385\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4671eba elementor-widget elementor-widget-image\" data-id=\"4671eba\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"229\" src=\"https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.03.01-PM-1024x229.png\" class=\"attachment-large size-large wp-image-688\" alt=\"\" srcset=\"https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.03.01-PM-1024x229.png 1024w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.03.01-PM-300x67.png 300w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.03.01-PM-768x172.png 768w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.03.01-PM-1536x343.png 1536w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.03.01-PM.png 1754w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b869338 e-flex e-con-boxed e-con e-parent\" data-id=\"b869338\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5d67925 elementor-widget elementor-widget-html\" data-id=\"5d67925\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n <meta charset=\"UTF-8\">\n <title>Lab Description<\/title>\n <style>\n html, body {\n margin: 0;\n padding: 0;\n background-color: black;\n font-family: \"Courier New\", Courier, monospace;\n font-size: 22px;\n font-weight: bold;\n color: #ffffff;\n line-height: 2;\n width: 100%;\n }\n\n .content {\n max-width: 100%;\n padding: 60px;\n box-sizing: border-box;\n }\n <\/style>\n<\/head>\n<body>\n\n <div class=\"content\">\n Secondly, I created two tables in a relational database: Courses and Enrollments.\n\n <\/div>\n\n<\/body>\n<\/html>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-beeb87c e-flex e-con-boxed e-con e-parent\" data-id=\"beeb87c\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-324b5dd elementor-widget elementor-widget-image\" data-id=\"324b5dd\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"399\" src=\"https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.07.10-PM-1024x399.png\" class=\"attachment-large size-large wp-image-699\" alt=\"\" srcset=\"https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.07.10-PM-1024x399.png 1024w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.07.10-PM-300x117.png 300w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.07.10-PM-768x299.png 768w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.07.10-PM.png 1438w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-69b93da e-flex e-con-boxed e-con e-parent\" data-id=\"69b93da\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2842561 elementor-widget elementor-widget-html\" data-id=\"2842561\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n <meta charset=\"UTF-8\">\n <title>Lab Description<\/title>\n <style>\n html, body {\n margin: 0;\n padding: 0;\n background-color: black;\n font-family: \"Courier New\", Courier, monospace;\n font-size: 22px;\n font-weight: bold;\n color: #ffffff;\n line-height: 2;\n width: 100%;\n }\n\n .content {\n max-width: 100%;\n padding: 60px;\n box-sizing: border-box;\n }\n <\/style>\n<\/head>\n<body>\n\n <div class=\"content\">\n 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. \n\n <\/div>\n\n<\/body>\n<\/html>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-cd41d42 e-flex e-con-boxed e-con e-parent\" data-id=\"cd41d42\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8cfb4f3 elementor-widget elementor-widget-image\" data-id=\"8cfb4f3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"324\" src=\"https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.14.41-PM-1024x324.png\" class=\"attachment-large size-large wp-image-709\" alt=\"\" srcset=\"https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.14.41-PM-1024x324.png 1024w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.14.41-PM-300x95.png 300w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.14.41-PM-768x243.png 768w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.14.41-PM-1536x486.png 1536w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.14.41-PM.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-40dd5b9 e-flex e-con-boxed e-con e-parent\" data-id=\"40dd5b9\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-28fa402 elementor-widget elementor-widget-html\" data-id=\"28fa402\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n <meta charset=\"UTF-8\">\n <title>Lab Description<\/title>\n <style>\n html, body {\n margin: 0;\n padding: 0;\n background-color: black;\n font-family: \"Courier New\", Courier, monospace;\n font-size: 22px;\n font-weight: bold;\n color: #ffffff;\n line-height: 2;\n width: 100%;\n }\n\n .content {\n max-width: 100%;\n padding: 60px;\n box-sizing: border-box;\n }\n <\/style>\n<\/head>\n<body>\n\n <div class=\"content\">\n 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\n\n <\/div>\n\n<\/body>\n<\/html>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ae9d969 e-flex e-con-boxed e-con e-parent\" data-id=\"ae9d969\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a0f7d09 elementor-widget elementor-widget-image\" data-id=\"a0f7d09\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"458\" src=\"https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.18.21-PM-1024x458.png\" class=\"attachment-large size-large wp-image-719\" alt=\"\" srcset=\"https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.18.21-PM-1024x458.png 1024w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.18.21-PM-300x134.png 300w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.18.21-PM-768x343.png 768w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.18.21-PM-1536x687.png 1536w, https:\/\/aasiftoday.com\/wp-content\/uploads\/2025\/08\/Screen-Shot-2025-08-18-at-1.18.21-PM.png 1718w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Lab Description First, I created a table to store student information, including their name, birth date, gender, email, and phone number. Lab Description Secondly, I created two tables in a relational database: Courses and Enrollments. Lab Description Next, I inserted 4 students into the Students table and 3 training courses into the Courses table, each […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-674","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/aasiftoday.com\/index.php?rest_route=\/wp\/v2\/pages\/674","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aasiftoday.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/aasiftoday.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/aasiftoday.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aasiftoday.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=674"}],"version-history":[{"count":43,"href":"https:\/\/aasiftoday.com\/index.php?rest_route=\/wp\/v2\/pages\/674\/revisions"}],"predecessor-version":[{"id":725,"href":"https:\/\/aasiftoday.com\/index.php?rest_route=\/wp\/v2\/pages\/674\/revisions\/725"}],"wp:attachment":[{"href":"https:\/\/aasiftoday.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}