Stanford University - Introduction to Databases

WEBRip | English | MP4 + PDF Guides + Project files | 1000 x 562 | AVC ~54.4 kbps | 15 fps

AAC | 53.6 Kbps | 44.1 KHz | 2 channels | 16:04:07 | 1.27 GB

Genre: eLearning Video / Databases, Computer Science, Software Engineering

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.

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.

Content:

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

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.