SQL

database

How to Resolve Error 823 Affects SQL Server Database Recovery?

What Causes SQL Fatal Error 823? 3 methods to Fix Error 823 Affects SQL Server Database Recovery.

interview questions

SQL Query Interview Questions for Freshers and Experienced

Most common SQL query interview questions and answers for freshers and experienced.

database

Top 10 SQL Query Concepts for Job Interview

You should know these SQL concepts for job interview whether you are freshers or experienced candidate.

MySQL

SQL Join (Inner, Left, Right, Full) with Example

SQL join clause explained with examples. SQL query for Inner, Left, Right and Full join. Interview questions on table Join operations.

MySQL

Important MySQL Commands | How to Use MySQL Explained with Examples

[Complete MySQL tutorial] Important MySQL Commands to create a database, select and drop table. How to use MySQL queries?

database

Difference Between CHAR and VARCHAR and VARCHAR2

What is the difference between CHAR and VARCHAR data types in database SQL table? How is VARCHAR different from VARCHAR2?

db

Select SQL Command | Aggregate Functions with Example

Select SQL commands syntax and example explained with different filters like ‘where’, ‘group by’, ‘having clause’ and ‘order by’ clause in MySQL database.