ENetArch supports clients requiring network administrative and pc maintenance from single users to 50 clients in the Metro Detroit Area.
SQL explained in shortMany people don't have to work with SQL directly, so be thankful. However programmers of websites usually have to, so here's a brief primer for what SQL does. And for those of you that don't have to deal with it, this little bit of knowledge won't hurt you either. It should be easy enough to follow along with.
SQL only performs 4 actions on data: Create, Destroy, Update and Find.
The easiest way to understand this is to open an XL spreadsheet (which is an example of a flat file database) Each Sheet in the XL spreadsheet is considered a table.
So to Create a Table would look like:
CREATE TABLE 'Address'
This would put the names of the fields across the top of the XL spreadsheet. and each row below would contain information about the people you put in.
To add data to it would look like:
INSERT INTO 'Address'
To find everyone in SomeTown would look like:
To Update my Record would look like:
And later to delete everyone from Royal Oak would look like:
DELETE FROM 'Address'
And finally to destroy the Table would look like:
DROP TABLE 'Address'
Saying of the Day
If youâ€™ve got it, flaunt it.
Eliminate Data Modeling Time |
What would happen if your project timeline spent no time formalizing a data model? Would it cost you the project? What if the application’s object model could serve as the data model? more...