Other Stuff In SQL
There are a lot of areas I have not covered. By this tutorial, I wanted to give you start in SQL - not a reference manual. So I only included the elements that are most likely to be used. So here is a list of stuff that I have not touched - and the reason its left untouched...
Database Create/Edit Command
There are SQL commands that is used to create databases. But its rarely used in code - most often, people use a GUI tool like phpMyAdmin. Also, in most well configured systems, you will not be able to do that because you will be running as a user how don't have permission to create databases.
Table Create/Edit Commands
Again, there are GUI tools to do this. Use them - they are your friends. You almost never have the need to do this in your code. If you do, rethink the code - because chances are, there is some huge design flaw in there somewhere.
GUI tools
There are a lot of GUI tools floating around - they are a huge help in creating applications that use a database. You can create databases and tables, add fields, change properties, browse data, edit records - and a lot more. Some of these tools...
- phpMyAdmin - For MySQL
- MySQL Administrator
- Tora
- etc.
Triggers/Stored Procedures
Triggers, Stored Procedures are things you must learn to be really productive with databases. But they will not be taught in this tutorial as it is very different with different database systems. Also, I am not familiar with SQLite triggers and Stored Procedures - and SQLite is needed for demonstration purposes.
Database Storage Engines
If you are working with MySQL, you need to know about the storage engines provided in MySQL. You should understand the advantages and disadvantages of each engine. But, I am trying to keep this tutorial as technology neutral as possible - and only MySQL has this feature(as far as I know).
Optimization
Database/Query optimization is too big a topic for this small tutorial. Search the net for good tutorials on this topic.
I am not a DBA
I am not a Database Administrator - just a Web Developer(LAMP Platform). So there is a lot about databases that I don't know about.
