Today I have another blog post to share and this is from Net.TutsPlus.com and it talks about techniques that developers can make use of especially when creating a \u201cdata-driven\u201d website.<\/p>\n

Before I have been using MySQL for my projects so I can say that this post is more beneficial for website developers and system developers. But if your are just starting out then this is a good list for you to consider when building your systems or websites.<\/p>\n

Use the Right Language<\/strong><\/span><\/p>\n

Using the right language is very important for every web developers. The basic rule is that when writing a code, make sure that it works effectively.<\/p>\n

Secure Your Code<\/strong><\/span><\/p>\n

It explains how web developers should take security in their code seriously. SQL injection is one of the most common form of attack. Remember to test your code and keep updated with the security issues in DBMS for protection.<\/p>\n

Understand Joins<\/strong><\/span><\/p>\n

Remember the correlation between inner joins and outer joins. \u201cSelf Joins\u201d is a kind of join from a table itself.<\/p>\n

Know Your Data Types<\/strong><\/span><\/p>\n

This is very important especially when dealing with the later topic: indexing. On a side note, \u201cEfficient queries are essential to creating quality, scalable applications.\u201d<\/p>\n

Write Compliant Code<\/strong><\/span><\/p>\n

Programmers and System developers should be aware of the revisions in SQL. The latest revision was in 2008. Two reasons why codes should be standards compliant is first, for maintainability, and second, for cross-platform standardization.<\/p>\n

Normalize Your Data<\/strong><\/span><\/p>\n

Be familiar with the Normal forms, 1NF, 2NF, 3NF, 4NF, 5NF. 3NF is the most important jump among all these. Data becomes cleaner, better organized and faster.<\/p>\n

Fully Qualify Your Database Object Names<\/strong><\/span><\/p>\n

The purpose of this is to eliminate ambiguity. Fully qualified name should look like DATABASE.SCHEMA.OBJECTNAME.<\/p>\n

Understanding Indexing<\/strong><\/span><\/p>\n

This is important when working with large tables.<\/p>\n

Properly Use Database Permissions<\/strong><\/span><\/p>\n

SQL server have the GRANT, DENY and REVOKE statements to take or give away permissions from a user or role. Granting the role to other users (unknowingly) might affect the database security heavily.<\/p>\n

Know Your DBMS Limitation<\/span><\/strong><\/p>\n

Knowing the limitations will help you in the planning phase in order for you to foresee if it can meet your specific requirements.<\/p>\n

Check out the original\u00a0post here<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Today I have another blog post to share and this is from Net.TutsPlus.com and it talks about techniques that developers can make use of especially when creating a \u201cdata-driven\u201d website. Before I have been using MySQL for my projects so I can say that this post is more beneficial for website developers and system developers. […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_mi_skip_tracking":false,"spay_email":"","_links_to":"","_links_to_target":""},"categories":[1773],"tags":[1346,237,1739,1759],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p2BD1N-1LV","_links":{"self":[{"href":"https:\/\/www.mybravetruehero.com\/wp-json\/wp\/v2\/posts\/6815"}],"collection":[{"href":"https:\/\/www.mybravetruehero.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mybravetruehero.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mybravetruehero.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mybravetruehero.com\/wp-json\/wp\/v2\/comments?post=6815"}],"version-history":[{"count":0,"href":"https:\/\/www.mybravetruehero.com\/wp-json\/wp\/v2\/posts\/6815\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.mybravetruehero.com\/wp-json\/wp\/v2\/media?parent=6815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mybravetruehero.com\/wp-json\/wp\/v2\/categories?post=6815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mybravetruehero.com\/wp-json\/wp\/v2\/tags?post=6815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}