Database – POFTUT

Category: Database

SQL CAST() Function Tutorial - Cast and Convert A Value To A Specified Data Type In SQL 0

SQL CAST() Function Tutorial – Cast and Convert A Value To A Specified Data Type In SQL

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 different data types. MS SQL provides CAST() function can be used to change data types. CAST() Function Syntax CAST() function has a simple syntax where we will provide the value and the type we want...

SQL UPDATE Statement and Query with Examples 0

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 databases data in different ways and constraints. In this tutorial, we will learn how to update database table data with an SQL UPDATE statement and query single record, multiple records or conditional situations with examples. SQL UPDATE Syntax SQL Update...

What Is Apache Kafka, Use Cases, Advantages and How To Install and Use Apache Kafka? 0

What Is Apache Kafka, Use Cases, Advantages and How To Install and Use Apache Kafka?

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 a high volume of data and enables us to pass message consumption. Apache Kafka Advantages Apache Kafka provides a lot...


What Is A Server In Computing and Server Types?

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 type of servers. We can create a very long list which contains different types of servers but in this part,...


How To Connect MySQL/MariaDB Server From Command Line On Linux and Windows?

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 by installing MySQL/MariaDB command line client in the deb based distributions like Ubuntu, Debian, Kali, Mint etc. The package is...


Oracle “ORA-12162: TNS:net service name is incorrectly specified” Error and Solution

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 not setting $ORACLE_HOME and $ORACLE_SID environment variables for Linux and Windows Operating systems. Check $ORACLE_HOME Environment Variable $ORACLE_HOME is important...


Oracle Database “sqlplus: error while loading shared libraries:” Error and Solution

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 error full definition is like below. Keep in mind that for 64 bit version it will be sqlplus64



How To Install Oracle Express Edition (XE) 18 On Linux?

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 is named as Oracle XE . Download Oracle can be installed into Linux and Unix based operating systems. It is...


How To Create, Use and Delete SQL View?

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 does not exist in a database physically. SQL View table is created from an SQL statement which is generally a...


How To Download And Install SQL Server Management Studio On Windows?

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. Start The Installation Process We will start downloaded installer and we will see following screen which is a welcome screen for the...

Enjoy this blog? Please spread the word :)