From the course: Databases for Node.js Developers

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a database schema

Create a database schema

From the course: Databases for Node.js Developers

Start my 1-month free trial

Create a database schema

“

- [Instructor] Let's now use MySQL to implement our maxcoin sample. Other than Redis and MongoDB, relational databases like MySQL rely on static table structures so-called 'schemas' to have to be defined directly inside the database. For larger systems, creating the database design is actually a science of its own. The maxcoin application though is very simple. So let's create the schema for it now. So I'm in MySQL workbench and I have the Schemas tab open and there I now right click and click on 'create schema'. And for the schema name, I will now just insert 'maxcoin'. We can leave the default for the character set and the collation which is used for sorting of strings. Next, I will click on 'apply'. And there my SQL workbench shows me the.... Actually comments that it will execute on the database and it creates schema command for the database, 'maxcoin'. Next I click apply and then I can close this. Now I have a database…

Contents