Hello guys, if you are wondering whether to choose a NoSQL database like MongoDB, Cassandara, or MySQL for your application then you have come to the right place. In an earlier article, MySQL vs PostgreSQL I had shared the pros and cons of choosing MySQL over PostgreSQL for your application, and in this article, I am going to show the benefits and drawbacks of choosing MySQL over NoSQL or vice-versa.
Blog to learn about SQL, database, Oracle, SQL Server, MySQL, PostgreSQL concepts and much more.
Saturday, March 26, 2022
Monday, March 21, 2022
How to do Pagination in SQL Server? Query Example Tutorial
What is pagination?
Saturday, March 19, 2022
Transposing data in SQL - Example Tutorial
What is Transposition?
A transposition is when data is rotated from one row or column to another in order to modify the data layout and make observations from a different perspective. Row to the column, column to column, and bidirectional transposition are examples of basic transposition algorithms. Others, such as dynamic transposition, transposition with inter-row computations, and join-based transposition, are more complicated. All are prevalent in data analytics and so worthy of investigation.Thursday, March 17, 2022
SQL cross join Example and it's performance
Hello guys, in the past, I gave you a quick overview of SQL JOINS where we learned about different types of JOINS like right, left, inner, and outer join, and in this article, we'll learn about the SQL CROSS JOIN idea in this post, and we'll back up our knowledge with simple examples and illustrations. So, let's start with the basics.
Tuesday, March 15, 2022
Difference between DDL and DML commands in SQL with examples
What are SQL commands?
Saturday, March 12, 2022
MySQL vs PostgreSQL? Pros and Cons
Which database to choose?
Tuesday, March 8, 2022
What is Virtual columns in MySQL and How to use it? Example Tutorial
What is a Virtual Column and where is it used?
Friday, March 4, 2022
Top 5 Common Errors and Mistakes in SQL and How to Solve Them
After writing some SQL code, you're ready to query your database. You type in the code, and nothing happens. Instead, you're presented with an error notice.
Don't give up! SQL, like any other computer language, is prone to coding mistakes. We'll go through a few frequent mistakes individuals make while creating SQL in this tutorial.