database – POFTUT

What Is Relational Database Management System (RDMS)?

What Is Relational Database Management System (RDMS)?

Database systems are an important part of the IT system. Relational Database Management System is a database that mainly stored data in a relational model by creating different relations between different data. Relational Database Management Systems simply called RDMS. RDMS mainly uses the Structured Query Language simply SQL in order to store and query data. … Read more

What Is A Query (Database Query)?

What Is A Query (Database Query)?

Query is a request to an information system to get information for the specific information in which parameters are defined inside the query. The query is mainly used as a database term where database servers are queried for different types of information. Query Parameters An information or database system generally provides a lot of different … Read more

SQL UPDATE Statement and Query with Examples

SQL UPDATE Statement and Query with Examples

SQL databases provide structured data storage capabilities. We can store data in tables with columns and rows. Other useful features for SQL databases are update capabilities. We can update SQL database data in different ways and constraints. In this tutorial, we will learn how to update database table data with an SQL UPDATE statement and … Read more

How To List MySQL Tables with “show tables” SQL Query?

How To List MySQL Tables with "show tables" SQL Query?

MySQL is a popular relational data that stores information in tables. While using tables we generally need to check and list existing tables. We can use different ways to list tables. In this tutorial, we will learn how to use show tables and Select table_name in order to list and print table names. Connect MySQL Interactive Shell … Read more

What Is MySQL Default Port Number?

MySQL is very popular database in the opensource community. While developing applications or connecting MySQL database we need to specify the MySQL port implicitly or explicitly. In this tutorial we will learn MySQL default port number and alternative port numbers. TCP 3306 The default port for the MySQL service is TCP 3306. This port can … Read more

How To Define, Add, Create User For Postgres or PostgreSQL Server?

PostgreSQL Database Server have a lot of tools to manage the suite. Creating user is one of the most popular issue to manage Postgres Database. In this tutorial we will examine how to create user with different rights, privileges, database. We will mainly follow createuser tool for these and createuser is a wrapper for the CREATE ROLE Sql … Read more

How To Install PostgreSQL Server Into Linux, Debian, Ubuntu, CentOS, Mint, Fedora, Redhat?

PostgreSQL is very popular open source database. It is used by big companies like Google, Facebook etc. PostgreSQL can be used without a cost. In this tutorial we will look how to install PostgreSQL into Linux distributions like Debian, Ubuntu, Mint, Fedora, CentOS, RedHat by using different ways like package management or downloading setup file. … Read more

Redis Tutorial

Redis is open source BSD licensed database or key-value store. Redis provides fast and simple data store features mainly used for caching purposes in web applications. Redis is written in C programming language. Supported Data Structures Redis supports following data structures to store and retrieve data. string hash list set sorted set queries bitmap hyperloglog … Read more

Mysql Database Import Tutorial with Examples

Backup and Restore operations are important part of the database administration. mysqlimport command is used to load data in file into Mysql or Mariadb servers. Mysql import is generally used by providing SQLfile. Syntax Syntax of mysqlimport is like below. mysqlimport OPTIONS DBNAME FILE OPTION is used provide detailed configuration DBNAME is the name of the database we … Read more

How To Install and Configure MongoDB NoSQL Database To Linux, Ubuntu, Debian, CentOS, Fedora

How To Install and Configure MongoDB NoSQL Database To Linux, Ubuntu, Debian, CentOS, Fedora

SQL is a very powerful language to query, insert, delete, modify data. In recent years the IT industry has developed some alternative ways to store and retrieve data. NoSQL type database servers become very popular. MongoDB is a NoSQL database server to store and retrieve data. In this tutorial, we will look at how to … Read more