Intermediate Relational Database and SQL

417 ratings
Offered By
Coursera Project Network
10,705 already enrolled
In this Guided Project, you will:

How to create, modify and remove tables and databases.

The design principles of tables and databases.

How SQL is applied in applications.

Clock60 minutes
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

In this 1-hour long project-based course, you will gain hands-on experience and learn how to create and maintain relational databases such as MySQL, Oracle and MS Access. Concepts covered include database and table creation, primary keys and foreign keys. If you have some experience with end-user level SQL and want to advance to a designer or database administrator role, this course is for you! Note: Taking my course "Introduction to Relational Database and SQL" before taking this course is highly recommended. Especially if you do not have any previous experience with relational database and SQL.

Skills you will develop

Data ScienceDatabase (DB) DesignRelational Databasedatabase administrationSQL

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. User interface orientation

  2. Preview finshed products

  3. Creating and dropping databases

  4. Creating and dropping tables

  5. Creating and dropping primary keys

  6. Creating and dropping indexes

  7. Creating and dropping foreign keys

  8. Testing and creating technical documentation

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step




View all reviews

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.