Black friday

Save big!

All courses under $5 - for a limited time!

Code has been added to clipboard!

SQL Basics: Writing a Simple Query

Reading time 1 min
Published Jan 1, 2016
Updated Oct 3, 2019

SQL Basics: Main Tips

  • SQL is used for reading, writing and modifying data in a database.
  • It's a standard tool for a variety of databases: MySQL, MS Access, SQL Server, Sybase, Oracle, Postgres, etc.
  • To practice on your SQL basics, you will need to create your test database or use an online editor for queries.
Theory is great, but we recommend digging deeper!

SQL Simple Query Syntax

Example
SELECT * FROM Customers;

Note: if you feel that this is easy, you can skip to a more advanced SQL tutorial like SQL Data Types.

SQL Basics: Summary

  • Use SQL for reading, writing and modifying data in a database.
  • SQL works on various types of databases: MySQL, MS Access, SQL Server, Sybase, Oracle, Postgres, and others.
  • To practice writing SQL queries, you need to create a database or use an online editor.