Course Resources

CS 3140
Database Systems

SQLite

• SQLite home page
• SQLite command-line tool -- and dot commands

Online Runestone Textbook

If this is your first time using Runestone or one of its textbooks, create an account using the instructions under First-Time Registration. If you already have an account at Runestone because you have used one of its textbooks before, enroll in this course using the instructions under Add an Additional Course.

First-Time Registration

1. Open the following URL in another tab:
   https://runestone.academy/runestone/default/user/register .
2. Enter your information in the first set of Runestone Registration fields.
3. In the Course Name field, enter the name of our course: uni-cs3140-2020 .
4. Read the privacy policy and check "I Agree".
5. Do not check "Create Course".
6. Click "Sign Up".

Add an Additional Course

1. Open the following URL in another tab:
   https://runestone.academy/ .
2. Login using your credentials.
3. Click on the person icon in the upper righthand corner and select "Change Course".
4. Click on the "Enroll in a Course" button.
5. In the Course Name field, enter the name of our course: uni-cs3140-2020 . Don't change any other fields.
6. Click "Apply changes".

If you have any troubles enrolling in the course, let me know.

The student.cs Server

The department student server, student.cs.uni.edu, provides SQLite and a number of other tools we will use this semester. You can log in to it using your CatID. If you have never worked with Unix before or are having difficulty with these instructions, let me know. We can work through the steps together.

• How to access the server...
  
  
  • ... from Linux: Open a shell and enter the command ssh username@student.cs.uni.edu
  
  
  • ... from Mac OS X: Terminal is the Mac app that acts as a Unix shell. Open Terminal and enter the command ssh username@student.cs.uni.edu
    In Finder, you can find Terminal by clicking on the "Go" menu in the title bar, selecting "Utilities" near the bottom of the drop-down menu, and double-clicking on the Terminal app icon in the window that opens.
  
  
  • ... from Windows: In the CS labs, Windows machines come with the program PuTTY installed. Use the Start menu to find and launch PuTTY. Enter the server name student.cs.uni.edu in the dialog box that opens up. Follow the instructions that come next to log in.


• How to copy a file from the server to your computer...
  
  
  • ... on Linux and Mac OS X: Open a shell and enter the command
    scp   username@student.cs.uni.edu:path/to/filename   path/to/destination/
    Replace the italicized bits with your username and the path to the directory where you'd like to store the file. To copy the file to your current directory, use a period.
  
  
  • ... on Windows: In the CS labs, Windows machines come with the program WinSCP installed. There is an alias to it on the desktop. You can also access it through the Start menu.


• How to copy a file from your computer to the server...
  
  
  • ... on Linux and Mac OS X: You can use the scp command with the arguments reversed:
    scp   path/to/file   username@student.cs.uni.edu:
  
  
  • ... on Windows: You can use the same WinSCP program to copy files in reverse.

Support

• The Counseling Center.    The Counseling Center provides a variety of services to UNI students ins support of their wellness and mental health. Paying attention to our health becomes even more important in times of upheaval, such as that wrought by COVID-19. For information, visit the Counseling Center website.
  
  If you ever want or need to talk to someone, feel free to contact me. I am not a trained professional, but I can listen and can help you find the resources you need.


• The Learning Center.    The Learning Center (TLC) provides a tutor for the Computer Science core courses, as well as free assistance with writing, math, science, learning and study strategies. This year, the CS tutor is Josh Musgrave. He is available every Tuesday and Thursday 10:00 AM- 2:00 PM in Rod Library and can also do appointments over Zoom, if you prefer. To schedule an appointment, visit the TLC website. Josh is listed under Academic Coach/Specialty.
  
  More generally, TLC is open from 10:00 AM to 10:00 PM Monday through Thursday. For more information, email TheLearningCenter@uni.edu, call 319-273-6023, or visit the TLC desk located on the main floor of Rod Library.