PostgreSQL Tutorial - Employee Table Database Example speak Khmer

PostgreSQL Tutorial - Employee Table Database Example speak Khmer

PostgreSQL is know as Postgres. It is a free and open source for database management system.
PostgreSQL is base on standard SQL (Structured Query Language) to manipulate data like CREATE table, INSERT data, DELETE and SELECT statements.

PostgreSQL use pgAdmin Tool for SQL Query.

Learn More Introduction to Database (SQL) in Khmer with videos: Chapter 1 | Chapter 2 | Chapter 3

Learn more MySQL SQL SELECT statement Exercise: #1 | #2 | #3

You can download PostgreSQL for free HERE
EP12 តើ PostgreSQL ជាអ្វី? របៀប Download របៀបតម្លើង និង របៀបចាប់ផ្តើម

How to increase Font size on pgAdmin. Checkout HERE
EP13 របៀបពង្រីកទំហំអក្សរ Font Size ក្នុង pgAdmin PostgreSQL

How to CREATE Table Employee
EP14 របៀបសរសេរបង្កើតតារាង SQL CREATE TABLE statement ក្នុង PostgreSQL

Below are some SQL CREATE statements show in the video

CREATE TABLE Employee(
	empID int PRIMARY KEY,
	name varchar(30),
	gender varchar(1),
	email varchar(50),
	department varchar(30),
	province varchar(25),
	position varchar(25),
	salary money
);

How to INSERT data to the Employee database table
EP15 របៀបបញ្ចូលទិន្នន័យ SQL INSERT INTO statement ក្នុង PostgreSQL

Below are some SQL INSERT INTO statements show in the video

Insert INTO employee VALUES 
    (1,'Sovan', 'M', '[email protected]', 'IT','Phnom Penh', 'Developper', 450),
    (2,'vutha', 'M', '[email protected]', 'IT','Phnom Penh', 'Senior Developper', 650),
    (3,'sokha', 'F', '[email protected]', 'Media','Battambong', 'Design', 500),
    (4,'nimol', 'F', '[email protected]', 'Media','Takeo', 'Senior Design', 600),
    (5,'rim', 'M', '[email protected]', 'Account','Kampot', 'Account', 550),
    (6,'nisan', 'M', '[email protected]', 'Account','Posat', 'Head Account', 850);
    
    Insert INTO employee VALUES (7,'sok', 'M', '[email protected]', 'Account','Posat', 'Head Account', 850);
    Insert INTO employee VALUES (8,'sao', 'M', '[email protected]', 'Account','Posat', 'Head Account', 850);
    

How to UPDATE data to the Employee database table
EP16 របៀបកែទិន្នន័យ SQL UPDATE statement ក្នុង PostgreSQL

Below are some SQL UPDATE statements show in the video

UPDATE employee SET salary = 450 WHERE empID = 7;

    UPDATE employee SET "position" = 'Account assistant',salary = 470 WHERE empID = 8;

How to DELETE data from the Employee database table
EP17 របៀបលុបទិន្នន័យ SQL DELETE statement ក្នុង PostgreSQL

Below are some SQL DELETE statements show in the video

DELETE FROM employee WHERE empID = 8;

    Delete FROM employee;

How to SELECT data from the Employee database table
EP18 របៀបបង្ហាញទិន្នន័យតាម SQL SELECT statement ក្នុង PostgreSQL

Below are some SQL SELECT statements show in the video

SELECT * FROM employee;

    SELECT * FROM employee WHERE department = 'IT';
    
    SELECT * FROM employee WHERE province != 'Phnom Penh';
    
    SELECT name, gender, position FROM employee WHERE gender = 'F';

Free Khmer Ebook Download (PDF): Database | Microsoft Access | Python Programming