Skip to main content

Posts

Showing posts with the label mysql

Types of NoSQL Databases

  NoSQL Databases are a new form of database that is gaining popularity and are increasingly used daily. Most of the companies are switching to these databases due to the wide variety of their use cases. A famous one that we always keep hearing is the "MongoDB".  But what in actually is NoSQL,  NoSQL term was coined and founded in the 21st century only with the rise in Web2.0(the current face of the internet), due to the increase in unstructured and Big data (Eg. Tweets generated from Twitter, images and videos shared on social media, logs generated by sites, purchase history of a customer etc.)  that was not feasible for the traditional SQL databases to store and process. Thus, NoSQL can be defined as the SQL for the Unstructured and Big data. Still unable to differentiate between SQL and NoSQL..!!! Read it here .  How Data is stored in NoSQL Databases?  So, now coming to the point, when the data generation sources are so different and in various formats then how the data is

Indexes in SQL

What are Indexes in SQL?  Indexes in SQL are like the "Index" page in a book. They hold the information about the various chapters present in the book along with their page numbers. Whenever we need to go to a particular chapter, we look for that chapter in Index, take its page number and directly jump to that page.  Similarly, in databases also, we can think of the tables as huge books, with each row as a new chapter. The tables in databases can be enormous with lakhs and lakhs of rows and finding a particular row as per our need not only becomes hard but also impossible after an extend. Thus, to overcome this issue a simple concept of Indexing is used. These indexes help us in finding the exact row within a matter of seconds no matter how huge our table is.  Thus, using a simple concept taken from our books to our database, we can significantly reduce the time a query takes to get the desired result set. 

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

Getting Acquainted with NewSQL

Introduction NewSQL is a relatively new Database Management System. It is so nascent that it is still not listed as proper DBMS because the rules and regulations are still unclear.  To understand NewSQL, we need to know why the need was raised for a new Database when we already had two great and successful Databases(SQL & NoSQL).  SQL is the most widely used and most preferred database of all time. The ACID properties used for it makes it one of its kind and ranks it higher than the other.  NoSQL is another rising database that has recently gained more limelight due to the rise in Big data technologies and the need to store enormous documents/data coming from different sources. We can read more about the difference between SQL VS NoSQL . 

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). 

SQOOP — How to install in 5 Steps in Windows 10

  An easy to go guide for installing SQOOP in Windows 10. Image taken from Google images 1. Prerequisites Hardware Requirement * RAM — Min. 8GB, if you have SSD in your system then 4GB RAM would also work. * CPU — Min. Quad-core, with at least 1.80GHz JRE 1.8   — Offline installer for JRE  Java Development Kit — 1.8   A Software for Un-Zipping like   7Zip   or   Win Rar * I will be using 64-bit windows for the process, please check and download the version supported by your system x86 or x64 for all the software. Hadoop * I am using Hadoop-2.9.2, you can also use any other STABLE version for Hadoop.  * If you don’t have Hadoop, you can refer to installing it from   Hadoop: How to install in 5 Steps in Windows 10 . MySQL Query Browser Download SQOOP zip * I am using SQOOP-1.4.7, you can also use any other STABLE version for SQOOP. Fig 1:- Download Sqoop 1.4.7