Week |
Class | Topic | Due | Where | ||||
|---|---|---|---|---|---|---|---|---|
| 0 | 0. Computer Career and Data Research & Technologies | |||||||
| 0.1 A computer career | ||||||||
| 0.2 Data research | ||||||||
| 0.3 Data technologies | ||||||||
| 1 | 08/26 08/28 |
1. Introduction to CSCI 513 | ||||||
| 1.1 Course outline | ||||||||
| 1.2 Tentative schedule | ||||||||
| 1.3 Software to be used | ||||||||
| 2 | 09/02 09/04 |
2. Programming Exercise I | ||||||
| 2.1 Specifications | ||||||||
| 2.2 A sample website | ||||||||
| 2.3 Construction steps | ||||||||
| 09/03 |
Last day to add a course or drop without record — 100% refund Last day to add audit or change to/from audit Last day to receive a refund on a dropped class Drops after the last day to add will appear on a transcript. |
|||||||
| 3 | 09/09 09/11 |
3. Essential Technologies for Exercise Construction | ||||||
| 3.1 HTML (Hypertext Markup Language) | ||||||||
| 3.2 CGI (Common Gateway Interface) | ||||||||
| 3.3 Using Oracle | ||||||||
| 4 | 09/16 09/18 |
4. Database Models | ||||||
| 4.1 Relational databases | ||||||||
| 4.2 Object-oriented databases | ||||||||
| 4.3 Website construction summary | ||||||||
| 5 | 09/23 09/25 |
5. Oracle Databases | ||||||
| 5.1 Oracle SQL*Plus | ||||||||
| 5.2 Oracle data dictionary | ||||||||
| 5.3 SQL (Structured Query Langauge) | ||||||||
| 6 | 09/30 10/02 |
6. Web-JDBC Programming | ||||||
| 6.1 GET and POST methods | ||||||||
| 6.2 CGI forms and input fields | ||||||||
| 6.3 CGI radio buttons and checkboxes | ||||||||
| 7 | 10/09 | 7. JDBC Programming | ||||||
| 7.1 Database connection | ||||||||
| 7.2 Query execution | ||||||||
| 7.3 Processing the result sets | ||||||||
| 10/07 (no class) |
|
|||||||
| 8 | 10/14 10/16 |
8. Introduction to Android Programming | ||||||
| 8.1 Programming Exercise II | ||||||||
| 8.2 Android introduction | ||||||||
| 8.3 An Android hello-world project | ||||||||
| 9 | 10/21 10/23 |
9. Android User Interface Processing | ||||||
| 9.1 Hypertext | ||||||||
| 9.2 Radio buttons | ||||||||
| 9.3 Checkboxes | ||||||||
| 10 | 10/28 10/30 |
10. Android SQLite Database | ||||||
| 10.1 Using SQLite | ||||||||
| 10.2 SQLite shell commands | ||||||||
| 10.3 SQLite in Android | ||||||||
| 11 | 11/04 11/06 |
11. An Android SQLite Project | ||||||
| 11.1 SQLite data declaration | ||||||||
| 11.2 SQLite data management | ||||||||
| 11.3 An SQLite example | ||||||||
| 12 | 11/13 | 12. Oracle Object-relational SQL | ||||||
| 12.1 Object types, tables, and references | ||||||||
| 12.2 Constructor methods | ||||||||
| 12.3 Data dictionary and objects | ||||||||
| 11/14 |
Last day to change to or from S/U grading Last day to change to or from audit grading Last day to drop a full-term course or withdraw from school |
|||||||
| 11/11 |
|
|||||||
| 13 | 11/20 | 13. Oracle PL/SQL | ||||||
| 13.1 Control structures | ||||||||
| 13.2 Cursors | ||||||||
| 13.3 Procedures and functions | ||||||||
| 11/18 (no class) |
|
|||||||
| 14 | 11/25 | 14. Oracle Object-relational SQL (Cont.) | ||||||
| 14.1 Nested tables | ||||||||
14.2 VARRAY (varying-length array) |
||||||||
| 14.3 Methods | ||||||||
| 11/26 11/27 11/28 |
|
|||||||
| 15 | 12/02 12/04 |
15. Object-oriented DBMSs | ||||||
| 15.1 A non-relational representation | ||||||||
| 15.2 Object-oriented properties | ||||||||
| 15.3 Object-oriented database properties | ||||||||
| 16 | 12/09 12/11 |
16. Object-oriented DBMSs (Cont.) | ||||||
| 16.1 A DBMS classification matrix | ||||||||
| 16.2 Aspects of OODB languages | ||||||||
| 16.3 OODB language features | ||||||||
| 17 | 12/16 |
|
||||||
| 18 | 12/23 | Grades posted before noon, Tuesday |
| If it’s not one thing, it’s another. |