CS 145: Introduction to Databases
The course covers database design and the use of database management systems for applications. It includes extensive coverage of the relational model, relational algebra, and SQL.The course includes database design and relational design principles based on dependencies and normal forms. Many additional key database topics from the design and application-building perspective are also covered: indexes, views, transactions, authorization, integrity constraints, triggers, on-line analytical processing (OLAP), JSON, and emerging NoSQL systems. Class time will include guest speakers from industry and additional advanced topics as time and class interest permits. Prerequisites: 103 and 107 (or equivalent).
Terms: Aut
| Units: 3-4
| UG Reqs: GER:DB-EngrAppSci
Instructors:
Re, C. (PI)
;
Ekmekji, A. (TA)
;
Gupta, S. (TA)
;
Kaymaz, C. (TA)
;
Kulshreshtha, A. (TA)
;
Li, Y. (TA)
;
McKenzie, K. (TA)
;
Ratner, A. (TA)
;
Sundaresan, V. (TA)
;
Tan, J. (TA)
;
Tsai, S. (TA)
CS 245: Database Systems Principles
File organization and access, buffer management, performance analysis, and storage management. Database system architecture, query optimization, transaction management, recovery, concurrency control. Reliability, protection, and integrity. Design and management issues. Prerequisites: 145, 161.
Terms: Win
| Units: 3
Instructors:
Garcia-Molina, H. (PI)
;
Bhandari, A. (TA)
;
Park, S. (TA)
...
more instructors for CS 245 »
Instructors:
Garcia-Molina, H. (PI)
;
Bhandari, A. (TA)
;
Park, S. (TA)
;
Srinivasan, S. (TA)
;
Tsai, S. (TA)
;
Yang, S. (TA)
CS 295: Software Engineering
Software specification, testing, and verification. Emphasis is on current best practices and technology for developing reliable software at reasonable cost. Assignments focus on applying these techniques to realistic software systems. Prerequisites: 108. Recommended a project course such as 140, 143, or 145.
Last offered: Spring 2011
CS 346: Database System Implementation
A major database system implementation project realizes the principles and techniques covered in earlier courses. Students independently build a complete database management system, from file structures through query processing, with a personally designed feature or extension. Lectures on project details and advanced techniques in database system implementation, focusing on query processing and optimization. Guest speakers from industry on commercial DBMS implementation techniques. Prerequisites: 145, 245, programming experience in C++.
Last offered: Spring 2015
HUMBIO 145L: The Biology and Evolution of Language (ANTHRO 171, ANTHRO 271)
Lecture course surveying the biology, linguistic functions, and evolution of the organs of speech and speech centers in the brain, language in animals and humans, the evolution of language itself, and the roles of innateness vs. culture in language. Suitable both for general education and as preparation for further studies in anthropology, biology, linguistics, medicine, psychology, and speech & language therapy. Anthropology concentration: CS, EE. No prerequisites.
Terms: Spr
| Units: 4-5
| UG Reqs: GER: DB-NatSci, WAY-SMA
Instructors:
Fox, J. (PI)
Filter Results: