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.
Practical Database Design Resources
Normalization in Relational DBMS Systems
Boyce/Codd and Fourth Normal Form
Logical Data Modeling: Logical Database Design Steps: RDBMS
You may want to take a look at the following short-notes also
Firebird as an Alternative to Oracle/MS SQL Server/Interbase/Access
Comparison: FireBird, MySQL, PostGreSQL
PostGreSQL Limitations and solutions
Important Links for Mysql, PostGreSQL, Firebird, EnterpriseDB, Ingres
Why PostGress better than FireBird: This comparison may not be accurate though.
Speed: Firebird vs. PostGreSql
Tools to create ER diagrams from a database dynamically
MySql Administration SQL Commands
MySQL: What to Learn: SQL Statement Syntax
MySQL: What to Learn: SQL Statement Syntax
MySQL: What to Learn: SQL Statement Syntax
Oracle Certifications Overview
Oracle: Application Developer : Certification : Topics
<p> <a href='displayArticle.php?table=Articles&articleID=682'>Database Administration : Random</a> </p> <br /> <p> <a href='displayArticle.php?table=Articles&articleID=969'>How to optimize query response time?</a> </p><br /> <p> <a href='displayArticle.php?table=Articles&articleID=671'>How to optimize SQL Server Cursors</a> </p> <p> <a href='displayArticle.php?table=Articles&articleID=672'>What are cursors?</a> </p> <p> <a href='displayArticle.php?table=Articles&articleID=677'>SQL Server Hints</a> </p> <p> <a href='displayArticle.php?table=Articles&articleID=681'>Scalability: SQL Server 2005</a> </p> <p> <a href='displayArticle.php?table=Articles&articleID=685'>Scaling Out</a> </p> <p> <a href='displayArticle.php?table=Articles&articleID=686'>Dynamic Management Views</a> </p> <p> <a href='displayArticle.php?table=Articles&articleID=687'>SQL Server Database System Tuning</a> </p> <p> <a href='displayArticle.php?table=Articles&articleID=711'>SQL Server: Index</a> </p> <p> <a href='displayArticle.php?table=Articles&articleID=712'>SQL Server : Backups</a>
From: http://sitestree.com/?p=5212
Categories:106
Tags:
Post Data:2008-07-21 01:42:04
Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
(Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a>
In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
<a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>