5 ms·
Enrollment for Stanford's online DB class now open
- Kaedon 15y agoAwesome, thank you for posting this.
- grinnbearit 15y agoIt looks like the ML class is up too http://ml-class.org http://ml-class.org
- rosariom 15y agoThanks man this is an ultra cool subject!
- skymt 15y agoAs are the AI and ML classes. http://www.ai-class.com/ http://www.ai-class.com/ http://www.ml-class.org/ http://www.ml-class.org/
- beaumartinez 15y agoAs I got told in the email as I enrolled–"The class will run from October 10 to December 12".
- telemachos 15y agoYup, but also note this (from the home page, once you've logged in to the class): The class has not yet officially started, but in this pre-launch period, you can begin looking at the first week of content so that you can see what's coming and get a head start. Since there's already quite a lot of video uploaded (and three quizzes/assignments), I'm happy to get started early.
- beaumartinez 15y agoHm, I meant it more to indicate when it ended ;)—also, the option to view the lessons at 1.2x speed is a godsend.
- mkopinsky 15y agoYes, I am a huge fan of 1.2x speed. I find it easier to concentrate when the information is coming at me a little bit faster.
- burrokeet 15y agocool class even though I failed my EE qual session with Prof Widom :)
- nphase 15y agoCan I follow the advanced track at my own pace without being forced to participation? The advanced track of all of these classes seem to require participation, which I can't guarantee on their timeline right now.. (yay startup life!)
- yequalsx 15y agoI've tried searching for a list of Stanford's online open enrollment courses and haven't found anything. Is there a website that details their course offerings and a list of planned courses?
- eldina 15y agoIs it clear whether these open courses will be repeated in the future or if they are mainly tests before starting to charge ? It is wonderful that they are freely available but can it really be a permanent thing and what does Stanford gain ?
- rmnoon 15y agoI took this class from Prof. Widom at Stanford. It was...meh. Are SQL triggers still relevant? How much relational algebra do you really need to know? I think I've used this stuff maybe once since then.
- autarch 15y agoTo answer your questions ... 1. Yes, they are. They're very useful for certain things. For example, want to update your fulltext index in Postgres after certain table cells change or when new rows are inserted? You'll need to use a trigger. 2. Knowing more rather than less is probably a good thing. Understanding the underlying model of relational data will help you build SQL databases that make sense given the data you're working with. Of course, you won't use SQL in every project or job, but it's awfully useful. Ignore the hype that NoSQL is the wave of the future. It may be a wave of the future but so is SQL.
- lambada 15y agoAny idea why the AI class website looks so different to the ML and DB classes? It doesn't even use the same TLD, let alone have the same style.
- crag 15y agoI love the course. But I'll admit, the XML section; I was fighting to stay awake. And relational algebra? Com'on...
- jules 15y agoI watched the first 6 videos and I have to say it is a bit boring. It feels more like vocational education on using man made contraptions than a university course. I was hoping for a course on how databases work: indexing structures (B-trees, COLAs), query optimizers, transactions, column vs row storage, etc.
- amirmc 15y agoJust as a reminder for folks, there's a spreadsheet of HN readers who are taking part in the classes at http://bit.ly/pLCRzg http://bit.ly/pLCRzg There are 120+ HNers on there so you might find folks nearby you'd like to get in touch with. Edit: Obviously, if you're doing any of the courses feel free to add your details too
- mkopinsky 15y agoI have always known that the "right" way of presenting dates is as "2011-09-25 23:52" for the sake of sorting. This spreadsheet has prompted me to think that the "right" way of presenting locations is actually "USA, NY, New York[, Streetname 1234]" for the same reason.
- amirmc 15y agoI'm inclined to agree. It was unordered before but looks like someone sorted it by location.
- mkopinsky 15y agoThe problem with the new sorting is that it easily shows who's in the same city, but doesn't show who's in the same state. Yonkers, NY is not far from NYC, but is very far alphabetically.
- amirmc 15y agoI just realised that my previous post may have been a bit ambiguous. Just for completeness, what I meant was that the spreadsheet was previously unsorted (people would add their details at the bottom) and that someone came along and sorted it by location (presumably to make it easier for people to find each other). However, the sorting doesn't really solve the problem, as you correctly describe. I made a new column and started adding details in reverse (e.g USA, NY). Admittedly I got a little bored so I didn't do everyone. Re-sorting on that column (if it's ever completed) would solve your problem.
- pbh 15y agoTo answer a few of the database questions that keep popping up in this thread: 1. Is it worth understanding relational algebra? Yes. Definitely. It's not that hard, there's more or less a one-to-one mapping of relational algebra to SQL. Relational algebra is both a useful mathematical tool and indispensable when trying to understand query optimization. Relational algebra is also necessary to be able to read pretty much any of the database literature, if that's one of your goals. (Just be thankful you don't have to learn Relational Calculus or Datalog.) 2. Is it worth learning XML features like XML DTDs, XPath, XML Schema, and XQuery? Yes, definitely. I don't like XML, but there are tons of places where you can use XPath. (The most interesting thing about XQuery is probably how similar it is to SQL, though.) 3. Is it worth learning about SQL triggers? Probably. Ultimately, the web development world is split between people for whom separation of concerns means doing more in the database, and those for whom separation of concerns means doing less in the database. If you think doing validation and transactions in the database is sensible, triggers are also a sensible thing to learn about. However, people like DHH disagree and want validation in your app server with a dumber backend. 4. Is this vocational training? Well, this is the first in a three class sequence at Stanford. This class is mostly about schema and query languages, so in some sense, it's the most useful to practitioners (or at least, non-DBA practitioners). The second class is about systems and implementation (on-disk layout, indexing structures, query optimization). In the third class, students either learn about distributed databases or actually build their own from scratch. However, schema and query languages have enough theory behind them, and enough generality, that I wouldn't consider it any more vocational training than a class on compilers.
- dzlobin 15y agoDo you happen to know if the other two classes in this series will be available online as well?
- pbh 15y agoUnknown. However, the three classes are intended to match up with Database Systems: The Complete Book (which, in the interests of full disclosure, is written partly by my former advisor). If you want to learn the material from the second class, I would just read the book. I've actually read the book cover to cover, and I think it's one of the best textbooks for that purpose. There are tons of examples everywhere, it's pretty talkative, and there is very little pretension (insert Russell/Norvig complaint here). On the other hand, some portion of the Internet seems to take the opposite view (e.g., some people just view the talkativeness as repetition).
- LuxuryMode 15y agoI don't get how to read the answer choices for this question: <!DOCTYPE A [ <!ELEMENT A (B+, C)> <!ELEMENT B (#PCDATA)> <!ELEMENT C (B?, D)> <!ELEMENT D (#PCDATA)> ]> Which of the following sequences of opening and closing tags matches this DTD? Note: In actual XML, opening and closing tags would be enclosed in angle brackets, and some elements might have text subelements. This quiz focuses on the element sequencing and interleaving specified by the DTD. What does this mean for example? A B /B B /B C B /B D /D D /D /C /A
- mkopinsky 15y ago<A> <B> </B> <B> </B> etc.
- fallenlad 15y agoEnrolled in DB class, wish i could join AI too.
- HSO 15y agoPerhaps this is the place and occasion to ask this question: What's the advantage of taking this class over reading a good (text)book incl. exercises contained therein? I realize people have different learning styles and I'm just not the type who learns well from listening. Still, even though I hated going to classes in school and university, I'm tempted by these offerings (AI, ML, DB). Perhaps I'm just looking for an excuse. So, anyone here who can give some good reasons for why taking this course is better than (or adds to) a "mere" book?
- smackfu 15y agoThe XML quiz is quite annoying since it requires checking each answer against the DTD, but the DTD + answers are too big to fit on one screen even on a big monitor, so you keep needing to scroll back and forth.
- pbreit 15y agoLove that you can speed up the videos to 1.5x (in the Flash version). Don't love the Flash. Like that an HTML5 alternative is offered for iPads, etc.