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
| CRUD | Method |
|---|---|
| Create | INSERT INTO patient (firstname, lastname) VALUES (‘John’, ‘Doe’); |
| Read | SELECT * FROM patient; |
| Update | UPDATE patient SET firstname = ‘John’, lastname = ‘Doe’; |
| Delete | DELETE FROM patient WHERE firtname=’John’; |
Simply fill in the properties with the query parameters.
Database Installation
Follow the installation instruction in the supplementary course to install the database.
NEXT » Lesson 4: Enable Signup and Login