Database CRUD Lab
Build create, read, update and delete screens backed by a real database.
What you'll learn
- Connect an app to a database
- Write create, read, update and delete queries
- Validate input before saving
- Handle not-found and error cases
About this course
You build a contacts manager with a Node back end and PostgreSQL. You write each CRUD operation and connect it to simple forms, from starter files.
Course curriculum
4 modules and 12 lessons over 4 weeks. Plan for about 12 learning hours.
01SetupWeek 1 · 3 lessons
- Starter app
- Database connection
- Schema
02ReadingWeek 2 · 3 lessons
- List view
- Detail view
- Search
03WritingWeek 3 · 3 lessons
- Create form
- Edit form
- Delete
04ErrorsWeek 4 · 3 lessons
- Validation
- Not-found cases
- Final checks
Project
Contacts manager. A CRUD app for contacts with forms, search and validation.
Who this course is for
Learners who know SQL and want to use it in an app.
Prerequisites
You know basic SQL and JavaScript.
What's included
- 180-day course access
- Project brief
- Starter repository
- Coding labs
- Reference solutions
- One written project review
- A digital completion certificate
Learning format
Project-based online course, part of our guided project courses. One written project review.
Access and delivery
- Course access is delivered within 15 minutes after payment.
- Written project review is returned within 2 business days of submission.
- Completion materials are issued within 2 business days after the project is approved.
Certificate
You receive a digital completion certificate. Completion materials are issued within 2 business days after the project is approved.
Frequently asked questions
When does access start?
Course access is delivered within 15 minutes after payment.
Is payment taken on this website?
No. After you submit your enrollment request, we reply by email with payment details and enrollment confirmation.
Does this course guarantee a job or income?
No. It is an education and training service and does not include employment, income or placement guarantees.
Can I cancel?
Our Refund and Cancellation Policy lists the terms for project-based programs.
