Link Search Menu Expand Document
Course 2: Creating solutions for your project

Lesson 3: Integrate a Database

Database Integration

Follow the database lesson below on how to work with the database.

Course 1 Lesson 6: Learn How to Work with Databases

Apply database action

Learn how to make SQL query

CRUDMethod
CreateINSERT INTO patient (firstname, lastname) VALUES (‘John’, ‘Doe’);
ReadSELECT * FROM patient;
UpdateUPDATE patient SET firstname = ‘John’, lastname = ‘Doe’;
DeleteDELETE FROM patient WHERE firtname=’John’;

Simply fill in the properties with the query parameters.

Fill out database action

Database Installation

Follow the installation instruction in the supplementary course to install the database.

MySQL Installation

NEXT » Lesson 4: Enable Signup and Login