PostgreSQL-Database/C2/Creating-a-Database-using-pgAdmin4/English

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 Title Slide	Welcome to the Spoken tutorial on Creating a Database using pgAdmin 4.
Slide 2 Learning Objectives	In this tutorial we will learn to, Connect the database to the server and Create a database.
Slide 3 System Requirements	To record this tutorial, I am using Ubuntu 24 point 04 L T S. Post greS Q L version 18 point 1 and P g Admin 4 version 9 point one one </span> A working internet connection.
Slide 4 Pre-requisites https://EduPyramids.org	To follow this tutorial, * Learners should have Post gres Q L and p g Admin 4. For the pre-requisite Post gres Q L tutorials, please visit this website.
Screencast:	Let us open p g Admin 4.
Screencast: Cursor on Object. 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: Go to the left panel, right click on Servers. 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: In the left panel, point the cursor to the localhost. 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. Point the cursor to the default postgres database	Now click on the Databases node dropdown. The default database postgres created during installation is displayed here.
Slide 5 What is Database?	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: Go back to pgAdmin. Right-click on Databases node select Create, from the sub menu select Database. Cursor on Create-Databases window.	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. Cursor on the Studentdb database.	Type Student d b as the database name and click Save at the bottom. Now the newly created database is listed under the Databases node.
Screencast: Click on the X button to close the window. Point to the pop up window. Point to the message. Click the blue Yes button to close the window.	Click on the close button to close the window. A pop up window Quit P g Admin 4 opens. It shows a message Are you sure you want to quit the application? Click the blue colored Yes button to close the window.
Slide 6 Summary In this tutorial we will learn to, Connect the database to the server and Create a database.	With this we come to the end of this tutorial. Let us summarize.
Slide 7 Assignment As an Assignment, please do the following: Create a Database with the name Empdb.	As an Assignment, please do the following.
Slide 8 Thank You	This Spoken tutorial is brought to you by EduPyramids Educational Services Private Limited, SINE, IIT Bombay. Thank you for joining.

Contributors and Content Editors

Madhurig