SQL


Topic | v1 | created by jjones |
Description

SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data, i.e. data incorporating relations among entities and variables. SQL offers two main advantages over older read–write APIs such as ISAM or VSAM. Firstly, it introduced the concept of accessing many records with one single command. Secondly, it eliminates the need to specify how to reach a record, e.g. with or without an index.


Relations

e.g. PostgreSQL

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (...

is Programming language

A programming language is a formal language comprising a set of instructions that produce various kin...

relates to GraphQL

GraphQL is an open-source data query and manipulation language for APIs, and a runtime for fulfilling...


Edit details Edit relations Attach new author Attach new topic Attach new resource
Resources

treated in Advanced Features with Relational Database Tables Using SQLiteStudio

In this course, you’ll increase your knowledge of and experience with relational tables as you explor...

treated in Analyzing Big Data with SQL

In this course, you'll get an in-depth look at the SQL SELECT statement and its main clauses. The cou...

treated in Retrieve Data using Single-Table SQL Queries

In this course you’ll learn how to effectively retrieve data from a relational database table using t...

treated in Advanced Relational Database and SQL

In this 1-hour long project-based course, you will gain hands-on experience and learn about advanced...

treated in Databases and SQL for Data Science

Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful langu...

treated in Introduction to Structured Query Language (SQL)

In this course, you'll walk through installation steps for installing a text editor, installing MAMP...

treated in Intermediate Relational Database and SQL

In this 1-hour long project-based course, you will gain hands-on experience and learn how to create a...

treated in Manipulating Data with SQL

In this course you will learn to write the SQL code to manipulate the data in a relational database t...

treated in Distributed Computing with Spark SQL

This course is for students with SQL experience and now want to take the next step in gaining familia...

treated in Joe Celko's SQL for Smarties, Fifth Edition: Advanced SQL Programming

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to...