Skip to main content

Posts

Showing posts with the label SQL

Windows Functions in SQL

Introduction Data and Data, all we can see around us is a world completely surmounted by data, huge or small doesn't matter much. Everywhere we can see is data running our world. Some legends have rightly said  "Data is the Fuel of Future" If we sit down and analyse the world around us right now, we can notice he was truly a legend who said these lines. From the mobile phone, we use to the Television, roads, vehicles, etc. etc everything is using the data and extensively using it. From the recommender systems to the automated machines everything consumes the data that we once generated and is now delivering services through it.  But such a huge amount of data gives birth to many problems like storage & analysis. Though we have traditional technologies like SQL & the latest technologies like Hive, Spark, Pig to handle these Big data, its important to know how they work.   Let me tell you an amazing fact about these techs also uses SQL under the hood & deliver s

SQL VS NoSQL

What is SQL Structured Query Language is also known as SQL is one of the most commonly used querying languages across the world. Ever since its inception, demand for SQL is growing and has been able to find its root from a small startup to a mammoth company. One of the biggest factors for its popularity is most of the software that is present in the market are Open-Source, Easy to grasp and install.  What is NoSQL  Non-SQL or NoSQL is used for querying the data outside the traditional SQL databases. This is because of the distributed architecture. NoSQL is also known as Not Only SQL because it is can still store the data stored by traditional SQL, only the way of storing differs. They can also differ based on data models. The most common data models are document, key-value, column, and graph. Let's dive deeper and try to find the dissimilarities between the two. 

SQL --- Structured Query Language

  What is SQL? Structured Query Language is also known as SQL is the database language and is one of the most famous and in-demand technology.  This language was specially developed for database management i.e. creating a database, inserting and updating records in them, managing accesses and retrieving data from it. SQL is mostly used for Relational Database Management Systems.  Its demand is increasing every single day. As there is an increase in data, demand and need for SQL increases. It is been used by web developers, data analysts, data engineers, and in every other field where we need to store and retrieve data.  One of the main reasons why SQL is gaining popularity is that it is simple, easy, quick, and powerful. Another reason is that the most commonly used version of SQL(MySQL) is open-source(FREE) Another great feature of  SQL is Non Procedural language(explained in the next section).