On Jan 5, 6:40 pm, Petite Abeille <petite.abei...@gmail.com> wrote: > 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 > SQLhttp://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
Thank you for the advice Petite. I will check out those links also. -- 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.
