{"id":13795,"date":"2020-08-27T06:40:40","date_gmt":"2020-08-27T06:40:40","guid":{"rendered":"https:\/\/www.inspirenignite.com\/mh\/it303-sql-lab-syllabus-for-it-3rd-sem-2017-pattern-mumbai-university\/"},"modified":"2020-08-27T06:40:40","modified_gmt":"2020-08-27T06:40:40","slug":"it303-sql-lab-syllabus-for-it-3rd-sem-2017-pattern-mumbai-university","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/mh\/it303-sql-lab-syllabus-for-it-3rd-sem-2017-pattern-mumbai-university\/","title":{"rendered":"IT303: Sql Lab Syllabus for IT 3rd Sem 2017 Pattern Mumbai University"},"content":{"rendered":"

Sql Lab detailed syllabus scheme for Information Technology (IT), 2017 regulation has been taken from the University of Mumbai<\/a> official website and presented for the Bachelor of Engineering students. For Course Code, Course Title, Test 1, Test 2, Avg, End Sem Exam, Team Work, Practical, Oral, Total, and other information, do visit full semester subjects post given below. <\/p>\n

For all other Mumbai University Information Technology 3rd Sem Syllabus 2017 Pattern, do visit IT 3rd Sem 2017 Pattern Scheme<\/a>. The detailed syllabus scheme for sql lab is as follows.<\/p>\n

Sql Lab Syllabus for Information Technology SE 3rd Sem 2017 Pattern Mumbai University<\/h2>\n

SQL Lab<\/title><\/p>\n<h4>Course Objectives:<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete Syllabus, results, class timetable, and many other features kindly download the <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.<\/b><br \/><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>. <\/p>\n<h4>Course Outcomes:<\/h4>\n<p align=\"justify\">\nStudent should be able to:<\/p>\n<ol>\n<li>Construct problem definition statements for real life applications and implement a database for the same.<\/li>\n<li>Design conceptual models of a database using ER modeling for real life applications and also construct queries in Relational Algebra.<\/li>\n<li>Create and populate a RDBMS, using SQL.<\/li>\n<li>Write queries in SQL to retrieve any type of information from a data base.<\/li>\n<li>Analyze and apply concepts of normalization to design an optimal database.<\/li>\n<li>Implement indexes for a database using techniques like B or B+ trees.<\/li>\n<\/ol>\n<h4>Hardware Requirement:<\/h4>\n<p align=\"justify\">\nPC i3 processor and above<\/p>\n<h4>Software requirement:<\/h4>\n<p align=\"justify\">\nAny SQL Compiler<\/p>\n<h4>Prerequisites:<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete Syllabus, results, class timetable, and many other features kindly download the <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.<\/b><br \/><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>. <\/p>\n<h4>Lab<\/h4>\n<p align=\"justify\">\n<ol>\n<li>\n<ol type=\"i\">\n<li>Students to be given assignments to construct detailed problem definitions for real life applications.<\/li>\n<li>Construction of ER\/EER diagrams for the given problems.<\/li>\n<li>Assignment based on relational Algebra 4 CO 1 CO 2<\/li>\n<\/ol>\n<\/li>\n<li>\n<ol type=\"i\">\n<li>Basic SQL Queries-DDL and DML.<\/li>\n<li>Construction of Database-Keys<\/li>\n<li>Population of the database 5 CO 3<\/li>\n<\/ol>\n<\/li>\n<li>Complex Queries using group by, nested queries, recursive queries, joins, views, Triggers, Cursors 5 CO 4<\/li>\n<li>Design and Implementation of a fully fledged Database with front end for a real life application (Using JDBC. 4 CO 1<\/li>\n<li>Assignment for conversion of relation to different normal forms. 2 CO 5<\/li>\n<li>Program for construction of index- B-Tree \/ B+-Tree 4 CO 6<\/li>\n<\/ol>\n<h4>Text Books:<\/h4>\n<p align=\"justify\">\n<ol>\n<li>SQL The Complete Reference, 3rd Edition , James R Groff, Paul N. Weinberg, Andy Oppel, McGraw Hill.<\/li>\n<li>G. K. Gupta :Database Management Systems, McGraw – Hill<\/li>\n<\/ol>\n<h4>Reference Books:<\/h4>\n<p align=\"justify\">\n<ol>\n<li>Korth, Slberchatz,Sudarshan, :Database System Concepts, 6th Edition, McGraw – Hill<\/li>\n<li>Raghu Ramkrishnan and Johannes Gehrke, Database Management Systems, TMH<\/li>\n<\/ol>\n<h4>Term Work:<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete Syllabus, results, class timetable, and many other features kindly download the <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.<\/b><br \/><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>.<\/p>\n<p align=\"justify\">For detail syllabus of all other subjects of Information Technology (IT) 3rd Sem 2017 regulation, visit <a href=\"..\/category\/it+3rd-sem\">IT 3rd Sem Subjects<\/a> syllabus for 2017 regulation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sql Lab detailed syllabus scheme for Information Technology (IT), 2017 regulation has been taken from the University of Mumbai official website and presented for the Bachelor of Engineering students. For […]<\/p>\n","protected":false},"author":2351,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[35,84],"tags":[],"class_list":["post-13795","post","type-post","status-publish","format-standard","hentry","category-3rd-sem","category-it"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts\/13795","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/users\/2351"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/comments?post=13795"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts\/13795\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/media?parent=13795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/categories?post=13795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/tags?post=13795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}