computer-science
computer-science copied to clipboard
ossu
RFC: Add Databases: Advanced Topics in SQL to curriculum.
Problem: The 3 databases courses in the curriculum are missing content related to foreign key / referential integrity constraints.
Duration: 1 Month.
Background:
Foreign key constraints are an important database topic that have not been covered in the 3 databases courses included in the course. The same teacher has another course called Databases: Advanced Topics in SQL that covers this topic.
Proposal: Add Databases: Advanced Topics in SQL to OSSU. This covers a few other topics as well and adds little overhead to the curriculum (only 2 weeks).
Alternatives:
- Find an alternative set of database courses.
The three current database courses are in Core Applications and all learners are encouraged to take those courses. In our curricular guidelines Foreign Key Constraints are an elective topic, part of "Information Management: Relational Databases". From that, Databases: Advanced Topics in SQL would most appropriately be added to an advanced section, (as all learners are encouraged to choose one or more advanced sections to focus upon). Identifying a set of courses that cover the breadth of Information Management elective topics would be helpful for students interested in learning more.
In that case we could also add some courses on JSON, XML etc. There's another database course in that series by Jeniffer Widom, but they are outdated (10ish years old, and most things have changed).
Do we have a policy againt udemy courses? They are paid but they are usually good and cover specific topics, so they can be used to fill holes in the curriculum.
On Thu, 29 Sep, 2022, 19:43 waciumawanjohi, @.***> wrote:
The three current database courses are in Core Applications and all learners are encouraged to take those courses. In our curricular guidelines https://www.acm.org/binaries/content/assets/education/cs2013_web_final.pdf#page=115 Foreign Key Constraints are an elective topic, part of "Information Management: Relational Databases". From that, Databases: Advanced Topics in SQL https://www.edx.org/course/advanced-topics-in-sql?index=product&queryID=70742b22d4d357721def93bb7b635c1f&position=4 would most appropriately be added to an advanced section, (as all learners are encouraged to choose one or more advanced sections to focus upon). Identifying a set of courses that cover the breadth of Information Management elective topics would be helpful for students interested in learning more.
— Reply to this email directly, view it on GitHub https://github.com/ossu/computer-science/issues/1077#issuecomment-1262346269, or unsubscribe https://github.com/notifications/unsubscribe-auth/AL6AMA7QR4XWUHVF2FJLRTLWAWPZPANCNFSM6AAAAAAQWE3HOQ . You are receiving this because you authored the thread.Message ID: @.***>
From the curriculum:
Courses must:
- Be open for enrollment
- Run regularly (ideally in self-paced format, otherwise running multiple times per year)
- Be of generally high quality in teaching materials and pedagogical principles
- Match the curricular standards of the CS 2013: Curriculum Guidelines for Undergraduate Degree Programs in Computer Science
followed by
All or nearly all course material is available for free. However, some courses may charge money for assignments/tests/projects to be graded.
Udemy courses generally lock lectures behind a paywall. Such courses are not eligible for inclusion in the curriculum.