Free online courseDatabase

Conteúdo do Curso

• Video class: 01-01-introduction.mp4

  0h13m

• Exercise: _What does a database management system provide for applications, according to Jennifer Widom?

• Video class: 02-01-relational-model.mp4

  0h08m

• Video class: 02-02-querying-relational-databases.mp4

  0h06m

• Exercise: _What is the first step in creating and using a relational database?

• Video class: 03-01-well-formed-xml.mp4

  0h13m

• Video class: 03-02-dtds-ids-idrefs.mp4

  0h18m

• Exercise: _What is the difference between well-formed XML and valid XML?

• Video class: 03-03-xml-schema.mp4

  0h13m

• Video class: 04-01-json-intro.mp4

  0h14m

• Exercise: _What are the two types of composite values in JSON?

• Video class: 04-02-json-demo.mp4

  0h22m

• Video class: 05-01-relational-algebra-1.mp4

  0h18m

• Exercise: _What is the select operator in relational algebra?

• Video class: 05-02-relational-algebra-2.mp4

  0h19m

• Video class: 06-01-introduction-to-SQL.mp4

  0h04m

• Exercise: _What is the Data Definition Language (DDL) in SQL?

• Video class: 06-02-basic-select-statement.mp4

  0h09m

• Video class: 06-04-subqueries-in-where.mp4

  0h20m

• Video class: 06-05-subqueries-in-from-select.mp4

  0h08m

• Video class: 06-06-aggregation.mp4

  0h25m

• Exercise: _What are the basic aggregation functions supported by every SQL system?

• Video class: 06-07-null-values.mp4

  0h06m

• Video class: 06-08-data-modification-statements.mp4

  0h14m

• Exercise: _What are the two methods of inserting data in SQL?

• Video class: 06-055-join-operators.mp4

  0h25m

• Video class: 07-01-relational-design-overview.mp4

  0h16m

• Exercise: _What is the problem with the schema design for the database about students applying to colleges?

• Video class: 07-02-functional-dependencies.mp4

  0h27m