Database Design: Spring 2014

Instructor:

Vedat G. Diker

School:

iSchool at Maryland

Semester:

Spring 2014

Description:

This course focuses on approaches to and methods for designing relational databases. After almost half a century of development, and challenges from various competing paradigms, relational databases remain to be the industry standard for data persistence. A high-quality relational database can help leverage an organization’s data and information assets for better fulfillment of its mission. On the other hand, a poor, problem-ridden database can complicate even the simplest data-driven functions within the organization. There are various factors that determine the quality of a relational database. An indispensible prerequisite for establishing a high-quality database is a robust design. This course covers principles and methods for logical and physical database design, as well as SQL, a language for maintaining relational databases and managing data held in relational databases.

Required Textbook:

Fehily, C. 2008. SQL: Visual QuickStart Guide, 3rd ed.

Link to Syllabus:

http://ischool.umd.edu/sites/default/files/syllabi/inst733_syllabus_spring_2014_v01_2014-01-26.pdf

Database Design and Development: Spring 2013

Instructor:

Ted Borys

School:

University at Albany

Semester:

Spring 2013

Description:

Database principles for microcomputers, with an emphasis on relational database management systems (DBMS) for applications development in the library and information fields. Database design, creation, and maintenance; the user interface; programming concepts. Creation of a working database system.

Required Textbook:

No required textbook.

Link to Syllabus:

http://www.albany.edu/informationstudies/files/SP13_IST658_Borys.pdf

Database Content Evaluation: Fall 2012

Instructor:

Peter Jacso

School:

University of Hawaii

Semester:

Fall 2012

Description:

To study the objectives, principles and methods of evaluating digital information sources (especially databases), for advising users in selecting databases and Web sites most appropriate for their information needs, and for making database licensing decisions.

Required Textbook:

Jacsó, P. 2001. Content Evaluation of Textual CD-ROM and Web Databases.

Link to Syllabus:

http://www.hawaii.edu/lis/content/syllabi/675_jacso_f12.doc

Database Design & Creation: Spring 2014

Instructor:

Luz M. Quiroga

School:

University of Hawaii

Semester:

Spring 2014

Description:

Behind most computerized information system there is a backend database; the performance of the system depends of how well designed the database is; understanding how a database is structured will give you knowledge to present diagrams (ER diagrams) with specifications of the data, metadata, standards, relationships, queries and reports needed.

Structuring information is the purpose of the semantic web project, one of the most important works for the future web. This project is being conducted by the inventor of the web, Tim Berners-Lee, as a way to bring order and improve finding information in the web. You will be aware of how many of the ideas in this project seem to be expansion of LIS principles for cataloging, indexing, and retrieval, applied to organization of any kind of information (e.g. booking flights, shopping, administration, health, entertainment, education, etc.)

Required Textbook:

Connolly, T., Begg, C. 2010. Database systems: a practical approach to design, implementation and management, 5th ed.

Link to Syllabus:

http://www2.hawaii.edu/~lquiroga/courses/lis674/lis674.htm

Advanced Database Searching: Spring 2012

Instructor:

Peter Jacso

School:

University of Hawaii

Semester:

Spring 2012

Description:

Lecture course with demonstrations of advanced features of online information retrieval systems and search engines, including natural language searching, citation-based searching, term mapping, similarity searching, result ranking and clustering for power search Web databases.

Required Textbook:

No required textbook.

Link to Syllabus:

http://www.hawaii.edu/lis/content/syllabi/667_jacso_s12.pdf

Web Tools and Development: Spring 2013

Instructor:

Morgan Doocy

School:

University of Washington

Semester:

Spring 2013

Description:

The goal of this course is to familiarize students with server-side web programming languages and technologies, complex website architecture and infrastructure, and the construction of data-driven web sites and services.

Required Textbook:

No required textbook.

Link to Syllabus:

http://courses.washington.edu/info344/#!/syllabus/

Database Management and Information Retrieval: Spring 2006

Instructor:

David Hendry

School:

University of Washington

Semester:

Spring 2006

Description:

Theories and models in system-centered approaches to information retrieval and database management. Information retrieval and database management systems include text and multimedia databases, web search engines and digital libraries. Issues in system design, development and evaluation, and tools for searching, retrieval, user interfaces, and usability.

Required Textbook:

Connolly, T. M., Begg, C. E. 200). Database Systems: A Practical Approach to Design, Implementation, and Management, 4th ed.
Belew, R. K. 2001. Finding Out About: A Cognitive Perspective on Search Engine Technology and the WWW.

Link to Syllabus:

http://courses.washington.edu/info340/docs/info340sp06_syllabus.pdf

Database Design & Development: Winter 2014

Instructor:

Charles-Antoine Julien

School:

McGill

Semester:

Winter 2014

Description:

Theoretical and applied principles of relational database design. Includes relational theory, conceptual design, database normalization, relational database management systems, SQL queries and database management.

Required Textbook:

Frost, R., Day, J. Van Slyke, C. 2006. Database design and development. A visual approach.
Riordan, R. 2005. Designing effective database systems.

Link to Syllabus:

http://www.mcgill.ca/sis/files/sis/glis657_winter2014_julien.pdf

Information Retrieval: Fall 2014

Instructor:

Charles-Antoine Julien

School:

McGill

Semester:

Fall 2014

Description:

Theoretical and applied explanation of information retrieval in a variety of digital environments and in relation to textual and multimedia data.

Required Textbook:

Walkenbach, J. 2010. Excel 2010 power programming with VBA.
Manning, C. D., Raghavan, P., Schütze, H. 2008. Introduction to information retrieval.

Link to Syllabus:

http://www.mcgill.ca/sis/files/sis/glis616_2014fall_julien.pdf

Management of Electronic Resources and Services: Fall 2012

Instructor:

Yunseon Choi

School:

Southern Connecticut

Semester:

Fall 2012

Description:

Management and operation of electronic information resources and services in library and information centers. Selection and integrating system options; finance and budget; staff and end-user training; search strategies; database publishing and vendors; hardware/software; measurement/evaluation and future planning.

Required Textbook:

Yu, H., Breivold, S. 2008. Electronic Resource Management in Libraries: Research and Practice.

Link to Syllabus:

http://ares.southernct.edu//ils/uploads/textWidget/wysiwyg/documents/ILS642_Couse_outline.pdf