A simple SQL self preparation guide

Updated: Nov 18, 2019


SQL DataSteps

What is SQL?


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.


Resources to Prepare for SQL commands?


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.


What else- Other Important Concepts?


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.


See how ready you are to solve SQL interview questions:


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

37 views0 comments

Recent Posts

See All

Company

About us

Our Philosophy

Testimonials

Google Reviews

Success Stories

Our Instructors

Data Science Courses

THE DATA STEPS

  • LinkedIn
  • Facebook
  • Twitter
  • YouTube
  • Instagram

Contact

+1 6479012914

+1 6478061429