Harvard Extension School
CSCI E-12 Fundamentals of Web Site Development | Fall 2019

## FAS Course Data

### Data Table

Course data for Faculty of Arts & Sciences is in a mysql database on cscie12students (username: class; database name: coursecatalog)

SQL:

    describe courses

Terminal:

    cscie12students$ mysql -u class coursecatalog
    Welcome to the MySQL monitor.  Commands end with ; or \g.

    mysql> describe courses;
    +------------------------------+--------------+------+-----+---------+-------+
    | Field                        | Type         | Null | Key | Default | Extra |
    +------------------------------+--------------+------+-----+---------+-------+
    | acad_year                    | year(4)      | YES  |     | NULL    |       |
    | cat_num                      | int(9)       | YES  |     | NULL    |       |
    | offered                      | char(1)      | YES  |     | NULL    |       |
    | department_code              | varchar(15)  | YES  |     | NULL    |       |
    | department_short             | varchar(80)  | YES  |     | NULL    |       |
    | department_long              | varchar(200) | YES  |     | NULL    |       |
    | course_group_code            | varchar(10)  | YES  |     | NULL    |       |
    | course_group_long            | varchar(200) | YES  |     | NULL    |       |
    | num_int                      | int(9)       | YES  |     | NULL    |       |
    | num_char                     | varchar(15)  | YES  |     | NULL    |       |
    | term_pattern_code            | int(5)       | YES  |     | NULL    |       |
    | fall_term                    | char(1)      | YES  |     | NULL    |       |
    | spring_term                  | char(1)      | YES  |     | NULL    |       |
    | term                         | varchar(100) | YES  |     | NULL    |       |
    | title                        | text         | YES  |     | NULL    |       |
    | course_type                  | varchar(100) | YES  |     | NULL    |       |
    | course_level_code            | char(1)      | YES  |     | NULL    |       |
    | course_level                 | varchar(200) | YES  |     | NULL    |       |
    | credit_code                  | int(5)       | YES  |     | NULL    |       |
    | credit                       | varchar(50)  | YES  |     | NULL    |       |
    | instructor_approval_required | char(1)      | YES  |     | NULL    |       |
    | meeting_time                 | text         | YES  |     | NULL    |       |
    | faculty_text                 | text         | YES  |     | NULL    |       |
    | description                  | text         | YES  |     | NULL    |       |
    | prerequisites                | text         | YES  |     | NULL    |       |
    | notes                        | text         | YES  |     | NULL    |       |
    +------------------------------+--------------+------+-----+---------+-------+
    26 rows in set (0.00 sec)

### SQL

SQL:

    select distinct department_short from courses

Terminal:

    mysql> select distinct department_short from courses;
    +----------------------------------------------------------+
    | department_short                                         |
    +----------------------------------------------------------+
    | African and African American Studies                     |
    | American Studies                                         |
    | Anthropology                                             |
    | Architecture, Landscape Architecture, and Urban Planning |
    | Asian Studies Programs                                   |
    | Astronomy                                                |
    | Biological Sciences in Dental Medicine                   |
    | Biological Sciences in Public Health                     |
    | Biophysics                                               |
    | Biostatistics                                            |
    | Celtic Languages and Literatures                         |
    | Chemical Biology                                         |
    | Chemical and Physical Biology                            |
    | Chemistry and Chemical Biology                           |
    | Comparative Literature                                   |
    | Dramatic Arts                                            |
    | Earth and Planetary Sciences                             |
    | East Asian Languages and Civilizations                   |
    | Economics                                                |
    | Engineering and Applied Sciences                         |
    | English                                                  |
    | Environmental Science and Public Policy                  |
    | Expository Writing                                       |
    | Folklore and Mythology                                   |
    | Freshman Seminars                                        |
    | General Education                                        |
    | Germanic Languages and Literatures                       |
    | Global Health and Health Policy                          |
    | Government                                               |
    | Health Policy                                            |
    | History                                                  |
    | History and Literature                                   |
    | History of Art and Architecture                          |
    | History of Science                                       |
    | House Seminars                                           |
    | Human Evolutionary Biology                               |
    | Humanities                                               |
    | Life Sciences                                            |
    | Linguistics                                              |
    | Mathematics                                              |
    | Medical Sciences                                         |
    | Medieval Studies                                         |
    | Middle Eastern Studies                                   |
    | Mind, Brain, and Behavior                                |
    | Molecular and Cellular Biology                           |
    | Music                                                    |
    | Near Eastern Languages and Civilizations                 |
    | Neurobiology                                             |
    | No Department                                            |
    | Organismic and Evolutionary Biology                      |
    | Philosophy                                               |
    | Physical Sciences                                        |
    | Physics                                                  |
    | Psychology                                               |
    | Regional Studies - East Asia                             |
    | Romance Languages and Literatures                        |
    | Russia, Eastern Europe, and Central Asia                 |
    | Slavic Languages and Literatures                         |
    | Social Policy                                            |
    | Social Studies                                           |
    | Sociology                                                |
    | South Asian Studies                                      |
    | Special Concentrations                                   |
    | Statistics                                               |
    | Stem Cell and Regenerative Biology                       |
    | Studies of Women, Gender, and Sexuality                  |
    | Systems Biology                                          |
    | The Classics                                             |
    | The Study of Religion                                    |
    | Ukrainian Studies                                        |
    | Visual and Environmental Studies                         |
    +----------------------------------------------------------+
    71 rows in set (0.01 sec)

Copyright © David Heitmeyer