Su	Mo	Tu	We	Th	Fr	Sa
31	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	1	2	3	4

Stanford University - Introduction to Databases [repost]

Posted By: ParRus

Date: 5 Nov 2016 13:39:26

Stanford University - Introduction to Databases [repost]

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.

MediaInfo:

General
Complete name : 04-01-introduction-to-SQL.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom
File size : 3.99 MiB
Duration : 4mn 30s
Overall bit rate mode : Variable
Overall bit rate : 124 Kbps
Encoded date : UTC 2011-03-28 22:23:57
Tagged date : UTC 2011-03-28 22:23:57

Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : High@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 4 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 4mn 30s
Source duration : 4mn 30s
Bit rate : 56.4 Kbps
Maximum bit rate : 315 Kbps
Width : 1 000 pixels
Height : 562 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 15.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.007
Stream size : 1.82 MiB (46%)
Source stream size : 2.19 MiB (55%)
Language : English
Encoded date : UTC 2011-02-13 23:48:02
Tagged date : UTC 2011-03-28 22:23:57
Color range : Limited
Color primaries : BT.709
Transfer characteristics : BT.709
Matrix coefficients : BT.709

Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 4mn 30s
Bit rate mode : Variable
Bit rate : 53.6 Kbps
Maximum bit rate : 55.4 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 KHz
Compression mode : Lossy coursera
Stream size : 1.73 MiB (43%)
Language : English
Encoded date : UTC 2011-03-28 22:23:57
Tagged date : UTC 2011-03-28 22:23:57

Screenshots

Exclusive eLearning Videos ParRus-blog ← add to bookmarks

Development Linux Windows eLearning Videos Databases Programming Unix SQL