CSC230-3 2015: Database Technologies for Analytics

Section outline

• Select section General

  General

  Collapse all Expand all

  • Select activity News forum

    

    News forum
  • Select activity Syllabus for CSC230: Database Technologies for Analytics (PDF)

    

    Syllabus for CSC230: Database Technologies for Analytics (PDF) File
• Select section Week 1

  Week 1

  • Select activity Learning to make slides with Beamer

    

    Learning to make slides with Beamer File
  • Select activity SQL commands in a file (to build table of German and English words)

    

    SQL commands in a file (to build table of German and English words)
  • Select activity SQL commands in a file (to build a table of CS graduate schools)

    

    SQL commands in a file (to build a table of CS graduate schools)
• Select section Week 2

  Week 2

  • Select activity Emacs Reference Card (PDF)

    

    Emacs Reference Card (PDF) URL
  • Select activity Screen Reference Card (PDF)

    

    Screen Reference Card (PDF) URL

    Screen is a program that you can use on the www.eonsahead.com server to alternate between work with Postgresql and Emacs.
    

  • Select activity PostgreSQL Reference

    

    PostgreSQL Reference URL
  • Select activity Total Recall, by Gordon Bell (YouTube video)

    

    Total Recall, by Gordon Bell (YouTube video) URL
  • Select activity Python Database API reference

    

    Python Database API reference URL
• Select section Week 3

  Week 3

  • Select activity Column-oriented DBMS

    

    Column-oriented DBMS URL
  • Select activity Project and Presentations 2 and 3

    

    Project and Presentations 2 and 3 Page
  • Select activity Quiz 2 (PDF)

    

    Quiz 2 (PDF) File
  • Select activity Solution to tournament problem.

    

    Solution to tournament problem. Page

    I have placed my solution to the tournament problem in my fredbrooks account on our server. They are in a folder named 'tournament'. You can copy the files to your folder on the server using cp or to your own computer using scp. I will be happy to provide more detailed instructions if needed.

    
    

• Select section Week 4

  Week 4

  • Select activity Richard Plant's exercises with QGIS

    

    Richard Plant's exercises with QGIS URL
  • Select activity Directory of NoSQL database management systems.

    

    Directory of NoSQL database management systems. URL
  • Select activity Map of the United States

    

    Map of the United States File