Time for action – loading a table with a list of manufacturers

Let's suppose that you love jigsaw puzzles and decided to open a store for selling all kinds of them. You have made all the arrangements and the only missing thing is the software. You have already acquired software to handle your business but you still have a hard task of adding data into the database, that is, loading the basic information about the products you are about to sell in the database.

As this is the first of several tutorials in which you will interact with this database, the first task you have to do is to create the database.

Note

For MySQL-specific tasks—for example, the creation of a database—we will use SQuirreL SQL Client . If you use this tool, make sure you have ...

Get Pentaho Data Integration Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.