An SQL editor is like a digital notepad for talking to databases. Imagine you’re asking a super-smart librarian (the database) to find you specific books (data). The SQL editor is where you write down your questions (SQL queries) in a language the librarian understands.
there are a lot of sql editors. one of the populer is Microsoft SQL Server Management Studio. you download it on your pc. But for first lessons, we will use an online sql editor because it will be more easy for you. So you will not need to deal with the installing and settings.
There are many different SQL editors available, and one of the most popular is Microsoft SQL Server Management Studio. While you can download this editor and install it on your computer, we will be using an online SQL editor for our first lessons. This is because online editors are more convenient and accessible for beginners. You won’t need to worry about downloading, installing, or configuring software, which allows you to focus on learning the basics of SQL.
Download the file example here.
Go to the https://sqliteonline.com. And then upload the file(customerlist) here.
Now, let’s start with our first SQL script. This script will allow us to see what information is stored in this table. Okay, let’s begin!
Write this script on the window;
SELECT * FROM customerlist;
Now you can see what information is contained in the table. This is your first SQL script! In other lesson, we will explain this script in more detail.
Glossary
SQL
SQL editor
Database
Microsoft SQL Server Management Studio
Summary
Questions
- What does sql do?
- What is the difference between Querying and Modifying?