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

Anubhav Chaturvedi
4 min readDec 18, 2023

--

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.

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:

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.

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.

Enter the Details

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

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

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.

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 or LinkedIn. Special credits to my team member — Atharva.

Thank You…

--

--

Anubhav Chaturvedi
Anubhav Chaturvedi

Written by Anubhav Chaturvedi

Linux & DevOps Geek, Blockchain Developer ,Statistics & Data Nerd ,Solutions architect, passionate hands on instructor . High on Athletics and Travel

No responses yet