October 29, 2020

SQL Queries Optimization Tips

Every time we writes lot of SQL queries. But most of the time we don’t consider its efficiency. Query optimization is the vital process for any database related applications. Its …

Read More

SQL Join

In a relational database, SQL join is a very important feature. SQL Joins are used to get data from other tables. It is a part of SQL query that retrieves …

Read More

What is SQL Injection?

This article describes about the basic overview of SQL Injections and how to protect it?. Summary of the article: SQL Injection How to Prevent SQL Injection? SQL InjectionSQL Injection is …

Read More

SQL Server Replication

Replication is one of the rich features available in MS SQL Server. It is the process to distribute data to various servers. Its advantage is high.This article describes SQL Server …

Read More

What are the SQL statements?

This article describes about SQL statements. Summary of the article: What are the SQL statements? Data Definition Language (DDL) Statements Data Manipulation Language (DML) Statements Data Control Language (DCL) Statements …

Read More

What is Database Schema?

The database schema is the logical view of the entire database. It is a set of database objects (tables, views, functions etc.). This article describes about the database schema and …

Read More

MySQL

MySQL is the world’s most widely used open source database management software. For its cost effective and high performance features it is commonly used with many programming language (especially PHP) …

Read More

Difference Between DDL and DML

This article describes about the basic overview of DDL and DML and their difference . Summary of the article: Data Definition Language (DDL) Examples of DDL Data Manipulation Language (DML) …

Read More

What is Database Object?

The database objects are the core component for any database system. This help use to store and retrieve data easily. This article describes about basic overview of Database Object . Summary …

Read More

Database Trigger

In database, trigger is a set of SQL statements or queries that automatically fires actions when a specific operation occurs. It is used to ensure the coordinated performance of related …

Read More

Stored Procedure

Stored Procedure is an attractive feature of a relational database that contains some SQL statements and perform predefine task based on creator demand. Most the relational database support stored procedure, …

Read More

Relational Database Management System or RDBMS

Relational Database Management System is computer software/program that is developed based on relational model. At present most modern commercial and open-source database systems are using RDMS. This article explains what …

Read More

Database Management System or DBMS

DBMS is the process to store and retrieve information. This article describes about the basic overview of  DBMS or Database Management System. Summary of the article: What is Database? What …

Read More

SQL BETWEEN operator for datetime

This article describes about the SQL between operator, how to use SQL between operator in date time operation? Create a Temp table. For the sql query is Create Table #Temp …

Read More

SQL Server Database Backup

Backup is an vital part for any database system. It reduce accidental data loses. This article describes how to create a database backup in SQL query. Summary of the article: …

Read More