How my Tech journey started with SQL

Step 1.
I launched PG admin and Valentina Studio from my desktop

Step 2.
I launched the command prompt app (CMD) from windows

Step 3.
Locate the database then copy out the address or path

Step 4.
Paste on the command prompt

Step 5.
Create the respective databases on Valentina studio

1. Employees
2. France
3. Store
4. World

Step 6.
Steps to creating the databases on Valentina Studio
Valentina is a multi data management tool that helps to create, administer, query and explore database. It works on different Data Base Management System (DBMS)

• On the Valentino studio, connect the Valentina studio to the ProgreSQL
• After connecting, enter the PostgreSQL PW
• Then title the databases accordingly (Employees)
• Repeat same for France, Store and World databases

Step 7.

• I launched the root folder on the command prompt C:\Users\JohnsonAdesanya\Downloads\databases
• Then i changed directory (cd) to the employee folder C:\Users\JohnsonAdesanya\Downloads\databases>cd employee

Step 8.
C:\Users\JohnsonAdesanya\Downloads\databases\employee>"C:\Program Files\PostgreSQL\14\bin.psql.exe" -U postgres -d Employees < employees.sql
'"C:\Program Files\PostgreSQL\14\bin.psql.exe"' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\JohnsonAdesanya\Downloads\databases\employee>"C:\Program Files\PostgreSQL\14\bin\psql.exe" -U postgres -d Employees < employees.sql
Password for user postgres:

Step 9
To query your database, you click on the sql employee beside the Schema editor on the Valentina Studio platform using SQL syntanx as required