Editing Intro to SQL Databases

Jump to navigation Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.

Latest revision Your text
Line 1: Line 1:
This is a page for the noisebridge MySQL studygroup, we meet on Tuesdays at 4:30(16:30) in Turing classroom at Noisebridge, [[classrooms]].
This is a page for the SQL studygroup, on Tuesdays at 4:30 in Turing


In the spring of 2013 we will work as a study group for the free course, [http://db.class2go.stanford.edu Intro to Databases Class], being taught by Professor Jennifer Widom, head of the Computer Science at Stanford University.
This has morphed into a study group from a former Intro to MYSQL class


We will be ''rebooting'' Tuesday January 15, 2013 and running in synchronization with an Intro to Databases Class. The teacher of the former MySQL class at Noisebridge, Robert, will be part of the group and available for questions.


Read more about the course at [http://db.class2go.stanford.edu the course website].
WE will be 'rebooting' Tues 2012.01.15 and running in synchronization with an Intro to Databases Class being given free online by stanford university


Here is her intro to the course


I wanted to introduce you to a course coming this January,
Join me in the second public offering of my popular course, Introduction to Databases. In Fall 2011, tens of thousands of students joined Introduction to Databases when it was offered as one of Stanford's three inaugural MOOCs. If you missed it then, here's your chance to take the course, once again offered free to the public. Materials have been improved and expanded since the original offering, and the course will be hosted by Stanford's open-source online platform, Class2Go.
Why learn about databases? Databases are incredibly prevalent -- they underlie technology used by most people every day if not every hour. Databases reside behind a huge fraction of websites; they're a crucial component of telecommunications systems, banking systems, video games, and just about any other software system or electronic device that maintains some amount of persistent information. In addition to persistence, database systems provide a number of other properties that make them exceptionally useful and convenient: reliability, efficiency, scalability, concurrency control, data abstractions, and high-level query languages.
This ten-week public course covers database design and the use of database management systems for applications. It includes extensive coverage of the relational model, relational algebra, and SQL. It also covers XML data including DTDs and XML Schema for validation, and the query and transformation languages XPath, XQuery, and XSLT. The course includes database design in UML, and relational design principles based on dependencies and normal forms. Many additional key database topics from the design and application-building perspective are also covered: indexes, views, transactions, authorization, integrity constraints, triggers, on-line analytical processing (OLAP), JSON, and emerging NoSQL systems.
Working through the entire course provides comprehensive coverage of the field, but most of the topics are also well-suited for "a la carte" learning.
The course does not assume prior knowledge of any specific topics, however a solid computer science foundation -- a reasonable amount of programming, as well as knowledge of basic computer science theory -- will make the material more accessible.
Introduction to Databases begins January 15, 2013. Find out more and register here: [http://db.class2go.stanford.edu]
Sincerely,
Jennifer Widom
Professor and Department Chair
Stanford University
____________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________


In this group we sometimes work from the sakila and world databases, if you have MySQL installed you can see how to install the sakila database at this page <https://dev.mysql.com/doc/sakila/en/sakila-installation.html>
In this group we sometimes work from the sakila and world databases, if you have MySQL installed you can see how to install the sakila database at this page <https://dev.mysql.com/doc/sakila/en/sakila-installation.html>
The teacher of the former MYSQL class here @ NB Robert will be part of the group and available for questions...
Please note that all contributions to Noisebridge are considered to be released under the Creative Commons Attribution-NonCommercial-ShareAlike (see Noisebridge:Copyrights for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource. Do not submit copyrighted work without permission!

To protect the wiki against automated edit spam, we kindly ask you to solve the following CAPTCHA:

Cancel Editing help (opens in new window)