Weekly Course Schedule – Summer 2018

IS 490 - DBO (Meets Thursday Evenings Online)

Index | Previous | Next

Week 2 (May 20 – May 26)



Tuesday, May 22   (6:30 P.M. – 7:30 P.M., Our normal Blackboard Collaborate Ultra classroom)
Optional Session
Online Lab Session
Every Tuesday evening, we will have an optional Online Lab Session using the Blackboard Collaborate Ultra platform. These sessions are a great opportunity to get help with your coding assignments or with your final project. Lab Sessions will take place in our normal Blackboard Collaborate Ultra classroom. Please use a headset.


Thursday, May 24   (6:30 P.M. – 9:00 P.M., Blackboard Collaborate Ultra)
Class Session 2
Topics
  • Installing the MySQL software
  • An introduction to relational databases and SQL
  • How to use MySQL Workbench and other development tools
  • How to retrieve data from a single table
Computing Setup
  • Don't Fall Down in Front of the Monster!!!!!
    Description: The database installation activity that follows has already proved troublesome for some students. Apparently, those of us who have installed Version 8 of the MySQL Server are having problems when running the scripts that load the databases used during class and for your coding assignments. In their orignal state, these scripts contain statements for creating users, granting permissions, and setting passwords. Unfortunately, changes in Version 8 have caused these statements to break. Fortunately for us, we don't rely on any of these features in our class. So, I have created a revised version of the database setup files in which the problem statements have been turned into harmless comments. If you are using MySQL Server Version 8, you will need to use the revised database setup files that I have provided below rather than the version that you download from the publisher's site for the text book. Please make this change before you run your database setup. Otherwise, you will have fallen down in front of the monster.
  • Install MySQL Server Community Edition and MySQL Workbench
    Description: Please install MySQL Server Community Edition and MySQL Workbench on your computer. Instructions can be found in Murach Appendix A and B. See the tutorial videos (below) for more help.
Required Readings
  • Murach Chapter 1
  • Murach Chapter 2
  • Murach Chapter 3
Required Recordings
Other Resources