CSC 455 Lecture Slides

1. Chapter 1
2. Chapter 2
   • Instructions for using the relational algebra interpreter
   • Zip file containing text files corresponding to the relations referenced in the university database in chapter 2. Download and unzip.
   • Example queries
3. Chapter 3
   1. MySql
      • MySql primer
      • MySql reference manual
      • mysql command line reference. 
      • a MySql tutorial
   2. Unix-related
      • Basic unix commands
      • Short tutorial for the vi editor
   3. University Database example from the book
      • Text files for creating and populating the example university database. Download these files to satoshi and execute the command source filename
      • Download instructions - follow these instructions to download and execute the files listed below
      • Create database file
      • Populate database - small file - has fewer lines of data
        
      • Populate database - large file - has more data
      • Some query exercises
        
      • Exercise 3.1
      • emp_super example
        
   4. SQLite
      1. sqlite
      2. Appropriate uses for SQLite
      3. SQLite quickstart
      4. Python and sqlite
      5. Example illustrating use of Python and SQLite
      6. university database for sqlite
4. Chapter 4
   1. Some join examples
   2. Foreign key examples
   1. Foreign key examples   using INNODB tables
   2. Person example
      
   3. Transactions in MySql
   4. Unique constraints in MySql
   5. Table creation
   6. On indices, another example
      
5. Chapter 5
   
   1. Java and JDBC
      1. JDBC Basics
      2. A mini-tutorial on JDBC/MySql
      3. JDBC Example Instructions
      4. xkcd sql injection
      5. Reading/Writing blobs Java example ,  code to create corresponding table 
   2. Python/Flask-related
   1. Some tutorials
      
   3. SQL-related
      1. Stored function - example - syntax tested on MySql
      2. Stored procedure - example - syntax tested on MySql
      3. Triggers - syntax tested on MySql
         
         1. Simple trigger example
         2. A second trigger example
         3. And a third example
            
      4. Recursive view example
6. Chapter 6
   1. E-R Modeling Exercises
   2. ex_movies, ex_mailOrder
   3. ex_0, ex_1, ex_2, ex_sports
   4. Auto body shop
7. Chapter 7, Normalization
   1. Normalization example exercises
   2. More examples
   3. Still more examples
   4. When not to normalize
8. Chapter 9
   1. PHP
      1. hello.php.txt, hello.php
      2. Guide to using resources on satoshi
         
      3. Example Database App, table referenced in example
         
9. Chapter 10
10. Chapter 11
11. Chapter 12
12. Chapter 13
13. Chapter 14