technifyed

University of Maryland Baltimore County via edX

Relational Database Design

Overview

Learn how to design relational databases, including many popular relational database models. Relational database normal form will also be covered, so your design will conform to industry best practices.

What you'll learn

  • Identify physical and logical models.
  • Create Entity Relationship Diagrams (ERD), including tools to create ERDs.
  • Create Schema Diagrams, including tools to create them.
  • Create databases in Normal Forms 1 through 5 plus Boyce–Codd Normal Form (BCNF).

Skills you'll practise

Stored ProcedureData IntegrityRelational Database DesignDatabase ManagementData QualityAdministrative FunctionsRelational Databases

Advantages and disadvantages

Advantages

  • University courses you can audit for free, with lectures, readings and practice quizzes.
  • A verified certificate from the university if you pay for it.
  • Self-paced: start any time.

Disadvantages

  • Graded assignments and the certificate need the paid track.
  • Audit access can expire a few weeks after the course ends.
  • Learning is free, but the certificate costs money.
  • Some parts (graded work, certificate) are paid.

Some points apply to every course of this kind; see how we rank.

Free to audit

  • Free: Choose "Audit this course" when you enrol: lectures, readings and practice are free.
  • Paid: Graded assignments and the verified certificate (Certificate $249). Audit access may end after the course closes.

Before you start

Some experience in computer programming is helpful.

Taught by

  • Dr. Michael BrownProfessor
  • Dr. Augusto CasasProfessor

Similar courses

Compare these

Massachusetts Institute of Technology · YouTube

MIT 6.01SC Introduction to EECS I

Instructor: Dennis Freeman, Kendra Pugh This course provides an integrated introduction to electrical engineering and computer science, including modern software engineering, linear systems analysis, electronic circuits, and decision-making. The lecture videos provide an overview of each topic, whi…

Free video27 videos, 17 hours

Harvard University · edX

Exercising Leadership: Foundational Principles

4.71,590 ratings

Mobilize people to tackle tough problems and build the capacity to thrive through the dangers of change

Free to audit4 weeks, 2 - 3 hours per week

Harvard University · YouTube

CS50's Introduction to Databases with SQL

This is CS50’s introduction to databases using a language called SQL. Learn how to create, read, update, and delete data with relational databases, which store data in rows and columns. Learn how to model real-world entities and relationships among them using tables with appropriate types, triggers…

Free video8 videos, 11 hours

Harvard University · edX

CS50's Introduction to Computer Science

An introduction to the intellectual enterprises of computer science and the art of programming.

Free to audit12 weeks, 5 - 14 hours per week

Massachusetts Institute of Technology · YouTube

MIT MAS.S62 Cryptocurrency Engineering and Design, Spring 2018

Instructor: Neha Narula, Tadge Dryja View the complete course: https://ocw.mit.edu/MAS-S62S18 YouTube Playlist: https://www.youtube.com/playlist?list... This course looks at the design of Bitcoin and other cryptocurrencies and how they function in practice, focusing on cryptography, game theory, an…

Free video20 videos, 25 hours

Harvard University · edX

CS50's Introduction to Programming with Python

An introduction to programming using Python, a popular language for general-purpose programming, data science, web programming, and more.

Free to audit10 weeks, 3 - 6 hours per week

Enter your email and the official page opens. Phone is optional.