SQL Basics

Learn the basics of SQL queries quickly

In the digital age, data is the backbone of any business or service. SQL (Structured Query Language) is the key that unlocks the power of data stored in relational databases. Whether you’re a complete beginner, a developer, or simply curious, this guide will walk you through the basic concepts of SQL and how you can start querying databases.

Select Data

The SELECT statement retrieves data from a table. The asterisk (*) selects all columns.

SELECT * FROM employees;

This command retrieves the name and salary of employees.

SELECT name, salary FROM employees;

Filtering Data

To filter results, you can use the WHERE clause:

SELECT name, salary FROM employees WHERE salary > 60000;

Sorting and Grouping of Data

ORDER BY: Used to sort the result set.

SELECT * FROM employees ORDER BY salary DESC;

GROUP BY: Groups rows sharing a property.

SELECT position, COUNT(*) FROM employees GROUP BY position;

Debdatta Sarkar

Debdatta has more than 13 years in IT induustry and software engineering. Currently 6 years in data science, and machine learning. She holds a Master of Computer Applications degree and Executive Post Graduate Program Degree in Data Science. She is passionate about research, data-driven decisions, and technology’s role in business growth.

Others

SQL Basics

Learn the basics of SQL queries quickly