honestica/data-jobs

Business Case - Data Analyst - How to query Database ?

In order to crack your case you will need to be able to query the database created for the occasion. You will have to download and install some content + execute each of the following steps to access it.

Pre-requisites

• Download and install DBeaver CE (Community Edition), don't worry it is free and compatible with any mainstream Operating System.
• Download lifen_case.duckdb from this repository, in the Data Analyst 2024 folder.

Step by Step - Import DuckDB database within DBeaver

1. Open DBeaver
2. Create a new connection: either click on the 🔌➕ New Database Connection button or go to Database > New Database Connection in the menu bar. Or,
3. Search for DuckDB, select it, and click Next.
4. Click Open and select the lifen_case.duckdb downloaded previously.
5. Click on Test Connection ..., this should propose you to install DuckDB driver within DBeaver (unless you already have it installed). Process with Download.
6. Click on Finish, you are now able to access to query all tables from the database. For your case you will only need to query the 3 tables in the main schema (activity, practitioner and communication).
7. Click on the icon 📜 SQL to create a new script tab in the editor.
8. Ace your case !