Tag: 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.

MongoDB

9 Difference between MySQL and MongoDB

What is the difference between MySQL and MongoDB? MongoDB vs MySQL in tabular form.

NoSQL

9 Difference between SQL and NoSQL | Example, Use, Advantages

What is the difference between SQL and NoSQL database/DBMS? Advantages explained with example. Which one to use?

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?

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.