Monthly Archives: August 2014

SQLTea – New SQL tutorial app in Google play store

By | August 18, 2014

SQLTea – Our new SQL Tutorial App on Google Play Store We are happy to announce our new SQL tutorial app SQLTea  ( Native android app) for SQL learning which includes articles from this blog. This application includes  1) Articles for basic concepts like Normalization, Constrains, Joins, SQL Functions, SQL commands etc and also advance… Read More »

How to restore database backup in SQL SERVER

By | August 17, 2014

In this article, I am going to explain the process of  Database restoration using the SQL Server Management Studio. In this article, I will try to explain this process in a simple way so that a database developer having little knowledge of DBA can restore that database using the database backup. For database restoration process,… Read More »

How to take Database backup in SQL SERVER

By | August 17, 2014

Introduction This article explain the simple way to take the database backup in SQL SERVER which can be easily understandable by the database programmer having little knowledge of DBA. For taking the database backup, we need to follow the given step.Step 1:- Open the SQL Sever Management Studio. For this we have to follow the following… Read More »

Database Creation using SQL Sever Management Studio (SSMS)

By | August 17, 2014

In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command. In this article, I am going to explain the steps of creation a database using SQL Sever Management Studio (SSMS) using SQL Server 2008 R2. These below database creation steps will be same for SQLServer… Read More »

Database Creation using Create Database command

By | August 17, 2014

In SQL Server, database can be created by 2 ways:-  Using Create Database command  Using SQL Sever Management Studio (SSMS). In this article, I am going to explain the database creation using the command CREATE DATABASE. Syntax for creating a database through Create database command is given below:- CREATE DATABASE  ‘Database name’ ON  PRIMARY  … Read More »

AVG() function in SQL Server

By | August 14, 2014

Avg():- This function is used to get the average value of a numeric column Syntax:-       SELECT AVG(column_name) FROM table_name In this article, we are going to use the following table for some examples:- CREATE TABLE [dbo]. [Employee]( [Empid] [Int] IDENTITY (1, 1) NOT NULL Primary key, [EmpNumber] [nvarchar](50) NOT NULL, [EmpFirstName] [nvarchar](150) NOT NULL,… Read More »

UPPER() function in SQL Server

By | August 14, 2014

UPPER():- This function is used to convert the value of a column to upper case.  Syntax:    SELECT UPPER(string) OR Select UPPER(Column name) from tablename For example,   SELECT UPPER(‘Vivek’) Result:    VIVEK Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on… Read More »

LEN() function in SQL Server

By | August 14, 2014

LEN():- This function is used to get the length of the given string value.   Syntax:-     Select len (stringvalue)   For example,     Select len(‘Vivek Johari’)    Result:-    12 Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases… Read More »

LOWER() function in SQL Server

By | August 14, 2014

LOWER():- This function is used to convert the value of a column to lower case  Syntax:-  Select LOWER (string)    or    SELECT LOWER(column_name) FROM table_name For example, SELECT LOWER(‘Vivek Johari’) Result:- vivek johari Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience… Read More »