A Database is simply a mess of interconnected Data-tables where you store inter-related data in order to make some descriptive information. In a previous post, I discussed how you can create a Data-table in SQL with examples, just make sure you have read that post before reading this. After a Data-table is created in your…… Continue reading How to INSERT VALUES INTO table in SQL
Category: Database with PSQL
as a programmer it is better to have at least a brief knowledge about database designing. in this category of the blog i will discuss some details of computerized database, and how to create a small database and manage it in your computer using PSQL statements.
how to CREATE a simple table with the Constraints in SQL
Data tables are the most basic building blocks even of a large database. To query a particular data in a table we use SQL(Structured Query Language), and also those tables can be created by using SQL. In this post, you will learn how to create a simple Table in SQL. Just suppose you are responsible…… Continue reading how to CREATE a simple table with the Constraints in SQL
Let’s start your journey from PostgreSQL
In a previous post i discussed about Database Management Systems, there are very famous commercial and non-commercial DBMS’s available on the internet that you can easily download, and some of those DBMS’s need zero SQL knowledge for working on it. however, if you are a software developer or a Database Administrator then you must have…… Continue reading Let’s start your journey from PostgreSQL
What is a computerized database
Simply what is a database and why we need a database, What is a Database As you know, a long time ago all most all the documentations were done by hand writing in order to store them to use again at a particular time. If you have a lots of related data that is written…… Continue reading What is a computerized database
logic behind the code 