{"id":70215,"date":"2021-08-29T20:30:35","date_gmt":"2021-08-30T00:30:35","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/must-read-database-driven-software-development-106\/"},"modified":"2021-08-29T20:30:35","modified_gmt":"2021-08-30T00:30:35","slug":"must-read-database-driven-software-development-106","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=70215","title":{"rendered":"Must Read: Database Driven Software Development #106"},"content":{"rendered":"

If you are developing database driven applications, you must need to know and clearly understand the following concepts. Yes, you also need to apply them in your design and implementation. If you do not follow proper database design strategies, many complexities will arise, adjusting new requirements may become cumbersome to impossible.<\/p>\n

Normalization (1NF to 5th NF)<\/a> <\/p>\n

DBMS System Online Course<\/a> <\/p>\n

Practical Database Design Resources<\/a> <\/p>\n

Normalization in Relational DBMS Systems<\/a> <\/p>\n

Boyce\/Codd and Fourth Normal Form<\/a> <\/p>\n

Logical Data Modeling: Logical Database Design Steps: RDBMS<\/a> <\/p>\n

You may want to take a look at the following short-notes also<\/b><\/p>\n

Firebird as an Alternative to Oracle\/MS SQL Server\/Interbase\/Access<\/a> <\/p>\n

Features of Firebird<\/a> <\/p>\n

Comparison: FireBird, MySQL, PostGreSQL<\/a> <\/p>\n

PostGreSQL Limitations and solutions<\/a> <\/p>\n

Important Links for Mysql, PostGreSQL, Firebird, EnterpriseDB, Ingres<\/a> <\/p>\n

Why PostGress better than FireBird: This comparison may not be accurate though.<\/a> <\/p>\n

Speed: Firebird vs. PostGreSql<\/a> <\/p>\n

Tools to create ER diagrams from a database dynamically<\/a> <\/p>\n

MySql Administration SQL Commands<\/a> <\/p>\n

Securing MySQL Database<\/a> <\/p>\n

Joins in MySQL<\/a> <\/p>\n

MySQL Resources: MySQL Start<\/a> <\/p>\n

Stored Procedure in MySql<\/a> <\/p>\n

MySQL Reference Manual<\/a> <\/p>\n

MySQL: Special Interests<\/a> <\/p>\n

MySQL: What to Learn: SQL Statement Syntax<\/a> <\/p>\n

MySQL: What to Learn: SQL Statement Syntax<\/a> <\/p>\n

MySQL: What to Learn: SQL Statement Syntax<\/a> <\/p>\n

Oracle background processes<\/a> <\/p>\n

Oracle Database Objects<\/a> <\/p>\n

Oracle Fundamental Concepts<\/a> <\/p>\n

<\/p>\n

Oracle Certifications Overview<\/a> <\/p>\n

Oracle: Application Developer : Certification : Topics<\/a> <\/p>\n

<\/p>\n

Oracle 11g: Basic PL\/SQL<\/a> <\/p>\n

                                           <p> <a href='displayArticle.php?table=Articles&amp;articleID=682'>Database Administration : Random<\/a> <\/p>                     <br \/> <p> <a href='displayArticle.php?table=Articles&amp;articleID=969'>How to optimize query response time?<\/a> <\/p><br \/> <p> <a href='displayArticle.php?table=Articles&amp;articleID=671'>How to optimize SQL Server Cursors<\/a> <\/p> <p> <a href='displayArticle.php?table=Articles&amp;articleID=672'>What are cursors?<\/a> <\/p> <p> <a href='displayArticle.php?table=Articles&amp;articleID=677'>SQL Server Hints<\/a> <\/p> <p> <a href='displayArticle.php?table=Articles&amp;articleID=681'>Scalability: SQL Server 2005<\/a> <\/p> <p> <a href='displayArticle.php?table=Articles&amp;articleID=685'>Scaling Out<\/a> <\/p> <p> <a href='displayArticle.php?table=Articles&amp;articleID=686'>Dynamic Management Views<\/a> <\/p> <p> <a href='displayArticle.php?table=Articles&amp;articleID=687'>SQL Server Database System Tuning<\/a> <\/p> <p> <a href='displayArticle.php?table=Articles&amp;articleID=711'>SQL Server: Index<\/a> <\/p> <p> <a href='displayArticle.php?table=Articles&amp;articleID=712'>SQL Server : Backups<\/a> \n<\/code><\/pre>\n
 Crystal Report for Java\/JSP<\/a> <\/p>\n
From: http:\/\/sitestree.com\/?p=5212
 Categories:106
Tags:
 Post Data:2008-07-21 01:42:04<\/p>\n
    Shop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a>\n    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a> \n    In Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a>\n    <a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a>\n    8112223 Canada Inc.\/JustEtc: <a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\">http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a>\n    Shop Online: <a href='https:\/\/www.ShopForSoul.com'> https:\/\/www.ShopForSoul.com\/<\/a>\n    Medium: <a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"> https:\/\/medium.com\/@SayedAhmedCanada <\/a>\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
If you are developing database driven applications, you must need to know and clearly understand the following concepts. Yes, you also need to apply them in your design and implementation. If you do not follow proper database design strategies, many complexities will arise, adjusting new requirements may become cumbersome to impossible. Normalization (1NF to 5th … <\/p>\n
Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-70215","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":13935,"url":"http:\/\/bangla.sitestree.com\/?p=13935","url_meta":{"origin":70215,"position":0},"title":"Lesson 26: Database Normalization","author":"Author-Check- Article-or-Video","date":"November 5, 2017","format":false,"excerpt":"Database Normalization in bangla. \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b6\u09bf\u0996\u09be\u09b0 \u09b8\u09ac \u09ad\u09bf\u09a1\u09bf\u0993 \u09aa\u09c7\u09a4\u09c7 \u09ad\u09bf\u099c\u09bf\u099f \u0995\u09b0\u09c1\u09a8 http:\/\/jompesh.com\/videos\/list\/category\/112 , \u098f\u0996\u09be\u09a8\u09c7 \u0986\u09b0\u0993 \u09ac\u09be\u0982\u09b2\u09be\u09df \u09b6\u09bf\u0996\u09a4\u09c7 \u09aa\u09be\u09ac\u09c7\u09a8 Computer Science \u0985\u09a8\u09cd\u09af\u09be\u09a8\u09cd\u09af \u09ac\u09bf\u09b7\u09df \u09af\u09c7\u09ae\u09a8 data structure , System Analysis and Design , C,C++, JAVA, OOP , Operating System \u09b8\u09b9 \u0986\u09b0\u0993 \u0985\u09a8\u09c7\u0995 \u0995\u09bf\u099b\u09c1 . Keyword: Bangla RDBMS , Bangla Oracle , Bangla\u2026","rel":"","context":"In "AI ML DS RL DL NN NLP Data Mining Optimization"","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2017\/11\/hqdefault-105.jpg?fit=480%2C360&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":13903,"url":"http:\/\/bangla.sitestree.com\/?p=13903","url_meta":{"origin":70215,"position":1},"title":"DBMS Lesson 12 : What is integrity Constrain in Database?","author":"Author-Check- Article-or-Video","date":"November 5, 2017","format":false,"excerpt":"What is integrity Constrain in Database? \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b6\u09bf\u0996\u09be\u09b0 \u09b8\u09ac \u09ad\u09bf\u09a1\u09bf\u0993 \u09aa\u09c7\u09a4\u09c7 \u09ad\u09bf\u099c\u09bf\u099f \u0995\u09b0\u09c1\u09a8 http:\/\/jompesh.com\/videos\/list\/category\/112 , \u098f\u0996\u09be\u09a8\u09c7 \u0986\u09b0\u0993 \u09ac\u09be\u0982\u09b2\u09be\u09df \u09b6\u09bf\u0996\u09a4\u09c7 \u09aa\u09be\u09ac\u09c7\u09a8 Computer Science \u0985\u09a8\u09cd\u09af\u09be\u09a8\u09cd\u09af \u09ac\u09bf\u09b7\u09df \u09af\u09c7\u09ae\u09a8 data structure , System Analysis and Design , C,C++, JAVA, OOP , Operating System \u09b8\u09b9 \u0986\u09b0\u0993 \u0985\u09a8\u09c7\u0995 \u0995\u09bf\u099b\u09c1 . Keyword: Bangla RDBMS , Bangla Oracle\u2026","rel":"","context":"In "AI ML DS RL DL NN NLP Data Mining Optimization"","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2017\/11\/hqdefault-89.jpg?fit=480%2C360&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":13929,"url":"http:\/\/bangla.sitestree.com\/?p=13929","url_meta":{"origin":70215,"position":2},"title":"Lesson24 : Relational Database Design Part 1","author":"Author-Check- Article-or-Video","date":"November 5, 2017","format":false,"excerpt":"\u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b6\u09bf\u0996\u09be\u09b0 \u09b8\u09ac \u09ad\u09bf\u09a1\u09bf\u0993 \u09aa\u09c7\u09a4\u09c7 \u09ad\u09bf\u099c\u09bf\u099f \u0995\u09b0\u09c1\u09a8 http:\/\/jompesh.com\/videos\/list\/category\/112 , \u098f\u0996\u09be\u09a8\u09c7 \u0986\u09b0\u0993 \u09ac\u09be\u0982\u09b2\u09be\u09df \u09b6\u09bf\u0996\u09a4\u09c7 \u09aa\u09be\u09ac\u09c7\u09a8 Computer Science \u0985\u09a8\u09cd\u09af\u09be\u09a8\u09cd\u09af \u09ac\u09bf\u09b7\u09df \u09af\u09c7\u09ae\u09a8 data structure , System Analysis and Design , C,C++, JAVA, OOP , Operating System \u09b8\u09b9 \u0986\u09b0\u0993 \u0985\u09a8\u09c7\u0995 \u0995\u09bf\u099b\u09c1 . Keyword: Bangla RDBMS , Bangla Oracle , Bangla database , database tutorials\u2026","rel":"","context":"In "AI ML DS RL DL NN NLP Data Mining Optimization"","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2017\/11\/hqdefault-102.jpg?fit=480%2C360&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":75826,"url":"http:\/\/bangla.sitestree.com\/?p=75826","url_meta":{"origin":70215,"position":3},"title":"Some Topics to Know and Understand to prepare for a DBMS related Job Interview","author":"Sayed","date":"June 25, 2023","format":false,"excerpt":"Some Topics to Know and Understand to prepare for a DBMS related Job Interview ACID ACID: https:\/\/www.geeksforgeeks.org\/acid-properties-in-dbms Database Normalization 1NF: No repeating groups possible for a cell, PK identified, dependencies mapped 2NF: No Partial Dependence. Non key attributes must have to depend on the full key 3NF: No transitive dependency.\u2026","rel":"","context":"In "\u09ac\u09cd\u09b2\u0997 \u0964 Blog"","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":13933,"url":"http:\/\/bangla.sitestree.com\/?p=13933","url_meta":{"origin":70215,"position":4},"title":"Bangla RDBMS Lesson 25 : Relational Database Design Part 2 \u2013 Functional dependency","author":"Author-Check- Article-or-Video","date":"November 5, 2017","format":false,"excerpt":"\u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b6\u09bf\u0996\u09be\u09b0 \u09b8\u09ac \u09ad\u09bf\u09a1\u09bf\u0993 \u09aa\u09c7\u09a4\u09c7 \u09ad\u09bf\u099c\u09bf\u099f \u0995\u09b0\u09c1\u09a8 http:\/\/jompesh.com\/videos\/list\/category\/112 , \u098f\u0996\u09be\u09a8\u09c7 \u0986\u09b0\u0993 \u09ac\u09be\u0982\u09b2\u09be\u09df \u09b6\u09bf\u0996\u09a4\u09c7 \u09aa\u09be\u09ac\u09c7\u09a8 Computer Science \u0985\u09a8\u09cd\u09af\u09be\u09a8\u09cd\u09af \u09ac\u09bf\u09b7\u09df \u09af\u09c7\u09ae\u09a8 data structure , System Analysis and Design , C,C++, JAVA, OOP , Operating System \u09b8\u09b9 \u0986\u09b0\u0993 \u0985\u09a8\u09c7\u0995 \u0995\u09bf\u099b\u09c1 . Keyword: Bangla RDBMS , Bangla Oracle , Bangla database , database tutorials\u2026","rel":"","context":"In "AI ML DS RL DL NN NLP Data Mining Optimization"","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":13885,"url":"http:\/\/bangla.sitestree.com\/?p=13885","url_meta":{"origin":70215,"position":5},"title":"Lesson3 : Introduction to relational model","author":"Author-Check- Article-or-Video","date":"November 4, 2017","format":false,"excerpt":"Introduction to relational model in bangla. \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b6\u09bf\u0996\u09be\u09b0 \u09b8\u09ac \u09ad\u09bf\u09a1\u09bf\u0993 \u09aa\u09c7\u09a4\u09c7 \u09ad\u09bf\u099c\u09bf\u099f \u0995\u09b0\u09c1\u09a8 http:\/\/jompesh.com\/videos\/list\/category\/112 , \u098f\u0996\u09be\u09a8\u09c7 \u0986\u09b0\u0993 \u09ac\u09be\u0982\u09b2\u09be\u09df \u09b6\u09bf\u0996\u09a4\u09c7 \u09aa\u09be\u09ac\u09c7\u09a8 Computer Science \u0985\u09a8\u09cd\u09af\u09be\u09a8\u09cd\u09af \u09ac\u09bf\u09b7\u09df \u09af\u09c7\u09ae\u09a8 data structure , System Analysis and Design , C,C++, JAVA, OOP , Operating System \u09b8\u09b9 \u0986\u09b0\u0993 \u0985\u09a8\u09c7\u0995 \u0995\u09bf\u099b\u09c1 . Keyword: Bangla RDBMS , Bangla Oracle\u2026","rel":"","context":"In "\u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09ae\u09cd\u09af\u09be\u09a8\u09c7\u099c\u09ae\u09c7\u09a8\u09cd\u099f \u09b8\u09bf\u09b8\u09cd\u099f\u09c7\u09ae | DBMS"","block_context":{"text":"\u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09ae\u09cd\u09af\u09be\u09a8\u09c7\u099c\u09ae\u09c7\u09a8\u09cd\u099f \u09b8\u09bf\u09b8\u09cd\u099f\u09c7\u09ae | DBMS","link":"http:\/\/bangla.sitestree.com\/?cat=1886"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/70215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=70215"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/70215\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=70215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=70215"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=70215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}