Having worked with the largest software company in the world, I gained a lot of expertize on databases and solutions. Typically, whatever solution or product you build, it is a wise thing to separate the design from the content and the data from both. You should hold all your data in a database.
A database is nothing but a set of tables, which hold your data together. Do you know that there are tables in literally every software you use, say for instance wordpress or even firefox?
A DBA is a person, who is an expert in managing databases. It is more common to see a DBA in a corporate environment, where a full time expert is mandatory. I have worked as a DB2 administrator for some time and I found this job very interesting. If you assumed that the job involved creating and deleting tables, think again. A DBA needs more than just basic knowledge about databases and looks at creating indexes, maintaining data dictionaries, manage import and export and even caching. While MYSQL is a small scale solution, oracle is used only for enterprise level solutions. In the information age, where data mining is no longer a buzz, even bigger databases solutions like a DB2 database is used.
I stumbled upon this website, which is a very useful guide for all levels of database users right from novice to advanced. You will find answers to even basic questions about database tables and also other techniques and solutions on databases.
Popularity: 4% [?]
