Skip to content

setup-environment.md

Latest commit

 

History

History
64 lines (44 loc) · 2.8 KB

setup-environment.md

File metadata and controls

64 lines (44 loc) · 2.8 KB
id setup-environment
title Setting up your development environment
sidebar_label Setting up environment
sidebar_position 3
tags
sql
introduction of sql
what is sql
why learn sql
setup sql
sql workbench
sql server
sql setup
description In this tutorial, you will learn how to set up your development environment for HTML development.

There are different emulators available for SQL Queries, but as a beginner its always good to start with Installing MYSQL Server and Workbench in your system, it helps you to understand the overall process and industry settings. This MYSQL Workbench is called the IDE (Itegrated developement enviornment). We will guide you to setup the IDE in your system, and navigate further executing SQL queries and creating database in the IDE.

1. Download the Installer:: To install download the installer.

Click the link below to download MySQL Workbench:

👉 MySQL Workbench Official Download Page

  • ✅ Choose your OS (Windows, macOS, or Linux)
  • ✅ Follow the installation instructions
<iframe width="853" height="480" src="https://www.youtube.com/embed/u96rVINbAUI" title="How To Install MySQL (Server and Workbench)" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>

🍎 macOS Users

🐧 Linux Users

Why Do You Need an IDE?

This IDE helps you to execute and maintain the workflow of SQL, It acts as a source code editor, and a debugger. It basically help you to execute and debug any bugs for developer. Especially when comes to DBA (Database adminstration), managing huge dataset can be tiring here, it will help you with performance dashboard and quick improvement features.

Key Features to Look for in an IDE/Text Editor

  1. Syntax : Highlights the color, make code readbility.
  2. Accelerate Work stucture: Help you to sort and visualise the messy database.
  3. Helps managing Database: Allows you to store the data, create workflow and organise it.

Conclusion

I hope you understood the concept here, if not yet, think like its a nice view from your house, it lets you see whats happening outside in your comfort zone, if anything happening to the house, the view remain same, Workbench works the simillar way, it helps you to see the data in the databse, just like your house SQL workbench doesnt have the data, if you remove workbench nothing happens to your databse.