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?
Pagination,
often known as paging, is a method of breaking down huge amounts of
material into smaller, distinct pages. Pagination is a popular feature
of online applications, as evidenced by Google. The primary principle of
pagination is that when we search for anything on Google, the results
are displayed on a different page.
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?
SQL
commands are just that: commands. It's used to send and receive data
from the database. It may also be used to carry out particular
activities, functions, and data searches.
SQL can build tables, add data to tables, drop tables, change tables, and define permissions for users, among other things.
Subscribe to:
Posts (Atom)