On Jan 6, 2012, at 12:13 AM, Chris Kavanagh wrote: > I believe, thanks to your (previous) post, I was confused as to the > difference between SQL and Database in general. I had thought learning > SQL was learning database design. When in actuality, it's just the > language used to access databases. I need to study database concepts > and design.
There are two main aspects to SQL: Data Definition Language (DDL [1]) and Data Manipulation Language (DML [2]). DDL is was you design database with (create table, etc). DML is what you interact database with (select, update, etc). In the same way as it's rather helpful to understand HTTP itself to build a web application, it's rather essential to understand database design if you build a database, irrespectively of sugar coating (ORM [3], MVC, and other TLA). Learn about normalization [3]. Take a look at SQLite to get started [4][5]. In the meantime: Double-thinking in SQL http://explainextended.com/2009/07/12/double-thinking-in-sql/ Also: http://browsertoolkit.com/fault-tolerance.png [1] http://en.wikipedia.org/wiki/Data_Definition_Language [2] http://en.wikipedia.org/wiki/Data_Manipulation_Language [3] http://en.wikipedia.org/wiki/Database_normalization [4] http://www.sqlite.org/ [5] http://www.sqlite.org/lang.html -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
