{"id":2717,"date":"2021-06-20T03:25:40","date_gmt":"2021-06-20T03:25:40","guid":{"rendered":"https:\/\/www.inspirenignite.com\/kl\/4258-relational-database-management-system-lab-kl-diploma-syllabus-for-ca-bm-4th-sem-2015-revision-sitttr\/"},"modified":"2021-06-20T03:25:40","modified_gmt":"2021-06-20T03:25:40","slug":"4258-relational-database-management-system-lab-kl-diploma-syllabus-for-ca-bm-4th-sem-2015-revision-sitttr","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/kl\/4258-relational-database-management-system-lab-kl-diploma-syllabus-for-ca-bm-4th-sem-2015-revision-sitttr\/","title":{"rendered":"4258: Relational Database Management System Lab KL Diploma Syllabus for CA&amp;BM 4th Sem 2015 Revision SITTTR"},"content":{"rendered":"<p align=\"justify\">Relational Database Management System Lab detailed syllabus for Computer Application &amp; Business Management (CA&amp;BM) for 2015 revision curriculum has been taken from the <a class=\"rank-math-link\" href=\"http:\/\/www.sitttrkerala.ac.in\/\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">SITTTRs<\/a> official website and presented for the CA&amp;BM students. For course code, course name, number of credits for a course and other scheme related information,  do visit full semester subjects post given below. <\/p>\n<p align=\"justify\">For Computer Application &amp; Business Management 4th Sem scheme and its subjects, do visit <a class=\"rank-math-link\" href=\"..\/computer-application-business-management-ca-bm-kl-diploma-syllabus-for-4th-sem-2015-revision-sitttr\">CA&amp;BM 4th Sem 2015 revision scheme<\/a>. The detailed syllabus of relational database management system lab is as follows. <\/p>\n<p>  <title>Relational Database Management System Lab<\/title><\/p>\n<h4>Course General Outcomes:<\/h4>\n<p align=\"justify\">\n<ol>\n<li>To understand creating and altering tables<\/li>\n<li>To know about retrieval of information<\/li>\n<li>To understand queries<\/li>\n<li>To understand creating users and setting privileges<\/li>\n<\/ol>\n<h4>SPECIFIC OUTCOMES<\/h4>\n<p align=\"justify\">\n  <b>LIST OF EXERCISES<\/b><\/p>\n<ol>\n<li>Exercises for Creating and Altering Tables<\/li>\n<li>Familiarise various data types and usages<\/li>\n<li>Exercises for creating tables with constraints NULL, DEFAULT, CHECK, PRIMARY KEY, UNIQUE, referential Integrity, creating indexes<\/li>\n<li>Exercises for retrieval of information using SELECT statements with WHERE, ORDER BY clause and deleting records<\/li>\n<li>Exercises for Inserting, Updating and Deleting Data.<\/li>\n<li>Exercises for retrieval of information with aggregate functions and group by, having clauses<\/li>\n<li>Exercises for nested queries, correlated sub queries<\/li>\n<li>Exercises for exists, unique, distinct, union functions<\/li>\n<li>Exercises for joining table with different joins<\/li>\n<li>Exercises for creating views<\/li>\n<li>Experiment using triggers<\/li>\n<li>Experiment using cursors<\/li>\n<li>Experiment using stored procedures and functions<\/li>\n<li>Familiarise Creating Users and Setting up Privileges<\/li>\n<\/ol>\n<p align=\"justify\">For detailed syllabus of all other subjects of Computer Application &amp; Business Management, 2015 revision curriculum do visit <a class=\"rank-math-link\" href=\"..\/category\/ca-bm+4th-sem\">CA&amp;BM 4th Sem subject syllabuses for 2015 revision<\/a>. <\/p>\n<p align=\"justify\">To see the syllabus of all other branches of diploma 2015 revision curriculum do visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/kerala-diploma-syllabus\/\">all branches of SITTTR diploma 2015 revision<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Relational Database Management System Lab detailed syllabus for Computer Application &amp; Business Management (CA&amp;BM) for 2015 revision curriculum has been taken from the SITTTRs official website and presented for the [&hellip;]<\/p>\n","protected":false},"author":2462,"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,46],"tags":[],"class_list":["post-2717","post","type-post","status-publish","format-standard","hentry","category-4th-sem","category-computer-application-business-management"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/2717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/users\/2462"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/comments?post=2717"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/2717\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/media?parent=2717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/categories?post=2717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/tags?post=2717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}