Database Systems Concepts & Design
Below are the top discussions from Reddit that mention this online Udacity course.
This course presents an example of applying a database application development methodology to a major real-world project.
Reddacity may receive an affiliate commission if you enroll in a paid course after using these buttons to visit Udacity. Thank you for using these buttons to support Reddacity.
Reddit Posts and Comments
0 posts • 4 mentions • top 3 shown below
1 points • wishfulthinkrz
Database Theory & Concepts (FREE) I would advise to check out this link, it really is a great resource and the best part is it’s free!
1 points • killwish1991
CS6400 from Georgia Tech's OMSCS will definitely help. Here are the free lecture videos. You can also use class text book for deeper understanding.
https://www.udacity.com/course/database-systems-concepts-design--ud150
1 points • RossumEcho
SQL is important to know, but getting certified in it is definitely overkill.
For SQL, I think knowing how to do these aspects would be more useful:
-
Designing a relational database - great for thinking about how to satisfy business requirements on a database, as well as thinking about the architecture your app would need.
-
Defining a schema, entering values, querying using JOIN (Inner Join, Natural Join), aggregates (SUM, COUNT), maybe sub query's (Although admittedly I don't use them a lot in real-life applications).
-
Querying a database to display on an application, then edit values, save to a database using a REST API
If you know how to do all these, you're pretty much set.
As for the course itself, the first module is very very basic. You can learn all that in 1-2 hrs max. In fact you probably already know how if you took the code academy one. it may help with #2, especially with joins, but I don't think it would help beyond that.
I just checked Udacity, and I think their Intro to Relational Databases may be more useful, as well as Database Systems concepts and designs - and both are free! The intro course also uses python which could be great to deepen your python knowledge.
If you really want paid though, this is just a glance at their course, but their Full Stack Web Developer Nanodegree doesn't sound too shabby. They use MVC architecture as well as python so it might be a good fit. It is a little bit more expensive though, so definitely start with the free ones. Also check Udemy to see if there are more affordable courses.