Salon Appointment Scheduler | FreeCodeCamp

1 year ago
33

In this video we are instructed to complete tasks for a project involving the creation of a salon database. The tasks include creating a database named "salon" and tables named "customers", "appointments", and "services". The tables should have primary key columns that follow a specific naming convention and foreign keys that reference other columns from different tables. The script file "salon.sh" should be created with executable permissions, and it should prompt users for input to add new appointments to the database. Thanks for watching and have a great day!

Connect on LinkedIn:

Time stamps
00:00 Intro
00:35 Read Instructions
02:55 Start on Database
11:09 Insert initial data
12:44 Start on salon.sh
15:12 Figure out how to query the database in bash
18:17 Display services correctly
24:52 Gather Phone number
31:11 Format service and name for when they would like to schedule
38:08 Change variable names so it passes the test
45:11 Break out create appointment functionality to its own function
51:15 Figuring out "If you pick a service that doesn't exist, you should be shown the same list of services again"
54:05 Finally Figured it out!!

Loading comments...