In the last decade and with the appearance of Big Data, companies that stored details of their clients are interested in applying data analysis: Analytical Methods for big data Assignment, CCT, Ireland

Learning outcome:-

• Understand the foundations of Data storage.
• Be able to write data retrieval queries and evaluate the result set.
• Be able to write SQL statements to extract data.
• Understand the structure of relational databases to extract information.
• Prove knowledge to extract relevant information from MySQL and use it in non-SQL language software.
• Understand the importance of visualizations to represent the data contained on the tables stored.

Introduction

In the last decade and with the appearance of Big Data, companies that stored details of their clients are interested in applying data analysis methods to understand the behavior of their customers and to make predictions that may help in future campaigns, promotions, communication, and investing.

An important multinational company that manages car showrooms around the world hires you as Business Consultant and facilitates for you a folder that holds a database called “cars_database” which contains data about the company, and a diagram to understand the structure of the database. The company aims to get valuable information and advice for future steps in the business.