C.S. 340.001                                                        Spring 2015
Tue & Thu 11:00-12:15                                            Journalism 200

                              Semester Calendar


Week       Topic/Activity                                               Chapter
----       --------------------------------------------------------------------
   1       Orientation and introduction to database management              #
           Software installation and configuration(PHP and MySQL)              

   2       Overview of database development,                                1
           Introduction to Relational databases and                         2
               Structured Query Language(SQL)

   3       SQL querys and table updating                               3,7,19
           
   4       SQL querys ...                                                 4-6   

   5       Table Updating                                                   7
   
   6       Data types and Functions                                       8,9
           
   7       Database design                                                 10
   
   8       Creating indexes and Views                                   11-12

   9       Spring break: March 16..20
       
  10       Stored programs                                                 13
           Transactions and locking                                        14
           
  11       Stored procedures and functions                                 15
           Triggers and events                                             16
    
  12       MySQL and PHP                                                    #

  13       HTML Forms                                                       #

  14       Database web applications                                       #
  
  15       Database administration                                        17                                                   
            
  16       Database security and backup                                18-19                          

  17       Final exam(Tue 12 May, 10:30am)                             
           over class exercises and programming examples
           
           # supplementary materials
           * continues for most of the semester