Profile

Hamish McWilliam profile image

Hamish McWilliam

Student

  • 7 reviews
  • 7 completed
Content 
Instructor 
Provider 
An excellent introduction to Computer Science concepts illustrated using the Python programming language. My only issue with this course is that the very high quality of the content and the teaching set the standard so high, that other courses appear much poorer than maybe they are.
Content 
Instructor 
Provider 
This first mini-course in the [Databases series](https://class.stanford.edu/courses/DB/2014/SelfPaced/about) from Stanford Online, focuses on introducing the concept of a Database Management System (DBMS) and the why a DBMS makes using a database easier. It then moves on to provide an overview of the relational data model and querying as used in Relational Database Managment Systems (RDBMS). While mentions of alternative data models and DBMS (e.g. XML, Hadoop, graph data) are made, this mini-course does not provide a overview of the alternatives to RDBMS. It would have been nice to have seen some discussion of these, in particular the various NoSQL technologies, as part of the introduction.
Content 
Instructor 
Provider 
An solid introduction to the basics of C# programming for experienced developers.
Content 
Instructor 
Provider 
An excellent introduction to the R programming language. While Try R concentrates on the use of R as an interactive calculator, this introduces the core R syntax and many of the basic functions. If you are thinking about taking an R programming course work through Try R first, so you have the basics already in place.
Content 
Instructor 
Provider 
This mini-course in the [Database series](https://class.stanford.edu/courses/DB/2014/SelfPaced/about) from Stanford Online looks at the use of the XPath and XQuery query languages for querying XML documents. The "XPath and XQuery" mini-course follows the introduction to XML in the "XML Data" mini-course. Through the use of examples based on documents seen in the earlier mini-course and typical queries against those documents the core syntax and some of the functions available in XPath and XQuery are introduced.
Content 
Instructor 
Provider 
This mini-course in the [Databases series](https://class.stanford.edu/courses/DB/2014/SelfPaced/about) from Stanford Online, introduces the use of the Unified Modeling Language (UML) for the creation of data models which can be translated by design tools into relational databases models for use with an RDBMS. This mini-course focuses solely on the use of UML for modelling data, and thus on the parts of UML that support data modelling. Through the use of examples the various constructs of data modelling diagrams are introduced and their specific implementations in UML illustrated. The translation of the data models created into corresponding SQL for use with a RDBMS is discussed and shown for the UML constructs which have been introduced. While the existence of UML tools which can produce SQL is mentioned, there is no mention of specific tools such as Rational Rose or ArgoUML which can perform this translation. Since UML covers many parts of the design process and the documentation of design, including aspects unrelated to data modelling, it would be better if this course had a title that reflected that it only covers the use of UML for data design.
Content 
Instructor 
Provider 
This mini-course in the [Databases series](https://class.stanford.edu/courses/DB/2014/SelfPaced/about) from Stanford Online, looks at the use of the Structured Query Language (SQL) by Relational Database Management Systems (RDBMS) using a set of example databases and a series of common query scenarios. The availability of the example databases and the suggested use of the free and open source SQLite, MySQL or PostgreSQL RDBMS, allows for experimentation with the databases, which makes it easier to look at alternative forms of queries used in the videos. As well as being useful when doing the various exercises. The SQL mini-course builds on the earlier mini-courses in the series ("Introduction and Relational Databases" and "Relational Algebra") to build practical skills around the use of relational databases. However some of topics are split out in separate courses, which might benefit from some basic coverage here, in particular the use of transactions in SQL.