SQL Starters

Kalyanam Venumadhav — Thu, 03 Sep 2026 18:51:24 +0000

Hi Folks,

In this article, I'm going to share my learnings in SQL.

Install MySQL Workbench editor from **MySQL Downloads **found in internet.
After Installation,
- Open MySQL Workbench
- Click on '+' icon to create new sql editor
- Click on import icon present on top in sql editor workbench
- After importing, See the data, schema tables present in left side panel
We see the sql editor workspace, result Grid,output view.

How to display data present in result table ?
Use SELECT '*' as Keyword FROM table_name
Ex: SELECT * FROM moviesdb.movies;

Instead of moviesdb.movies we can use movies as name. Follow the steps below:

Go to the left panel where movie data present, select movie data table -> Right click on default schema it highlights in bold -> Then, Write query as, SELECT * FROM movies

Method - 2
USE moviesdb
SELECT * FROM movies;
Here we're using 'USE' Keyword

How can we check how many rows are present after writing query ?

Just go to output view present in MySQL Workbench editor (present below to the result Grid) you can see there (or) Check with Excel sheet using filter option to check how many rows are present.

Suppose we're writing query but we don't know recieved output is right or wrong. We can check with our excel sheet data using filter option if it matches with our output rows then our query is correct this is how we can debug and check ✅ output.

There are some inbuilt clauses present in SQL
1.WHERE
2.COUNT
3.DISTINCT (for unique values)
4.LIKE
5.% - Wildcard Search Ex: %movies% Gives the movies data present anywhere in the sentence
%movies - Returns movies data present starting at the sentence
%movies - Returns of movies present at last in the sentence

Ctrl + Scroll UP - Zoom in SQL Editor

Database - Collection of rows and columns in tabular format with schema it has duplicate ids, unique ids in different formats like excel, .sql etc.

How to save all written queries ?

Write all queries at one place and highlight each query, do the next steps mentioned below,
Select each query
Run each query
After running all the queries click on save button present in SQL Editor in top as notebook symbol
Select folder, Give file name

3 sections present in SQL Workbench

SQL Editor
Result Grid
Output Panel

I hope this article cleared doubts in SQL on basics level

Thanks for reading !

Follow More for this kind of Informative articles...

Share with your friends who are interested to learn SQL / learning SQL. Help Others

Comment your Thoughts 💬 What kind of articles you're interested in and Did you find this article helpful or not ? Do share your thoughts with us...

Bye.🙋‍♂️ See you in the next fun practical learning article.

DEV Community: Kalyanam Venumadhav

SQL Starters