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.
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:
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.
Step 3: After installation, launch MySQL Workbench.
Step 4: To make a new connection to your database, click the above (+)symbol beside the MYSQL Connections.
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.
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.
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.
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.
