Ravindu Dilan

Tour Video

Web Programming I - Eshop
Project Name : Eshop
Subject : Web Programming I
Project : Tour Video
Languages and Technologies :

JAVA INSTITUTE FOR ADVANCED TECHNOLOGY
PCJT Software Engineering Degree - BEng (Hons) Software Engineering

The Java Institute for Advanced Technology is a leading research-based higher education institute in Sri Lanka. It is an ISO 9001:2015 certified institute that is registered under the Tertiary and Vocational Education Commission (P01/0537).

The Software Engineering qualification conducted by Java Institute is credit rated under the Scottish Credit and Qualifications Framework (SCQF) and the European Qualifications Framework (EQF).

Java Institute offers the BSc (Hons) in Software Engineering Top Up, validated by the Birmingham City University - UK, as well the BEng (Hons) in Software Engineering full degree from IIC University of Technology - Cambodia, which are recognized by UGC Sri Lanka.

OBJECTIVE OF PUBLISHING THIS POST: TO GIVE AN EXAMPLE OF USING SOCIAL MEDIA AND ONLINE PLATFORMS TO SHARE CONCEPTS AND FOR THE KNOWLEDGE ENHANCEMENT OF THE YOUNG GENERATION.

Program the message viewing and replying process

Web Programming I - Eshop
Project Name : Eshop
Subject : Web Programming I
Project : Program the message viewing and replying process
Languages and Technologies :

JAVA INSTITUTE FOR ADVANCED TECHNOLOGY
PCJT Software Engineering Degree - BEng (Hons) Software Engineering

The Java Institute for Advanced Technology is a leading research-based higher education institute in Sri Lanka. It is an ISO 9001:2015 certified institute that is registered under the Tertiary and Vocational Education Commission (P01/0537).

The Software Engineering qualification conducted by Java Institute is credit rated under the Scottish Credit and Qualifications Framework (SCQF) and the European Qualifications Framework (EQF).

Java Institute offers the BSc (Hons) in Software Engineering Top Up, validated by the Birmingham City University - UK, as well the BEng (Hons) in Software Engineering full degree from IIC University of Technology - Cambodia, which are recognized by UGC Sri Lanka.

OBJECTIVE OF PUBLISHING THIS POST: TO GIVE AN EXAMPLE OF USING SOCIAL MEDIA AND ONLINE PLATFORMS TO SHARE CONCEPTS AND FOR THE KNOWLEDGE ENHANCEMENT OF THE YOUNG GENERATION.

Using MySQL Workbench Software or HediSQL Software to create a table in the database

This video explains how to use the mysql command line client to restore a backed up database.

Explain the DDL Query used to back up the created database

This video explains how to use the mysql command line client to backup the created database.

Create a query statement relevant to updating, searching and creating a view of the data in the tables in the database

This video explains how to write a DML query to update data and search data using the created table and also how to create a SQL view.

Explain how to insert a new column with a DDL query and how to insert data into a created table

This video explains how to write the DDL query used to insert a new column into a table created for a given problem and the DML query used to insert data.

Explain how to insert data into tables created using DDL Query

This video explains how to write a DML query used to insert data into a table created for a given problem.

Explain how to create a table with foreign key using DDL Query

This video explains how to write a DDL query to create a table with a foreign key for a given problem.

Create a database with DDL Query and explain how to create a table using the created database

This video explains how to create a database and table using the ddl query for a given problem.

Program the product selling history page including product searching, viewing pending delivery products and daily selling products process

Web Programming I - Eshop
Project Name : Eshop
Subject : Web Programming I
Project : Program the product selling history page including product searching, viewing pending delivery products and daily selling products process
Languages and Technologies :

JAVA INSTITUTE FOR ADVANCED TECHNOLOGY
PCJT Software Engineering Degree - BEng (Hons) Software Engineering

The Java Institute for Advanced Technology is a leading research-based higher education institute in Sri Lanka. It is an ISO 9001:2015 certified institute that is registered under the Tertiary and Vocational Education Commission (P01/0537).

The Software Engineering qualification conducted by Java Institute is credit rated under the Scottish Credit and Qualifications Framework (SCQF) and the European Qualifications Framework (EQF).

Java Institute offers the BSc (Hons) in Software Engineering Top Up, validated by the Birmingham City University - UK, as well the BEng (Hons) in Software Engineering full degree from IIC University of Technology - Cambodia, which are recognized by UGC Sri Lanka.

OBJECTIVE OF PUBLISHING THIS POST: TO GIVE AN EXAMPLE OF USING SOCIAL MEDIA AND ONLINE PLATFORMS TO SHARE CONCEPTS AND FOR THE KNOWLEDGE ENHANCEMENT OF THE YOUNG GENERATION.

Explain how to create a Relational Algebra Query using Rename Operation related to a given need

This video aims to illustrate how to write a relational algebra query using the relational algebra operator used in the rename operation for a given problem.

Explain how to create a Relational Algebra Query and a Relational Algebra Query related to a given query using Select Product related to a given need

This video explains how to write a relational algebra query using a relational algebra operator that fits a given problem and how to write a relational algebra query that fits a given SQL query.

# SQL_query