Stanford Fall 2011 - Introduction to Databases

by redouane • 15 years ago

387 44 15 years ago

Stwerner• 15 years ago

All of these online Stanford classes seem very cool. I hope that enough people sign up for these that grading and certificates become more popular from all of the highly respected schools.

tilltheis• 15 years ago

It's not only Databases but Machine Learning and AI as well. I'm really looking forward to these Stanford classes and hope to take them successfully while doing my actual studies.

Direct links:

- Databases: http://www.db-class.org/

- Machine Learning: http://www.ml-class.org/

- Artificial Intelligence: http://www.ai-class.com/

chedigitz• 15 years ago

Thanks for posting the other two course. I can't wait till October. The Machine Learning course has a great a playlist on youtube as well.

http://www.youtube.com/watch?v=UzxYlbK2c7E&playnext=1...

dman• 15 years ago

Winter just got interesting!

seagaia• 15 years ago

I wonder how the assignments will work? Will they all be automated grading (based on some sort of validated output?) If the users gets to thousands, hand-grading is out of the question...

whereareyou• 15 years ago

Assignments and exams in the public course will be similar to the Stanford ones and they will be scored automatically. 1:23 in on the intro video.

keiferski• 15 years ago

Any word on whether the course materials will be available in the future, or if the course itself will be offered in the future?

younata2• 15 years ago

I'd love to sign up for both this and the ml class (though, I think I will sign up for the ml class...).

However, I've already committed to the AI class, and in addition to my regular coursework (Entering second year of uni, go me!), I don't think I'll be able to handle this.

webspiderus2• 15 years ago

for what it's worth, if you take the ML class, you will learn most of the things you would learn in the AI class and more - although it does get a bit rigorous, and will take more time than the AI class would.

younata2• 15 years ago

Thanks. I looked through the ML class stuff, and I'm sold. Really looking forward to it.

emiranda• 15 years ago

Anyone know if there are any prerequisites for the class? Would someone with programming knowledge but no database knowledge be able to take this class?

badwetter• 15 years ago

Well it says "Introduction" so I assume that little to no knowledge are required in database programming.

teamlaft• 15 years ago

I just signed up and have some programming knowledge but practically no database knowledge. From reading the description and looking at the syllabus, I don't think any coding knowledge is required. I do think though that this is critical for learning to code because you're always going to be dealing with db's in some form or another, so I'm excited.

mrmaddog• 15 years ago

This was one of my favorite CS classes I took at Stanford. It will do a great job teaching you the theory behind dbs then bridge that theory with real-world examples. If you want to get an idea about how databases operate behind the scenes AND how they should be properly used, this is a great class for you.

The relational algebra sections of the course are intriguing because it forces you to solve problems using a set of constraints that aren't present in other programming languages—really interesting stuff.

More information is at the class website http://infolab.stanford.edu/~widom/cs145/index.html

ericfrenkiel• 15 years ago

MemSQL will be hosting office hours during the Winter for the class. If you'd like to attend, send an email to db-class@memsql.com.

jergason• 15 years ago

That was a great way to make me google MemSQL. Are you guys affiliated with the course at all, or just being helpful and doing marketing at the same time?

jc123• 15 years ago

A quick look through the syllabus shows that the last video is "NoSQL Systems". Nothing specific in the Course Materials though. Maybe an Intro to Databases class should talk a little more about other approaches such as document-oriented databases. I know they (academia) are sticking to classical CS, but maybe some parts of relational databases could be covered in a second class on databases, to make room for more exploration on other DB approaches in an intro class.

officemonkey2• 15 years ago

The video states that the course will be RDBMS-centric, but there will be forays into XML data.

farnsworth• 15 years ago

This is great- I'm taking Into to Databases and AI at my university this semester, and I'm sure working the Stanford courses alongside those will give me some awesome perspective.

toot• 15 years ago

Even though I usually scoff at pre-registration signup forms, I was very excited to fill this one in.

I'm sure there's a lesson to be learned about my own sampling bias and it might be time to rethink this stance (how ever hard it may be to recognise that people can actually find enjoyment in hearing about product launches and events!)

sktrdie• 15 years ago

How is one single teacher going to deal with thousands of students?

acangiano• 15 years ago

Videos + Automated grading.

swah2• 15 years ago

Its not like we're each getting attention from the teacher. Probably more like a series of lectures in a big hall. :)

eazolan• 15 years ago

Why can't one single teacher deal with millions of students?

Or are you stuck on the system you grew up with, unable to imagine any improvements?

nicklovescode• 15 years ago

billions

Indyan• 15 years ago

Do I have to attend the classes "live"? Or can I catch up according to my schedule, as long as I submit the assignments on time?

vimalg2• 15 years ago

Does anyone know the answer to this?

Essentially, I'd like to know if i should continue waking up with the US East Coast or finally join the regular morning people in India.

officemonkey2• 15 years ago

The video on the website indicates that the course lectures will be delivered by video, so I'm assuming that timeshifting will not be a problem.

swah2• 15 years ago

Now if only they had OS and Compilers :)

MaxGabriel2• 15 years ago

Can anyone offer some advice in choosing between the three courses?

My background: I've only completed CS 1, and read LPTHW and Kochan's Objective-C book. I have about an hour's worth of Khan Academy videos in linear algebra, and have taken a basic prob/stats course. My university offers a database class, but not ML or AI. Based on my minimal knowledge of the subjects, ML/AI sound more interesting than databases.

SkyMarshal3• 15 years ago

You're more likely to need and use the DB course topics earlier in your career, unless you specifically get a job in ML or AI. However, those topics are also easier to learn and understand on your own without guidance. If you post your school's db course curriculum, we can help you compare it with the Stanford one. Initial instinct - go with the ai or ml course (or take a reduced course load this fall and take both, then see if you can get the Stanford completion certificate to transfer as credits to your school).

weezer• 15 years ago

I did my PhD at Stanford and took all three classes. DB is a more fundamental class, and probably easier. AI and ML are both great but they are designed to be taken in sequence with AI first then ML (which is a sub-field of AI).

jules• 15 years ago

Am I understanding correctly that this course is more about how to use databases than how they work and how to implement them?

SkyMarshal3• 15 years ago

Looks that way from the curriculum. That was my first thought as well.

inrev• 15 years ago

This is the undergraduate DB class. You are probably looking for the graduate DB class: http://infolab.stanford.edu/~widom/cs346/

exit• 15 years ago

why aren't these on stanford.edu subdomains?

jturn• 15 years ago

Maybe to emphasize that you are not getting credit?

brosephius• 15 years ago

anybody know if it's inappropriate to sign up to be able to watch the lectures and check out the homework, but not actually intend to submit all the assignments? it's not clear if the course materials will be accessible without being officially "enrolled". I want to check it out at my own pace but I can't guarantee I'll have the free time each week for the assignments.

mrcharles• 15 years ago

There's no cost to failing, I assume. Sign up and don't do the work, you won't be the first student to ever do so.

AdamTReineke• 15 years ago

For the AI class, they had tweeted that they were looking into the possibility of letting people audit the class.[1]

[1] https://twitter.com/#!/aiclass/status/97508929893965825

corey• 15 years ago

The videos are already online if anybody would like to get a head start.

http://infolab.stanford.edu/~widom/cs145/index.html (Click on "OpenClassroom Videos")

Stanford Fall 2011 - Introduction to Databases

Related Stories