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 and constraints. In this tutorial, we will learn how to update database table data with...
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 system. Apache Kafka provides a distributed publish-subscribe messaging system and robust queue that can handle...
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 a single service or multiple services to serve. Types Of Servers There is a different...
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 and MariaDB database server. Install MySQL/MariaDB Client For Ubuntu, Debian, Kali, Mint We will start...
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 incorrectly specified” Error This error will be look like below. This error is caused by...
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 an shared object file or library error. sqlplus Shared Library Error sqlplus command shared library...
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 provided by Oracle. We can use Oracle Express Edition without a fee. Oracle Express Edition...
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 a SQL result set. What Is SQL View? SQL View is a virtual table which...
SQL Server is a service running on Windows operating systems. In order to manage this SQL server service and instances with GUI we need to install Microsoft SQL Server Management Studio. Download Microsoft SQL Server Management Studio We will download the installer application from the following link. https://go.microsoft.com/fwlink/?linkid=2014306 Start The...
Microsoft SQL Server is provided with different licenses. Free version is named Express Edition . Express Edition is very useful if we need a little database. Download We will download the SQL Server 2017 Express Edition from following link which is provided by Microsoft. https://www.microsoft.com/en-us/sql-server/sql-server-editions-express Start Installation We will download...
