What do we need to learn database design?

Question

I'm planing to go towards the database design jobs.I'm wondering if learning the SQL/MySQL enough to get basic knowledge for database design? or any other skills or software need to be learned?!

Answer 1

MySQL would be good enough to learn as long as you're using from the command line or only using SQL commands. Many of the graphical management tools (like SQLyog and MySQL Workbench) will let you manage the database via point-and-click which doesn't really teach you anything. If you want to learn how to use the database, you will need to use SQL only. Some relevant things to master would be:



*Selecting/Updating/Deleting/Inserting data.

*Create/Alter/Drop views, procedures, functions, tables, databases.

*The various levels of normal form, specifically third normal form.

*Constraints, foreign keys, primary keys, etc.

*The different datatypes and when/why to use each.

*Managing indexes, users, partitions, replication, etc.

Answer 2

The answer to your question is yes. MySQL is an excellent tool to learn database design with the only thing it can not do that the major databases do is objects. Understand however that there is some differences in the SQL between databases like Oracle and Microsoft SQL sever. This variation is especially present in Stored procedures. Oracle uses a variant of SQL called PL SQL , Microsoft uses the Transact SQL variant, and MySQL uses ANSI SQL. They are similar but have enough differences to drive you crazy if you have to work between them.

Answer 3

Just about any DBMS will suffice for learning database design to the extent that none of them really teach anything about it. They all permit you to create as good or as poor a database schema as you like.



What you need to do is get familiar with things like normalization and the pros and cons of normalizing to a particular degree (as an aside, in 35+ years in the field, I personally have yet to encounter a situation that required taking a database further than 3NF.)

Answer 4

Yes it is. If you want to interact with a database on the server-side, you're best learning PHP as well.

Answer 5

seem up wordpress or joomla, extremely some function and loose tutorials on you tube. i'm at the instant migrating from Adobe Dreamweaver it is costly application, very stressful to examine and extremely constrained flexibility. till you want to examine the thank you to code from scratch and spent month or years purely learning the applying i might propose you commence with wordpress and joomla and you will have a severe high quality webisite up interior of a week whether you're thoroughly new to this