SQL: Structured Query Language

SQL is a language that enables you to work with a database. Using SQL, you can insert records, update records, and delete records. You can also create new database objects such as databases and tables. And you can drop (delete) them.

More advanced features include creating stored procedures (self-contained scripts), views (pre-made queries), and setting permissions on database objects (such as tables, stored procedures, and views).

Although SQL is an ANSI (American National Standards Institute) standard, there are many different versions of SQL. Different database vendors have their own variations of the language.

SQL (1).png

What is SQL?

  • Structured Query Language.

  • Usually “talk” to a database server.

  • Used as front end to many databases (mysql, postgresql, oracle, sybase).

  • Three Subsystems: data description, data access and privileges.

sql-structured-query-language-database-symbol-vector-8212567.jpg
Jon Bossman