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)

Energy policy is typically evolutionary as opposed to revolutionary. We can look to historical policies to understand how we've inherited the policies governing our energy use today. But looking backward only tells us part of the story. In the face of climate change, we need to look ahead and instead envision a more revolutionary change to our energy systems and the policies that govern them. This class takes you on that journey to energy policies past, present, and future. We look at the political realities of addressing climate change at various scales of governance and work together to craft our own ideal scenarios of what a responsible energy future will be.

This course is a survey of principal concepts and methods of fluid dynamics. Topics include mass conservation, momentum, and energy equations for continua; Navier-Stokes equation for viscous flows; similarity and dimensional analysis; lubrication theory; boundary layers and separation; circulation and vorticity theorems; potential flow; introduction to turbulence; lift and drag; surface tension and surface tension driven flows.

Advanced Igneous Petrology covers the history of and recent developments in the study of igneous rocks. Students review the chemistry and structure of igneous rock-forming minerals and proceed to study how these minerals occur and interact in igneous rocks. The course focuses on igneous processes and how we have learned about them through studying a number of significant sites worldwide.

Systematic development of reading, writing, and oral communication skills. Introduction to advanced grammar that deepens the understanding of Japanese culture and society through reading and discussion. Lab work required. This course covers lessons 22 through 27 of Japanese: The Spoken Language by Eleanor H. Jordan with Mari Noda. The goal of the course is to continue to build oral proficiency by expanding your knowledge of vocabulary and grammar. Class hours will be devoted to developing speaking skills in a variety of circumstances; making requests, invitations, apologies, suggestions, dealing with problems, expressing your opinions, etc. Grammatical and social appropriateness on your utterances will be stressed. Keep in mind that daily tape-work is essential.

Continuation of 21F.505. Further development of reading, writing, and oral communication skills. Extension of advanced grammar and further enhancement of advanced vocabulary. Variety of cultural elements studied through readings, video, and discussion. Lab work required. This course covers Lessons 27 through 30 of Japanese: The Spoken Language by Eleanor H. Jordan with Mari Noda. The goal of the course is to continue expanding grammar and vocabulary by further developing four skills: speaking, listening, reading, and writing. The goal is to acquire the ability to use Japanese appropriately with increasing spontaneity emphasized, and to be prepared to become an independent learner to the point where you are capable of handling authentic Japanese by yourself, without fear or hesitation.

This course is an advanced course in macroeconomics that seeks to bring students to the research frontier. The course is divided into two sections. The first half is taught by Prof. Iv‡n Werning and covers topics such as how to formulate and solve optimal problems. Students will study fiscal and monetary policy, among other issues. The second half, taught by Prof. George-Marios Angeletos, covers recent work on multiple equilibria, global games, and informational fictions.

Topics change from year to year. Most recent topics include: optimal fiscal and monetary policy; optimal capital taxation; time inconsistency and incentive incompatibility of optimal policies; redistribution and political economics; heterogeneous agents and incomplete markets; Real Business Cycle models and new-keynesian models; endogenous growth; aggregate fluctuations and propagation mechanisms; recursive methods and robust control in macro.

Application of structure and theory to the study of organic reaction mechanisms: stereochemical features including conformation and stereoelectronic effects; reaction dynamics, isotope effects and molecular orbital theory applied to pericyclic and photochemical reactions; and special reactive intermediates including carbenes, carbanions, and free radicals.

" The focus of the course is the concepts and techniques for solving the partial differential equations (PDE) that permeate various scientific disciplines. The emphasis is on nonlinear PDE. Applications include problems from fluid dynamics, electrical and mechanical engineering, materials science, quantum mechanics, etc."

This course focuses on phonological phenomena that are sensitive to morphological structure, including base-reduplicant identity, cyclicity, level ordering, derived environment effects, opaque rule interactions, and morpheme structure constraints. In the recent OT literature, it has been claimed that all of these phenomena can be analyzed with a single theoretical device: correspondence constraints, which regulate the similarity of lexically related forms (such as input and output, base and derivative, base and reduplicant).

Investigates conceptual and formal issues in different media or between media such as sculpture, photography, and video. Explores issues of representation, interpretation, and meaning, and how they relate to historical, social and cultural context.

12.491 is a seminar focusing on problems of current interest in geology and geochemistry. For Fall 2005, the topic is organic geochemistry. Lectures and readings cover recent research in the development and properties of organic matter.

This class presents the application of principles of soil mechanics. It considers the following topics: the origin and nature of soils; soil classification; the effective stress principle; hydraulic conductivity and seepage; stress-strain-strength behavior of cohesionless and cohesive soils and application to lateral earth stresses; bearing capacity and slope stability; consolidation theory and settlement analyses; and laboratory and field methods for evaluation of soil properties in design practice.

En este curso el estudiante perfeccionará su comunicación oral y escrita mediante el estudio y la discusión de temas relacionados al impacto social y cultural de la ciencia y la tecnología en ciertas sociedades hispanas. Algunos de los temas a tratar son los efectos de los cambios tecnológicos en la estructura familiar y comunitaria, en las relaciones entre los sexos, en la identidad personal y cultural, en el mundo natural y en los sistemas de valores, la religión, la educación y el trabajo. También se examinan y discuten diversas actitudes hacia la innovación tecnológica y científica así como las ramificaciones éticas de las decisiones tecnológicas.

For advanced students who wish to build confidence and skills in spoken English. Focuses on the appropriate oral presentation of material in a variety of professional contexts: group discussions, classroom explanations and interactions, and theses/research proposals. Valuable for those who intend to teach or lecture in English. Includes language laboratory assignments. The goal of the workshop is to develop effective speaking and listening skills for academic and professional contexts.

This course is oriented toward US high school students. The course is divided into 10 units of study. The first five units build the foundation of concepts, vocabulary, knowledge, and skills for success in the remainder of the course. In the final five units, we will take the plunge into the domain of inferential statistics, where we make statistical decisions based on the data that we have collected.

This class covers the analysis and modeling of stochastic processes. Topics include measure theoretic probability, martingales, filtration, and stopping theorems, elements of large deviations theory, Brownian motion and reflected Brownian motion, stochastic integration and Ito calculus and functional limit theorems. In addition, the class will go over some applications to finance theory, insurance, queueing and inventory models.

This course draws on a wide range of perspectives to explore the roots of long term competitive advantage in unusually successful firms. Using a combination of cases, simulations, readings and, most importantly, lively discussion, the course will explore the ways in which long term advantage is built from first mover advantage, increasing returns, and unique organizational competencies. We will focus particularly on the ways in which the actions of senior management build competitive advantage over time, and on the strategic implications of understanding the roots of a firm's success.

This course is designed to introduce students who wish to specialize in stress analysis of thin-walled structures to more advanced topics such as the analysis of statically indeterminate structures, warping, constraint stresses, shear diffusion, and elements of plate bending.