OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog

PostgreSQL Unit Testing Suite

Backend made with PL/PGSQL language

Create trigger and trigger function in PostgreSQL

Solutions for common SQL questions in interviews.

Overall, the NameConcatenation query combines the values of two distinct columns into a single column, which is designated as "Fullname" using the "AS" keyword as an alias, providing a succinct and effective method to get and display the complete names of students in a PostgreSQL database. 

The ID-Based Filtering PostgreSQL query returns all columns from a table for a specified value.

This is a PGSQL statement that updates a record in the table of a database.

To delete a record, this SQL query uses the DELETE clause.

This SQL code retrieves all records from the "students" table where the first name is "Dale" or the last name is "Cook". It uses the OR clause as a logical operator to specify an alternative condition to filter the records.

This SQL query retrieves all columns (or a subset of columns) from the "students" table

This SQL query is designed to search for names in a table using the LIKE and ILIKE operators.

This SQL query returns the last name, first name, student ID, and class ID of students with the first name 'Thomas' who are enrolled in 'COMPSCI101'. It filters results based on these conditions using a WHERE clause.

In the students table, this PostgreSQL query retrieves the first name, last name, student ID, and class ID for each student, with the student ID and class ID being sorted by ascending and descending order, respectively.

Two PostgreSQL SQL queries are available in this repository that may be used to retrieve information from a database in this case a students database.

数据云后台管理系统（我们不生产数据，只做数据的搬运工）

HTML from your Postgres Database

This project used the relational database to create the data structure for a vet clinic. In addition to showing how to design a data structure, it also shows how to query and update data, a query from different tables, join tables, and other features.

A React project I prepared for the database assignment.

Tigerline USA admin datasets to PG and ELK