RDBMS-PostgreSQL/C2/Create-database-using-PgAdmin/English

>>Title of script: Create a database using pgAdmin

Author: Nirmala Venkat

Keywords: RDBMS, PostgreSQL, pgAdmin, Database, table, field, record, video tutorial

Visual Cue	Narration
Slide 1:	Welcome to the Spoken Tutorial on Create a database using pgAdmin.
Slide 2: Learning Objectives	In this tutorial we will learn about how to connect to the server database and its objects how to create a database Table and its attributes and how to create a table
Slide 3: System requirement	For this tutorial, I am using Ubuntu Linux 14.04 operating system PostgreSQL 9.3.x pgAdmin 1.18
Slide 4: Pre-requisites	To follow this tutorial, you should have good understanding of basic computer concepts and working knowledge of any programming language.
	Let us open the pgAdmin.
Click Dash home	Click Dash Home on the top left corner of the computer desktop.
In the search box type, pgadmin	In the Search box, type pgAdmin. The pgAdmin icon appears. Click on it.
Point to the new window	pgAdmin interface is opened now. Here, on the left hand side we can see the object browser pane. The various objects of the database are displayed here. The upper right pane shows the relevant properties of each object. The lower right pane is the SQL pane where the script of the currently selected object is displayed
Point to the connection icon in the tool bar.	Let us see how to connect to the server. Click on the connection icon on the top left corner of the tool bar.
Point to the window.	New Server Registration window appears.
Point to properties tab. Type localhost in the Name field Type localhost in the Username field	In the properties tab, enter localhost in the Name field and localhost in the Host field. Keep all the other parameters same. The database name, Username which are shown here are the names given during installation. Enter the password which you gave during installation. Click on ok button. Small pop-up windows will appear from time to time. These give additional information for our understanding. Always click on this check box 'Do not show this hint again', before you close these windows. I won't explicitly mention this. Click on 'Ok' button.
Point to the connection Click on the localhost node. Point to the objects under the server	Here, we can see the connection established to localhost. Click on the localhost node. We can see several objects for this particular server.
	Now click on the Databases node. The default database 'postgres' that is created during installation is displayed here.
Slide 5: Database Image Database.svg	Database is a collection of information or data, which is stored in an organized way. A database has objects such as tables, views, procedures, functions, etc. We will learn about these objects in the future tutorials in this series. We can have multiple databases depending upon our application requirement.
	Switch back to pgAdmin interface.
	Now, we will create a new database for our demonstration purpose.
	Right click on the Databases node and select New Database. Type Sampledb as the database name and click ok.
	Now, we can see the database is listed under the database node which we created just now.
	Next we will add a student table to this sampledb database.
Slide: What is table?	In RDBMS, we store data in database objects called tables. A table is a collection of related data that is stored in rows and columns format.
Slide: Show the table image:student.jpg	This is an example of a STUDENT table. Tables have columns which are called as fields. The fields in the STUDENT table are Student ID, student name, address, city, Phone, DOB, CGPA.
Slide: What is a Column? Show the student_ column.jpg	A column is a set of value of a particular data type. This is also called as attribute. Here in the STUDENT table, Student Name is one of the attribute that represents names of students.
	Now switch back to the interface.
	To create a new table in sampledb database, click on the sampledb node. Then click schemas and then public and Tables.
	Right click on the table node and select New Table. Let us give “students” as table name.
	Click on the columns tab to enter the columns for this table. Click on the Add button. In the new window that opens, enter Student name in the name field.
	Select Character varying as data type from the drop down list box. The data type specifies what type of data the field can hold. Enter 50 in the length field. The length specifies the maximum length of the column of the table. Click ok button to add column to the table.
	We will see what are the common data types used in PostgreSQL.
Slide Data types: integer, numeric - numeric data type numeric (n,d) – where n is the total digits and d is the number of digits after the decimal Char (size) - holds a fixed length string character varying(size),varchar(size) - holds a variable length string text – variable unlimited length Date – date data type	Integer, numeric represents numeric data type. For example, phone no, age, quantity are of numeric data type. numeric(n,d) - is also numeric data type with decimal places. Here n is the total digits and d is the number of digits after the decimal. It can be used to represents fields like basic salary, unit price etc. Char and character varying represents string data type. Fields such as name, address, email are of string data type. Text is a string data type with unlimited length. Date represents date data type.
	Likewise,I'll add Address column with character varying data type and length as 100. Add the column City, phone as shown here Add a date of birth column with date data type. Next add a CGPA field. Select the data type as numeric. Enter 2 as length and 1 as precision. This is same as the decimal data type.
	We have entered all the columns for the student table. Click on ok button. A window shows some message about primary keys. We will see the importance of primary keys in the future tutorials.
	We can see the student table is created in the sampledb database.
	Click on it. In the sql pane, we can see the syntax of the create table command generated automatically.
	With this, we come to the end of this tutorial. Let us summarize.
Summary	In this tutorial, we have learnt about how to connect to the server database and its objects how to create a database Table and its attributes and how to create a table
Assignment	As an Assignment, Connect to the server and check the default available database Create a new database Organization. In the Organization database, create a table Emp with the columns Emp name, Address, DOB and Salary.
Slide 12: About Spoken Tutorial project [1]	The video at the following link summarises the Spoken Tutorial project. Please download and watch it.
Slide 13: Spoken Tutorial workshops	The Spoken Tutorial Project Team conducts workshops gives certificates For more details, please write to us.
Slide 13: Forum for specific questions	Please post your timed queries in this forum.
Slide 14: Acknowledgement	Spoken Tutorial project is funded by NMEICT, MHRD, Government of India. More information on this mission is available at this link.
	This is Nirmala Venkat from IIT Bombay, signing off. Thanks for watching.

Contributors and Content Editors

Nancyvarkey, Nirmala Venkat