A simple SQL self preparation guide

SQL stands for Structured Query Language. SQL is a standard programming language specifically designed for storing, retrieving, managing or manipulating the data inside a relational database management system (RDBMS). SQL became an ISO standard in 1987.

SQL is the most widely-implemented database language and supported by the popular relational database systems, like MySQL, SQL Server, and Oracle. However, some features of the SQL standard are implemented differently in different database systems.

Link: https://www.w3schools.com/sql/default.asp

“W3 Schools” is probably the best way to get started with the basics of SQL. This shows all the important commands with simple examples.

It is not just important to read about the important SQL commands but also to know other concepts like:

Database Concepts:

· Database Management System: https://www.tutorialspoint.com/dbms/index.htm

· Data Models: https://www.tutorialspoint.com/dbms/dbms_data_models.htm

Other SQL Concepts:

Some other concepts are important too to make sure that you understand in and out of the process followed in SQL codes.

https://towardsdatascience.com/the-complete-guide-of-sql-for-data-scientists-902aaced94e4

· Schema

· Table

· Columns

· Indexes

· Etc.

Here is a nice interview preparation toolkit for SQL interviews. Make sure to practice these questions again and again.