This course will expand upon SQL as well as other advanced topics, including query optimization, concurrency, data warehouses, object-oriented extensions, and XML. Additional topics covered in this course will help you become more proficient in writing queries and will expand your knowledge base so that you have a better understanding of the field. Upon successful completion of this course, the student will be able to: write complex queries, including full outer joins, self-joins, sub queries, and set theoretic queries; write stored procedures and triggers; apply the principles of query optimization to a database schema; explain the various types of locking mechanisms utilized within database management systems; explain the different types of database failures as well as the methods used to recover from these failures; design queries against a distributed database management system; perform queries against database designed with object-relational extensions; develop and query XML files. (Computer Science 410)

" This course teaches the design of contemporary information systems for biological and medical data. Examples are chosen from biology and medicine to illustrate complete life cycle information systems, beginning with data acquisition, following to data storage and finally to retrieval and analysis. Design of appropriate databases, client-server strategies, data interchange protocols, and computational modeling architectures. Students are expected to have some familiarity with scientific application software and a basic understanding of at least one contemporary programming language (e.g. C, C++, Java, Lisp, Perl, Python). A major term project is required of all students. This subject is open to motivated seniors having a strong interest in biomedical engineering and information system design with the ability to carry out a significant independent project. This course was offered as part of the Singapore-MIT Alliance (SMA) program as course number SMA 5304."

Se introduce el concepto de disparador (trigger) en bases de datos relacionales, y la sintaxis SQL para crearlos.

This graduate seminar is taught in a lecture and lab exercise format. The subject matter is tailored to introduce Environmental Engineering students to the use and potential of Geographic Information Systems in their discipline. Lectures will cover the general concepts of GIS use and introduce the material in the exercises, and exercises will introduce students to the practical application of GIS.

Broad coverage of technology concepts underlying modern computing and information management. Topics include computer architecture and operating systems, relational database systems, graphical user interfaces, networks, client/server systems, enterprise applications, cryptography, and the web. Hands-on exposure to internet services, Microsoft Access database management system, and Lotus Notes. Information Technology I helps students understand technical concepts underlying current and future developments in information technology. There will be a special emphasis on networks and distributed computing. Students will also gain some hands-on exposure to powerful, high-level tools for making computers do amazing things, without the need for conventional programming languages. Since 15.564 is an introductory course, no knowledge of how computers work or are programmed is assumed.

Se introduce el álgebra relacional como modelo formal de las bases de datos relacionales. Se proporcionan ejemplos en SQL equivalentes a operaciones del álgebra relacional para conectar ambos lenguajes.

This course provides a general overview of databases, including topics such as database history, modern database systems, the different models used to design a database, and Structured Query Language (SQL), which is the standard language used to access and manipulate databases. Upon successful completion of this course, the student will be able to: compare and contrast the database approach and the file system approach; explain what a database management system is as well as the various components; identify the various people involved in database management systems; explain the historical background of database management systems; compare the various database models; describe the functions of a database management system; explain the three-schema database architecture; describe what tables, indexes, and views are as well as discuss the differences among them; explain the entity-relationship model; develop an entity-relationship model based on user requirements; describe the relational database model; explain the process of normalization; convert an entity-relationship diagram to a set of normalized relations; explain referential integrity; identify how relational algebra is used to construct queries; describe and use data definition commands; describe and use data manipulation commands; explain how to join tables together for queries. (Computer Science 403)

This is an introduction to SQL (Structured Query Language), the language used by most relational database management systems.

The logic foundations of queries (SQL) for databases.

Teaches basics of designing a dynamic web site with a database back end, including scripting languages, cookies, SQL, and HTML with the goal of building such a site as the main (group) project Emphasizes computer-human interface and the graphical display of information. Crucial to the project is the identification of a client with whom the group must work with throughout the month, designing specifications, implementing them, reviewing and evaluating, and testing. This is a real-life client who intends to host the site for the purposes of building a community.

Extends the computing and geographic information systems (GIS) skills developed in 11.520 to include spatial data management in client/server environments and advanced GIS techniques. First half covers the content of 11.523, introducing database management concepts, SQL (Structured Query Language), and enterprise-class database management software. Second half explores advanced features and the customization features of GIS software that perform analyses for decision support that go beyond basic thematic mapping. Includes the half-semester GIS project of 11.524 that studies a real-world planning issue.

Se describe el concepto de vista en esquemas relacionales y se introduce su sintaxis mediante ejemplos.

This class uses lab exercises and a workshop setting to help students develop a solid understanding of the planning and public management uses of geographic information systems (GIS). The goals are to help students: Acquire technical skills in the use of GIS software. Acquire qualitative methods skills in data and document gathering, analyzing information, and presenting results. Investigate the potential and practicality of GIS technologies in a typical planning setting and evaluate possible applications. The workshop teaches GIS techniques and basic database management at a level that extends somewhat beyond the basic thematic mapping and data manipulation skills included in the MCP core classes (viz.11.204 and 11.220). Instead of focusing on one thematic map of a single variable, students will concentrate on more open-ended planning questions that invite spatial analysis but will require judgment and exploration to select relevant data and mapping techniques, involve mixing and matching new, local data with extracts from official records (such as census data, parcel data and regional employment and population forecasts), utilize spatial analysis techniques such as buffering, address matching, overlays use other modeling and visualization techniques beyond thematic mapping, and raise questions about the skills, strategy, and organizational support needed to sustain such analytic capability within a variety of local and regional planning settings. Students seeking graduate credit should enroll in the subject 11.520; undergraduates should enroll in the subject 11.188. The subjects meet together and have nearly identical content.