SQL Database Design in 11 minutes, part 1

CAPTIONS AVAILABLE - Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. I guess I see too many poorly designed databases ... This is a simple example to show you, in practice (no theory at all) the issues one can meet when designing a database. If you need a short but good book on the topic, I can recommend Clare Churcher's "Beginning Database Design" (Apress), for which I was the technical reviewer.

Category:

Education

Tags:

• SQL
• Database
• normalization
• normal
• form
• data
• design
• modeling
• modelling
• tutorial
• DBMS
• RDBMS
• relational
• beginner
• faroult
• roughsea

[militantmindset]

normally the primary key for a table is an extra column that is noramlly a NUMBER or ALPHANUMERIC type that is incremented by a certain rule when a new data row is inserted.

[roughsealtd]

@militantmindset

Often, but not necessarily. This is what one does to have a short key that needs to be referenced elsewhere and when the "natural key" is long (eg composed of several columns)

[jkolt89]

Thank you. I've watched and enjoyed all of your sql videos.

[longphi54]

Just got tha books database at bookdowner[dot]com

[mookjais]

The teaching style was very good and made a fairly difficult topic easy to understand, thanks a lot.

[flyboydale54]

I am watching your video now on SQL Database Design in 11 Minutes Part 1.  I find your teaching style very easy to follow, and I just want to say, I will be watching all of your series. I like how you keep it interesting and expand the thinking process building techniques. Thank you very much! This Relational Database Design course is fast paced and difficult to follow. I only have taken a basic introduction to Python Programing with no prior experience. I only have 2 weeks to complete it.

[nateaus]

Hey I have been looking for something like this to clarify basic database design!... nice!

And thanks!

[jonzart]

thanks, i've been looking for a basics lecture on database theory. awesome, simple, and well explained!