SQL Tutorials


SQL Comment – Single line and Multi-line Comment

1. Objective – SQL Comment In our last SQL tutorial, we discussed the SQL Stored Procedure. Today, we will see SQL Comment. Moreover, in this tutorial, we will see the single line and multi-line SQL Comment. Moreover, we will discuss Comment Indicators in SQL. So let’s start the SQL Comment tutorial. 2. What are the Comments in SQL? SQL Comments are not supported in Microsoft Access databases and thus we use Firefox and Microsoft Edge. SQL Comment Syntax The two […]

SQL Comment - Single line and Multi-line Comment

Stored Procedure in SQL - Syntax and Example

Stored Procedure in SQL – Syntax and Example

1. Objective – Stored Procedure in SQL In our last SQL tutorial, we discussed COUNT function in SQL. Today, we will see the Stored Procedure in SQL Server. Moreover, we will discuss SQL Stored Procedure example. Also, we will look at how to save and create Stored Procedure in SQL.  So, let us start the SQL Stored Procedure tutorial. 2. What is the SQL Stored Procedure? A stored procedure in SQL is a type of code in SQL that can be […]


COUNT Function in SQL Server – Applications & Parameters

1. Objective In our last SQL tutorial, we discussed SQL Cursor. Today, we will see COUNT Function in SQL. Moreover, in this SQL COUNT Function tutorial, we will discuss parameters and example. Also, we will see SQL COUNT Function applications. Along with this, we discuss Tables and diagrams in COUNT Function in SQL. So, let us start COUNT Function in SQL Tutorial. 2. What is the COUNT Function in SQL? The SQL COUNT function returns the number of columns in […]

COUNT Function in SQL Server - Applications & Parameters

Cursor in SQL - Types, Uses, and Terminologies

Cursor in SQL – Types, Uses, and Terminologies

1. Objective – Cursor in SQL In our last SQL Tutorial, we discussed SQL Query Optimization. Today, we will see Cursor in SQL. Moreover, in this SQL Cursor tutorial, we will see parts and terminologies of SQL Cursor. Also, we will see different types of Cursor in SQL and Uses of SQL Cursor. At last, we will learn different kinds of lock with the help of SQL Cursor example. So, let’s start the SQL Cursor tutorial. 2. What is the […]


Latest SQL Interview Questions and Answers – 2018

1. Top SQL Interview Questions and Answers So, we have already discussed part 1 of SQL Interview Questions and Answers. Today, we will see Top SQL Interview Questions and Answers Part 2. This part of SQL Interview Questions contains all types of questions asked in SQL Interview. We have also divided these SQL Interview Questions and Answers into 4 different categories. These categories are basic, advanced, practical and SQL Interview Questions for experienced. Many times you will face the interview […]

Latest SQL Interview Questions and Answers - 2018

SQL Query Optimization Tools | Query Tuning Tips

SQL Query Optimization Tools | Query Tuning Tips

1. Objective In our last SQL tutorial, we discussed SQL Subqueries. In this session of SQL, we will see SQL Query Optimization or SQL Query Tuning. Moreover, we will learn different techniques for optimizing or tuning a query in SQL.  Also, we will see SQL Query Optimization examples. So, let us start the SQL Query Optimization tutorial. 2. Introduction to SQL Query Optimization SQL Statements are used to recover data from the database. We can get the same outcomes by […]


SQL Subquery – Types of Subqueries in SQL

1. Objective – Subquery in SQL In our last tutorial, we discussed SQL Sequence. Today, in this SQL tutorial, we are going to learn about SQL Subquery. First, we will see the meaning of Subqueries in SQL. Moreover, we will look at types of SQL Subquery with syntax and example. So, let us start SQL Subquery tutorial. 2. What is SQL Subquery? A Subquery or Inner query or a Nested query in SQL is a query inside another SQL query […]

SQL Subquery - Types of Subqueries in SQL

SQL Sequence

Create SQL Sequence – Syntax and Example

1. Objective In this SQL tutorial, we are going to learn about SQL Sequence. Moreover, we will start our tutorial, with the meaning of SQL Sequence. Also, we will see syntax and example of SQL Sequence. So, let us start SQL Sequence Tutorial. 2. What is SQL Sequence? The sequence in SQL is a set of integers that are supported and generated by database systems to produce on demand unique values. You must know about SQL Operators Following are the […]


Top SQL Interview Questions and Answers for 2018

1. SQL Related Interview Questions Today, we are not going to discuss any SQL Concept. Instead, we will prepare you for your next SQL Interview. So, here we are giving you top SQL Interview Questions with answers. We have isolated this SQL Questions asked in the interview on the basis of  – Tough SQL Interview Questions Basic SQL Interview Questions Advanced SQL Interview Questions SQL Practical Interview Questions All these SQL Interview Questions are designed by SQL experts. Go through […]

Top SQL Interview Questions and Answers for 2018

Operators in SQL - Alias, IN and Between

Operators in SQL – Alias, IN and Between

1. Operators in SQL In this SQL tutorial, we are going to see Operators in SQL. Moreover, we will study the IN, Between and Aliases operators in SQL. Also, we will discuss these SQL Operators with syntax and example So, let us start exploring Operators in SQL. 2. Introduction to SQL Operators The IN SQL Operator is used as a shorthand for multiple OR conditions and also helps to specify multiple values in a WHERE clause. An Alias SQL Operator […]