# Mastering SQL Through Practice: Exploring Sylvia Moestl Vasilik’s Exercises — Part 1

Welcome to my Blog on solving queries from **Sylvia Moestl Vasilik’**s book! In this tutorial, we will be working through a series of **57 questions** that are featured in Vasilik’s book, a popular resource for learning about MySQL and relational database management.

![](https://cdn-images-1.medium.com/max/800/0*mKEMUJOqxf3cJe77)

A guide to Structured Query Language

Starting from the basics and progressing to more advanced concepts, this tutorial is designed to provide a comprehensive learning experience for anyone looking to master MySQL.

Whether you are a beginner looking to learn the fundamentals of MySQL or an experienced developer looking to brush up on your skills, this series of blogs is for you. We will provide step-by-step instructions and explanations for each topic, so you can understand how MySQL works and how to effectively use it to manipulate data.

**In this first blog, we will walk you through the process of installing MySQL on your computer.** Subsequent blogs will focus on different levels of MySQL queries, including primary, intermediate, and advanced.

By the end of this series of blogs, you will have a solid foundation in MySQL and be well-equipped to tackle more advanced queries and tasks.

**Let’s get started with the installation of MySQL!**

**Step 1:** Go to this website:

[**MySQL :: MySQL Workbench**  
*MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data…*www.mysql.com](https://www.mysql.com/products/workbench/ "https://www.mysql.com/products/workbench/")[](https://www.mysql.com/products/workbench/)

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703051232606/b9c744a5-34ad-4c1f-9e88-556f5f95f4ba.png)

Click Download Now

**Step 2:** Select the **Download Now** button. The page will then appear. You must select whether you require the software for Windows or Mac when downloading it. Then Click on **Download.**

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703051235010/5743f6fe-cc4b-4488-bf34-7af25b3faff9.png)

Select OS

**Step 3:** After installation, **launch MySQL Workbench.**

SQL Homepage

**Step 4:** To make a new connection to your database, click the above **(+)symbol** beside the MYSQL Connections.

Create new Connection

**Step 5:** Now enter the following information. Enter “**Northwind**” as the Connection name, “**localhost”** as the Hostname, and “**Northwind”** as the Default Schema.

> Note: In our blogs, we will be using the Northwind database to solve our queries.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703051236481/830078f3-2932-4c4e-9550-c8954eb66afb.png)

Enter the Details

**Step 6:** To solve these problems, we’ll have to obtain the **Northwind database** from the website provided below.

[**GitHub - emiliawk/sql\_practice\_problems: This repository contains my solutions to the intermediate…**  
*This repository contains my solutions to the intermediate and advanced problems from the "SQL Practice Problems" book…*github.com](https://github.com/emiliawk/sql_practice_problems "https://github.com/emiliawk/sql_practice_problems")[](https://github.com/emiliawk/sql_practice_problems)

**Step 7:** Now, Extract the file of the Northwind database. In the Northwind database, under the **Management Section**, go to the **Data import** wizard.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703051238101/3cde697b-e504-47cb-92c0-0bc1ac8bb4dc.png)

Extract Database

**Step 8:** Choose **Import** from Self-Contained File, then navigate to the extracted Northwind Database folder and pick the **northwind.sql file.** Choose **“Northwind”** as the default schema. Finally, begin the import.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703051239923/b0ff1c5f-6a46-46c1-93a1-3304be203d43.png)

Import Database

**Step 9:** Step 8 should be repeated with the northwind-data.sql file.  
After completing the above steps, you are ready to work on the Northwind database in MySQL Workbench’s SQL query tab.

> This was the first blog on SQL installation; the upcoming blogs will focus on answering the 57 questions from Sylvia Moestl Vasilik’s book. Stay tuned for the rest of the blogs so you may have a better understanding of SQL by answering these questions.

> I hope this blog was informative and provided you with the details you required. If you have any questions while reading the blog, message me on [Instagram](https://www.instagram.com/acanubhav94/) or [LinkedIn](https://www.linkedin.com/in/anubhav-chaturvedi-a7465a72/). Special credits to my team member — [Atharva.](https://www.linkedin.com/in/atharva-dongre-260826200)

> Thank You…