Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

We perform maintenance operations in SQL Server using Maintenance Plan. In this article we will create a maintenance plan for Log Backup. I will share …

With Distinct Clause, you can return only one of the recurring records as a result when reading data from the table. In other words, if …

  When reading data from the database, we can use GROUP BY clause when we want to group data and process on the groups we …

  I would like to talk to you about a new Built-in Function, CONCAT, that comes with SQL Server 2012. As you know, before SQL …

  ERROR: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data) EXPLANATION: I received an error message when I wanted to import a …

  Oracle Flashback Query allows us to query as much as possible of the past committed data. We can query the data in the past …

We perform maintenance operations in SQL Server using Maintenance Plan. In this article, we will create a maintenance plan for differatial backup. I will share …

  With Order By Clause, you can sort the records returned as a result of the Select statement as ascending or descending according to the …

  We use WHERE clause to filter when reading, updating, and deleting data from a table. If we run select, Update, or delete statements without …

  When reading data from tables, we may need to give different names to tables and columns. We can do this by defining alias to …