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)
4 Results
Students learn more about how muscles work and how biomedical engineers can help keep the muscular system healthy. Following the engineering design process, they create their own biomedical device to aid in the recovery of a strained bicep. They discover the importance of rest to muscle recovery and that muscles (just like engineers!) work together to achieve a common goal.
- Author:
- Malinda Schaefer Zarske
- Integrated Teaching and Learning Program,
- Denise W. Carlson
- Jonathan MacNeil
- Jaime Morales
This course is designed to introduce graduate students to the foundations of database systems, focusing on basics such as the relational algebra and data model, query optimization, query processing, and transactions. This is not a course on database design or SQL programming (though we will discuss these issues briefly). It is designed for students who have taken 6.033 (or equivalent); no prior database experience is assumed though students who have taken an undergraduate course in databases are encouraged to attend.
- Subject:
- Applied Science
- Computer Science
- Material Type:
- Full Course
- Textbook
- Author:
- Samuel Madden
- Date Added:
- 01/01/2004
This course relies on primary readings from the database community to introduce graduate students to the foundations of database systems, focusing on basics such as the relational algebra and data model, schema normalization, query optimization, and transactions. It is designed for students who have taken 6.033 (or equivalent); no prior database experience is assumed, though students who have taken an undergraduate course in databases are encouraged to attend.
- Author:
- Morris, Robert
- Stonebraker, Michael
- Madden, Samuel
- Curino, Carlo