Database

how to become a data scientist with no experiance

Who is a Data Analyst?

Nowadays, companies receive a tremendous amount of information every day that can be used to optimize their strategies. To get insights from the massive data collected, they need a highly qualified professional: the Data Analyst.

The task of a Data Analyst is to process the varied data concerning the customers, the products or the performances of the company, in order to release indicators useful for the decision-makers. Thus, the information provided by the data analyst enables companies to define the products to be offered to customers according to their needs, the marketing strategy to adopt, or the improvements to be made to the production process.

Read more

DBMS Nomralization

When developing the schema of a relational database, one of the most important aspect to be taken into account is to ensure that the duplication is minimized. This is done for 2 purposes:

  • Reducing the amount of storage needed to store the data.
  • Avoiding unnecessary data conflicts that may creep in because of multiple copies of the same data getting stored.

Normalization in DBMS

Database Normalization is a technique that helps in designing the schema of the database in an optimal manner so as to ensure the above points. The core idea of database normalization is to divide the tables into smaller subtables and store pointers to data rather than replicating it. For a better understanding of what we just said, here is a simple example:

Read more

MongoDB

Overview and History

MongoDB is a powerful, highly scalable, free and open-source NoSQL based database. MongoDB was initially released approximately 9 years ago on 11th of February, 2009 and has since then achieved the position of the leading NoSQL database. The company MongoDB Inc. (New York, United States) maintains and manages the development of MongoDB. They also provide the commercial version of MongoDB which includes support also. The source code of MongoDB is available on Github.

Read more

MariaDB vs MySQL

MySQL is one of the most widely used databases across the world. It is free and is open-source as well. Developed in C/C++, MySQL is one of the most popular database choices.

The database was started by a Swedish company “MySQL AB” in 1995. MySQL AB was later acquired by Sun Microsystems in 2008. Later, Sun Microsystems was acquired by Oracle in 2010. Since then, MySQL is maintained and managed by Oracle.

Read more