{"id":502,"date":"2016-07-23T15:51:36","date_gmt":"2016-07-23T15:51:36","guid":{"rendered":"http:\/\/www.inspirenignite.com\/jntuk\/?p=502"},"modified":"2016-08-07T12:23:49","modified_gmt":"2016-08-07T12:23:49","slug":"jntuk-b-tech-database-management-systems-lab-for-r13-batch","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/jntuk\/jntuk-b-tech-database-management-systems-lab-for-r13-batch\/","title":{"rendered":"JNTUK B.Tech Database Management Systems Lab for R13 Batch."},"content":{"rendered":"<p>JNTUK B.Tech Database Management Systems Lab gives you detail information of Database Management Systems Lab R13 syllabus It will be help full to understand you complete curriculum of the year.<\/p><div class=\"a9916ad81d5189659b0bfae0b37c143c\" data-index=\"1\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block; text-align:center;\"\r\n     data-ad-layout=\"in-article\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-client=\"ca-pub-1181153414625576\"\r\n     data-ad-slot=\"9648548092\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n\n<p><strong>Objectives<\/strong><\/p>\n<ul>\n<li>To teach the student database design and query and PL\/SQL.<\/li>\n<\/ul>\n<p>System\/Software Requirements:<\/p>\n<ul>\n<li>Intel based desktop PC<\/li>\n<li>Mysql \/Oracle latest version Recommended<\/li>\n<\/ul>\n<p><strong>PROGRAMS LIST:<\/strong><\/p>\n<ol>\n<li>Creation, altering and droping of tables and inserting rows into a table (use constraints while creating tables) examples using SELECT command.<\/li>\n<li>Queries (along with sub Queries) using ANY, ALL, IN, EXISTS, NOTEXISTS, UNION, INTERSET, Constraints.<br \/>\nExample:- Select the roll number and name of the student who secured fourth rank in the class.<\/li>\n<li>Queries using Aggregate functions (COUNT, SUM, AVG, MAX and MIN), GROUP BY, HAVING and Creation and dropping of Views.<\/li>\n<li>Queries using Conversion functions (to_char, to_number and to_date), string functions (Concatenation, lpad, rpad, ltrim, rtrim, lower, upper, initcap, length, substr and instr), date<br \/>\nfunctions (Sysdate, next_day, add_months, last_day, months_between, least, greatest, trunc, round, to_char, to_date)<\/li>\n<li>i)Creation of simple PL\/SQL program which includes declaration section, executable section and<br \/>\nexception \u2013Handling section (Ex. Student marks can be selected from the table and printed for<br \/>\nthose who secured first class and an exception can be raised if no records were found)<br \/>\nii)Insert data into student table and use COMMIT, ROLLBACK and SAVEPOINT in PL\/SQL<br \/>\nblock.<\/li>\n<li>Develop a program that includes the features NESTED IF, CASE and CASE expression. The program can be extended using the NULLIF and COALESCE functions.<\/li>\n<li>Program development using WHILE LOOPS, numeric FOR LOOPS, nested loops using ERROR Handling, BUILT \u2013IN Exceptions, USE defined Exceptions, RAISE- APPLICATION ERROR.<\/li>\n<li>Programs development using creation of procedures, passing parameters IN and OUT of PROCEDURES.<\/li>\n<li>Program development using creation of stored functions, invoke functions in SQL Statements and<br \/>\nwrite complex functions<\/li>\n<li>Program development using creation of package specification, package bodies, private objects, package variables and cursors and calling stored packages.<\/li>\n<li>Develop programs using features parameters in a CURSOR, FOR UPDATE CURSOR, WHERE CURRENT of clause and CURSOR variables.<\/li>\n<li>Develop Programs using BEFORE and AFTER Triggers, Row and Statement Triggers and INSTEAD OF Triggers<\/li>\n<\/ol>\n<p><strong>TEXT BOOKS<\/strong><\/p>\n<ul>\n<li>ORACLE PL\/SQL by example. Benjamin Rosenzweig, Elena Silvestrova, Pearson Education 3rd Edition<\/li>\n<li>ORACLE DATA BASE LOG PL\/SQL Programming SCOTT URMAN, Tata Mc-Graw Hill.<\/li>\n<li>SQL &amp; PL\/SQL for Oracle 10g, Black Book, Dr.P.S. Deshpande.<\/li>\n<li>Data Base Management System, Oracle SQL and PL\/SQL, Pranab kumar Das Gupta, P Radha Krishna, PHI<\/li>\n<\/ul>\n<p>For more information about all JNTU updates please stay connected to us on FB and don\u2019t hesitate to ask any questions in the comment.<\/p>\n<div class=\"a9916ad81d5189659b0bfae0b37c143c\" data-index=\"2\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block; text-align:center;\"\r\n     data-ad-layout=\"in-article\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-client=\"ca-pub-1181153414625576\"\r\n     data-ad-slot=\"8060844699\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>JNTUK B.Tech Database Management Systems Lab gives you detail information of Database Management Systems Lab R13 syllabus It will be help full to understand you complete curriculum of the year. [&hellip;]<\/p>\n","protected":false},"author":2259,"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":[2],"tags":[],"class_list":["post-502","post","type-post","status-publish","format-standard","hentry","category-syllabus"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/posts\/502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/users\/2259"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/comments?post=502"}],"version-history":[{"count":1,"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/posts\/502\/revisions"}],"predecessor-version":[{"id":503,"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/posts\/502\/revisions\/503"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/media?parent=502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/categories?post=502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/tags?post=502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}