Difference between revisions of "PostgreSQL-Database/C2/Creating-a-Database-using-pgAdmin4/English"
(Created page with "'''Title of the script''':''' Create Database using PgAdmin.''' '''Author''':''' EduPyramids''' '''Keywords''': RDBMS, PostgreSQL, pgAdmin, Database, table, field, record, E...") |
|||
| Line 47: | Line 47: | ||
|| Let us open '''p g Admin 4'''. | || Let us open '''p g Admin 4'''. | ||
|- | |- | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|| '''Screencast:''' | || '''Screencast:''' | ||
| Line 79: | Line 71: | ||
|| Besides '''Properties''', we have a '''S Q L''' tab. | || Besides '''Properties''', we have a '''S Q L''' tab. | ||
| − | + | The tab displays the script of the selected object. | |
As of now no '''S Q L''' query is shown. | As of now no '''S Q L''' query is shown. | ||
| Line 96: | Line 88: | ||
|| In the left panel, right click on '''Servers'''. | || In the left panel, right click on '''Servers'''. | ||
| − | A context menu opens. Select '''Register''' and then select '''Server. | + | A context menu opens. |
| + | |||
| + | Select '''Register''' and then select '''Server. | ||
Register Server '''window is displayed. | Register Server '''window is displayed. | ||
Latest revision as of 11:39, 6 February 2026
Title of the script: Create Database using PgAdmin.
Author: EduPyramids
Keywords: RDBMS, PostgreSQL, pgAdmin, Database, table, field, record, EduPyramids, video tutorial.
| Visual Cue | Narration |
| Slide 1
|
Welcome to the Spoken tutorial on Creating a Database using pgAdmin 4. |
| Slide 2
Learning Objectives |
In this tutorial we will learn to,
|
| Slide 3
System Requirements |
To record this tutorial, I am using
|
| Slide 4
Pre-requisites |
To follow this tutorial, * Learners should have Post gres Q L and p g Admin 4.
|
| Screencast: | Let us open p g Admin 4. |
| Screencast:
Zoom in (Press Ctrl ++)to see the objects clearly while recording. Screencast: Click on the Properties tab, and show the cursor on the tab. |
On the left hand side we can see the Object Explorer.
Various objects of the database will be displayed here. In the toolbar, Properties tab shows the respective properties of each object. |
| Screencast:
Click on the SQL tab, and show the cursor on the tab. Point to the text shown brown colour. |
Besides Properties, we have a S Q L tab.
The tab displays the script of the selected object. As of now no S Q L query is shown. |
| Let us now see how to connect to the server. | |
| Screencast:
Select Register and then select Servers. Cursor on Register -Server window. |
In the left panel, right click on Servers.
A context menu opens. Select Register and then select Server. Register Server window is displayed. |
| Screencast:
Under General, in the name tab type localhost. Click on the Connection tab. In the Host name/address type: localhost. |
Under General, in the Name field let’s type localhost.
Now let us click on the Connection tab. Type localhost in Host name slash address. |
| Leave the other parameters as default. | Let us keep all the other parameters as default. |
| Screencast:
Point the cursor on the Maintenance database name and Username. Enter password as: postgres Click on Save button. |
Note that, Maintenance database name and Username fields are prefilled.
Please enter the password which is given during installation. Save password toggle is displayed. Click on the toggle to enable it. Click on Save button at the bottom right corner. Localhost Dashboard opens. |
| Screencast:
Click on the localhost node drop down arrow. Point the cursor to the objects. |
Here, we can see that a connection has been established to the localhost.
Click on the localhost node. We can see the following objects for this particular server. |
| Screencast:
Click on the Databases node drop down arrow.
|
Now click on the Databases node dropdown.
The default database postgres created during installation is displayed here. |
| Slide 5
|
A database is an organized collection of data.
A database contains objects such as tables, views, functions, and procedures. We can create multiple databases based on application requirements. |
| Screencast:
|
Now, we will create a new database.
Right click on Databases node. Select Create, from the sub menu select Database. Create Database window is displayed. |
| Screencast:
Type database name: Studentdb and click Save.
|
Type Student d b as the database name and click Save at the bottom.
|
| Screencast:
Point to the message. Click the blue Yes button to close the window. |
Click on the close button to close the window.
|
| Slide 6
Summary In this tutorial we will learn to,
|
With this we come to the end of this tutorial.
Let us summarize. |
| Slide 7
As an Assignment, please do the following:
|
As an Assignment, please do the following. |
| Slide 8
|
This Spoken tutorial is brought to you by EduPyramids Educational Services Private Limited, SINE, IIT Bombay.
|
