Introduction to Databases - by Stanford University (Tests+Exercises)
Introduction to Databases - by Stanford University (Tests+Exercises)
eLearning | English | 1000x562 | h264 ~990 kbps | MP4A | 48 kHz ~112 Kbps | 1.27 GB
Databases
Databases
This 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. It also covers XML data including DTDs and XML Schema for validation, and the query and transformation languages XPath, XQuery, and XSLT. The course includes database design in UML, 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), and emerging "NoSQL" systems.
About The Course
A bold experiment in distributed education, "Introduction to Databases" is being offered free and online to students worldwide, October 10 - December 12, 2011. Students have access to lecture videos, are given assignments and exams, receive regular feedback on progress, and participate in a discussion forum. Those who successfully complete the course will receive a statement of accomplishment. Taught by Professor Jennifer Widom, the curriculum draws from Stanford's popular Introduction to Databases course. A high speed internet connection is recommended as the course content is based on videos and online exercises.
About The Instructor
Professor Jennifer Widom is the Fletcher Jones Professor and Chair of the Computer Science Department at Stanford University. She received her Bachelors degree from the Indiana University School of Music in 1982 and her Computer Science Ph.D. from Cornell University in 1987. She was a Research Staff Member at the IBM Almaden Research Center before joining the Stanford faculty in 1993. Her research interests span many aspects of nontraditional data management. She is an ACM Fellow and a member of the National Academy of Engineering and the American Academy of Arts & Sciences; she received the ACM SIGMOD Edgar F. Codd Innovations Award in 2007 and was a Guggenheim Fellow in 2000; she has served on a variety of program committees, advisory boards, and editorial boards.
1. Introduction
2. Relational Databases
3. XML Data
4. Relational Algebra
5. SQL
6. Relational Design Theory
7. Querying XML
8. Unified Modeling Language
9. Indexes
10. Constraints and Triggers
11. Transactions
12. Views
13. Authorization
14. Recursion
15. On-Line Analytical Processing
16.NoSQL Systems
Professor: Jennifer Widom
Run time: ~16 hours
Introduction to Databases - by Stanford University (Tests+Exercises)
Introduction to Databases - by Stanford University (Tests+Exercises)
Introduction to Databases - by Stanford University (Tests+Exercises)
