Read Aloud the Text Content

This audio was created by Woord's Text to Speech service by content creators from all around the world.

Text Content or SSML code:

Hello everyone, welcome to the demo video of Music-Store-Data-Analysis. In this video I'll walk you through the steps of the program . Let's get started! First we'll create a database using the "create database" command. I have created a database named Music_Store_Project. Then we'll use it using the "Use" command. After creating and using a database, we'll import data using excel.csv file. I have imported 11 tables into the data base. You can see on the left side. After importing data, we can see data using "select * from the album". Here my table name is album. You can see all the data on the table using the "select * from the table name" command. After seeing the data, we'll find out who is the most senior employee, and we'll also find the name and job title of that employee. To get an output, we have to use "SELECT first_name,last_name, title FROM employee ORDER BY levels DESC limit 1;" command and then we have to run it. As you can see, a table comes with the employee's first name, last name and their job title. After getting an output, let's move on to the next query. In this query we have to find out "which countries have the most Invoices?" to find the most invoices from the country, we'll use the "WITH" Clause. A clause is used to create temporary tables, which are further used in the main SQL queries. You can see I have already returned a command, so let's run this . You can see the USA is the country which has the most invoices, which is 131.Let's move on to the next query. In this query we have to find out the top 3 values of invoices.Let's run the query ", as you can see, we have found out the top 3 invoices, which are 23.76, 19.8, 18.81. Further, move on to the next query. We have to find out which city has the most total invoices. As you can see, Prague is the city which has the highest number of total invoices. Now let's find out who is the best customer? For finding, we have joined two tables using the inner join keyword. The INNER JOIN keyword selects records that have matching values on both tables. As you can see, Frantiaiek Wichterlova is the customer who has spent most. Further, move on to the next query. We want to find the most popular music genre for each country. This query we'll use, with clause and inner join keyword together, so let's run it and find out the output you can see. After analyzing all the i have visualized it using Power BI you can see here. Thank you for watching my demo video i hope you find it informative.