In this blog we will learn SQL.

SQL is just a query language; it is not a database. To perform SQL queries, you need to install any database, for example, Oracle, MySQL, MongoDB, PostgreSQL, SQL Server, DB2, etc.

What is SQL

  • SQL stands for Structured Query Language.
  • It is designed for managing data in a relational database management system (RDBMS).
  • It is pronounced as S-Q-L or sometime See-Qwell.
  • SQL is a database language, it is used for database creation, deletion, fetching rows, and modifying rows, etc.
  • SQL is based on relational algebra and tuple relational calculus.
  • SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

All DBMS like MySQL, Oracle, MS Access, Sybase, Informix, PostgreSQL, and SQL Server use SQL as standard database language.

Why SQL is required

SQL is required:

  • To create new databases, tables and views
  • To insert records in a database
  • To update records in a database
  • To delete records from a database
  • To retrieve data from a database

What SQL does

  • With SQL, we can query our database in several ways, using English-like statements.
  • With SQL, a user can access data from a relational database management system.
  • It allows the user to describe the data.
  • It allows the user to define the data in the database and manipulate it when needed.
  • It allows the user to create and drop database and table.
  • It allows the user to create a view, stored procedure, function in a database.
  • It allows the user to set permission on tables, procedures, and views.
Learn SQL Tutorial – javatpoint
Learn SQL tutorial for beginners and professionals with sql, tutorial, examples, insert, update, delete, select, join, database, table, join

#SQL #MYSQL #SQLSERVER #Probyto #ProbytoAI

Subscribe and follow us for latest news in Data Science, Machine learning, technology and stay updated!

Facebook: https://facebook.com/probyto
Twitter: https://twitter.com/probyto
LinkedIn: https://linkedin.com/company/probyto
Instagram: https://instagram.com/probyto