MySQL is the most popular open-source database in the world. MySQL is a Relational Database Management System (RDMS) which is used to store data in a relational manner inside different tables. What makes MySQL different...
MS SQL Server provides some functions in order to make database administrators life easier. A typical database store different type of values. In some cases, we may need to cast and convert these values into...
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 databases data in different ways...
Apache Kafka is a distributed streaming platform. Let’s explain it in more details. Apache Kafka is three key capabilities where publish and subscribe to streams of records, similar to a message queue or enterprise messaging...
The server is a computers type which consists of purposeful hardware and software used to provide different services to the clients. Servers generally use different and special applications to provide services. A server can contain...
MySQL or MariaDB database servers can be managed in different ways. Generally, GUI tools are provided because of their easiness. But in some cases command line connection may be required to connect and management MySQL...
During the connection to the Oracle Database server with the sqlplus we may get an error with the ORA-12162 specifier. This error will prevent to connect to the Oracle Database Server. “ORA-12162: TNS:net service name is...
sqlplus or sqlplus64 tools are used to connect and manage Oracle Databases. sqlplus64 is 64 bit version of the sqlplus. After installating these tools successfully when we try to run sqlplus command we may get...
Oracle is very popular database which is used by big enterprises, banks, governments etc. Oracle Database provides a lot of useful features to the MS SQL, PostgreSQL, MySQL etc. Oracle Express is lightweight database server...
SQL Programming language and SQL Database engines provide some useful mechanisms in order to make management of the data easier. SQL View is one of them which can be used to create a table from...
