|Tackle CMU's Intro To Database Systems For Free|
|Written by Nikos Vaggalis|
|Tuesday, 11 October 2022|
Carnegie Mellon is one of the top universities for computer science and offers a wide selection of database courses. Its 15-445/645 Intro To Database Systems is a project-oriented course that provides an introduction to the internal architecture of database systems. Here's the opportunity to watch its recorded lectures of fall 2021 complete with homework - for FREE.
Working with databases is not just about SQL and this course goes through all the underlying infrastructure that allows us to use SQL. That is, it's a complete course on the design and implementation of database management systems, with query languages (SQL, stored procedures) being one part of the following topics being taught:
The course is normally taught by Professor Andy Pavlov, but because he was shooting a Netflix documentary at the time, the job was left to his fellow colleagues Lin Ma and Andrew Crotty.
In "OtterTune AutoTweaks Your DBMS With Help From ML" I looked into Dr Pavlov's other endeavor of OtterTune, a tool powered by self-driving DBMS technology out of R&D at Carnegie Mellon University that aims to alleviate the fundamental difficulties of tuning a DBMS. State of the art technologies.
As such it doesn't come as a surprise that under Dr Pavlov's supervision, the CMU 15-445/645 Intro To Database Systems is state of the art educational material too. Caveat again, this course is not about building applications that work with databases but it's about building the infrastructure that these apps work upon. Specifically it's about the design and implementation of database management systems, the software that manages databases. It's not about using a dbms to build applications like for example a web application that stores its data and interacts with a database, nor is this a class about administering a database system. This however does not mean that SQL is not being taught.With this in mind let's take a look at the syllabus:
01 - Course Introduction & Relational Model
The videos of the recorded lectures are available on Youtube and span over an hour in length, while the accompanying homework with its solutions can be found on the class's University site. There's also some projects which require you to be familiar with programming and debugging in C++. Of course these were asked to be handed in by the CMU students taking the class and were graded. For the rest of us who are being granted free access to the materials there's no such requirements of course but it would be beneficial to try them ourselves in order to immense into the depths of the course.
Upon successful completion , students should be able to:
Really intriguing material.
or email your comment to: email@example.com
|Last Updated ( Wednesday, 12 October 2022 )|