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/27 08/29 |
1. Introduction to DATA 520 | ||||||
1.1 Course outline | ||||||||
1.2 Databases to build | ||||||||
1.3 Software to be used | ||||||||
2 | 09/03 09/05 |
2. Programming Exercise I | ||||||
2.1 Specifications | ||||||||
2.2 A sample website | ||||||||
2.3 Construction steps | ||||||||
09/04 |
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/10 09/12 |
3. Essential Technologies for Exercise Construction | ||||||
3.1 HTML (Hypertext Markup Language) | ||||||||
3.2 CGI (Common Gateway Interface) | ||||||||
3.3 Using Oracle | ||||||||
4 | 09/17 09/19 |
4. Internet-Enabled Database Construction | ||||||
4.1 Technologies for website building | ||||||||
4.2 Website construction summary | ||||||||
4.3 An example | ||||||||
5 | 09/24 09/26 |
5. Oracle Databases | ||||||
5.1 Oracle Database 21c | ||||||||
5.2 Oracle SQL*Plus | ||||||||
5.3 Oracle data dictionary | ||||||||
6 | 10/01 10/03 |
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/10 | 7. JDBC Programming | ||||||
7.1 Database connection | ||||||||
7.2 Query execution | ||||||||
7.3 Processing the result sets | ||||||||
10/08 |
|
|||||||
8 | 10/15 10/17 |
8. Android Mobile Operating System | ||||||
8.1 Programming Exercise II | ||||||||
8.2 Downloading and installing Android Studio | ||||||||
8.3 Programming Android | ||||||||
9 | 10/22 10/24 |
9. An Android Hello-World Project | ||||||
9.1 Manifest file | ||||||||
9.2 Layout XML code | ||||||||
9.3 Layout XML code | ||||||||
10 | 10/29 10/31 |
10. Android User Interface Processing | ||||||
10.1 Hypertext | ||||||||
10.2 Radio buttons | ||||||||
10.3 Checkboxes | ||||||||
11 | 11/05 11/07 |
11. Android Server Connection | ||||||
11.1 Android URL connection | ||||||||
11.2 Java source code | ||||||||
11.3 Server-side scripts | ||||||||
12 | 11/12 11/14 |
12. Relational Model and Algebra | ||||||
12.1 Relational tables | ||||||||
12.2 Relational rules | ||||||||
12.3 Relational algebra | ||||||||
11/15 |
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 |
|||||||
13 | 11/21 | 13. SQL Query Language | ||||||
13.1 Introduction to SQL | ||||||||
13.2 Data definition commands | ||||||||
13.3 Data manipulation commands | ||||||||
11/19 |
|
|||||||
14 | 11/26 | 14. Database Design | ||||||
14.1 Basic modeling concepts | ||||||||
14.2 Entity-relationship (E-R) model | ||||||||
14.3 Transformation rules | ||||||||
11/27 11/28 11/29 |
|
|||||||
15 | 12/03 12/05 |
15. SQL Query Language (Cont.) | ||||||
15.1 Advanced data manipulation commands | ||||||||
15.2 SQL examples | ||||||||
15.3 Power of SQL | ||||||||
16 | 12/10 12/12 |
16. Database Design (Cont.) | ||||||
16.1 Normalization | ||||||||
16.2 Normal forms | ||||||||
16.3 A case study | ||||||||
17 | 12/17 |
|
||||||
18 | 12/24 | Grades posted before noon, Tuesday |
If it’s not one thing, it’s another. |