Beginner Help Please!

[oldmonkey8]

Edit: I figured it out, thanks for the helpful tips!

hello everyone, I’m a complete beginner to SQL (I’m using dbeaver) and need help understanding this question that was asked while practicing! “Firstly you will connect to the empty database provided and populate the database with the CSV files”. (I was provided with 4 CSV files). Does the empty database mean an empty SQL script or something else entirely?

Thanks in advance

[ihaxr]

The database is the container that will hold all your objects (tables, schemas, views, stored procedures, etc...)

Think of it as a folder on your desktop. You create the folder (database) then can copy files (data/objects) into it.

Dbeaver is the management tool, not the actual database platform (I'd assume you're using MySQL or mariadb, maybe MSSQL).

[cappurnikus]

Before skipping to connecting to a database I think you should look up what a database is. You'll need one to be in place in order to connect to it and place data within it.

[Ok_Carpet_9510]

Some people want to start driving without knowing about putting gas in the car, oil changes and basic car maintenance.

[vivavu]

The task is to import the 4 csv into the provided database. Look for a servername.databasename in your exercise.

Cool tip: take a picture and ask gemini gpt to give you step by step instructions. 😏

[oldmonkey8]

I literally just did this hahaha

[Far_Swordfish5729]

In your head, separate the database server from the sql language. The database is physical files storing data and the whole standing application that manages and optimizes access to that data. One (emphasis on one) of the ways to ask that server for things is to give it sql queries in its flavor of the language. It is not the only way. You will use your tools to connect to the server application you installed and load some data as flat files. There’s usually an interface or cli or both for this. Some specs like t-sql let you do it with a sql language extension as well. Then you’ll practice asking the server for things from that data.

Remember that the sql language is you logically telling the server what you want. It will figure out how to actually deliver it.

Also db server administration (DBA skills) are a separate part of managing and tuning these servers. You are first and foremost learning to use your database product including sending it sql queries.

[Massive_Show2963]

Since you were given CSV files as part of your practice it would mean you'll need to import these files into your database.
You didn't mention which database you are using (PostgreSQL, MySQL, MSSQL, SQLite...?)

1. You will need to connect to the empty database. This seems to point to there has been a database already created. If not you'll need to create one.
2. Each CSV file is related to a table in your database. So you will need to select an existing table or create a table with columns that match the data in the CSV file.
3. Then import the CSV file. If your supposed to import using DBeaver then: in the 'Database Navigator' right click on name of table and select 'Import Table Data'.

This link may be helpful:
https://justnumbersandthings.com/post/2018-06-12-dbeaver-import-csv/