Databases: Relational Databases and SQL

Course

English

16 h

Source

From www.edx.org

Conditions

Self-paced
Free Access
Fee-based Certificate

More info

2 Sequences
Introductive Level

Their employees are learning daily with

Learn more

Course details

Syllabus

Stanford's online offering in Databases is now available as a set of five self-paced courses:

Databases: Relational Databases and SQL

Introduction to the relational model and concepts in relational databases and relational database management systems
Comprehensive coverage of SQL, the long-accepted standard query language for relational database management systems

Databases: Advanced Topics in SQL (prerequisite: Relational Databases and SQL)

Creating indexes for increased query performance
Using transactions for concurrency control and failure recovery
Database constraints: key, referential integrity, and "check" constraints
Database triggers
How views are created, used, and updated in relational databases
Authorization in relational databases

Databases: OLAP and Recursion

Star schemas, the data cube concept, and On-Line Analytical Processing (OLAP) features in relational databases including the Cube and Rollup operators
The SQL standard for queries over recursively-defined relations

Databases: Modeling and Theory

Relational algebra – the algebraic query language that provides the formal foundations of SQL
Dependency theory and normal forms in relational databases as the basis of schema design
The data-modeling component of the Unified Modeling Language (UML), how UML diagrams are translated to relations

Databases: Semistructured Data

The XML model for semistructured and self-describing data, including DTDs and some features of XML Schema
The JSON model for human-readable structured or semistructured data
The XPath language for processing XML data, and many features of the more advanced XQuery language
An introduction to the XSLT rule-based language for querying and transforming XML data

Prerequisite

There are no specific prerequisites for this course; however, some computer science background is expected for all of the courses in the Databases series.

Instructors

Jennifer Widom
Dean, School of Engineering
Stanford University

Platform

Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with EdX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be taught by David J. Malan, a senior lecturer on computer science at Harvard University for the School of Engineering and Applied Sciences. But there's not just one professor - you have access to the entire teaching staff, allowing you to receive feedback on assignments straight from the experts. Pursue a Verified Certificate to document your achievements and use your coursework for job and school applications, promotions, and more. EdX also works with top universities to conduct research, allowing them to learn more about learning. Using their findings, edX is able to provide students with the best and most effective courses, constantly enhancing the student experience.

(no review)

Complete this resource to write a review