Blog / Database / MariaDB / MS SQL / MySQL / Oracle / PostgreSQL / SQlite
by İsmail Baydan · Published 23/05/2019
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...
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...
Blog / Database / MariaDB / MS SQL / MySQL / Oracle / PostgreSQL
by İsmail Baydan · Published 08/11/2018 · Last modified 23/12/2018
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...
Blog / Database / MS SQL / Windows / Windows 10 / Windows 7 / Windows 8 / Windows Server / Windows Server 2008 / Windows Server 2012 / Windows Server 2016
by İsmail Baydan · Published 07/11/2018 · Last modified 10/11/2018
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...
Blog / Database / MariaDB / MongoDB / MS SQL / MySQL / Oracle / PostgreSQL / SQlite
by İsmail Baydan · Published 17/09/2018
SQL or Structured Query Language is a standard language used to to create, list, update, delete databases, tables, records. It provides this functionality with different type of commands. In this tutorial we will learn popular and useful SQL commands. Command Types SQL language is very advanced language which provides large...
Database / MariaDB / MongoDB / MS SQL / MySQL / Oracle / PostgreSQL / Redis / SQlite
by İsmail Baydan · Published 01/09/2018
SQL provides different statements in order to select into existing table, variable, temp table in various database servers like Oracle, MySQL, PostgreSQL etc. In this tutorial we will examine how to use Select Into SQL statement for different cases. Syntax Select Into statement syntax is the same as with Select syntax....
MySQL is very popular and open source database server. Python is old but lately discovered language. In this tutorial we will look how to use this popular techs in our applications in order to run sql queries. Install Python MySQL Connector In order to connect MySQL database from Python application...
Blog / Database / Linux / MariaDB / MySQL
by İsmail Baydan · Published 27/03/2017 · Last modified 30/11/2018
MySQL database is very popular database server used by a lot of small and big companies. In this tutorial we will look the basics of MySQL server like creating database and tables, populating data into tables. MySQL installation can be done with the following tutorial for Linux operating systems. How...
Blog / Database / MariaDB / MongoDB / MS SQL / MySQL / Oracle / PostgreSQL / SQlite
by İsmail Baydan · Published 16/10/2016 · Last modified 11/06/2019
Sql is the language where a lot of data can be get with different logic. In an enterprise environment we may need to use complex SQL queries to get meaningful data. Inner is one of the logic where we join two tables with different magic. Example Tables In order to...
