Creating and Uploading Test Data to a Render Cloud Database
In this video, you'll learn how to create a cloud database on the Render website and import your own data tables.
1. Register with your Google account at https://render.com/
2. Create a new database: On the main page of the Render dashboard at https://dashboard.render.com/, click the "New +" button and select "PostgreSQL."
3. Enter the database name, username, and password (you can use the default values or enter your own).
Make sure the Free plan is selected.
Click "Create Database."
Wait for the database to be created: This may take a few minutes. Once created, the database will be listed as "Available."
4. Obtain connection parameters: Go to the "Connections" tab, where you'll find the necessary environment variables for connecting to the database. To connect to a PostgreSQL database on Render via DBeaver, follow these steps:
5. Open DBeaver: Launch the program and select "Database" - "New Database Connection" from the menu.
6. Select a driver: Select "PostgreSQL" from the driver list and click "Next."
7. Fill in the connection parameters:
Hostname: Enter dpg-cp56dtf79t8c73epp02g-a.oregon-postgres.render.com
Port: Enter 5432
Database: Enter stepik_test
Username: Enter stepik_test
Password: Enter K6LPouWgdvcXpHDz0j42eZh3IVxnZOsO
8. Test and save:
Click "Test Connection" to test the connection. If everything is entered correctly, a successful connection message should appear.
Click "Finish" to save the connection.
9. Download scripts for creation tables.
https://drive.google.com/file/d/1je6fS9OIQ...
10. Create 6 new schema objects, in addition to public. The name can be anything.
11. Open a New Script for each of the schemas.
12. Apply the downloaded script to each of the schemas.
Fix any errors. Spoiler: "--" (double dash) will comment out the lines. The initial lines of the drop table may be spelled incorrectly. To apply the script, you must click the highlighted button. Otherwise, the script will be partially applied.
13. Using the New Script, apply the Select * query to one of the tables.
For example, select * from ships.
14. Congratulations. You have loaded the test tables into your database. What's next?
Using Dbeaver, you can view the table diagram and identify relationships between them.
Try writing queries of varying complexity against the data. tables.
👀Interested in learning more about SQL, PostgreSQL, and DBeaver?
Join our paid course. We offer over 300 practical exercises across four different types, requiring you to write SQL scripts, select operator sequences in queries, fill in blanks, and more. Over 65 table sets allow you to work with a variety of data and test situations.
📌 Our FREE course:
"Testing in Practice - Basic Course" -
https://stepik.org/course/124505/promo.
📌 Our paid course:
"Testing in Practice - SQL"
https://stepik.org/a/175956.
📌 All our Courses:
https://stepik.org/users/386677707/profile
=======================================
Telegram Group - https://t.me/+zfl_zRo8FPowZTky
VKontakte Group - https://vk.com/testinginpractice
Youtube Channel - / @testinginpractice
=========================================
#TestingInPractice #sql #postgresql #softwareengineer #softwaretesting #qa #testing #tester #study #training #testing
renderSQL