SQL (Structured Query Language) is a language we use to interact with a Database Management System (DBMS).
As the name suggests, it’s not a programming language, but it was born as a querying language, and later evolved to an interface to doing more advanced operations with a database than just performing queries.
I said “evolved”, but in reality SQL is always evolving. It’s a standard that was first published in 1986, then updated in 1989, 1992, 1999, 2003, 2006, 2008, 2011, 2016 and as its latest version at the time of writing, 2019.
SQL is implemented in many popular DBMS: PostgreSQL, MySQL, Oracle, SQLite, MicroSoft SQL Server, and many more. Each different database implements the standard, or a particular version of it, and adds custom features on top of it, to simplify creating queries or adding a specific functionality.
Unless noted otherwise, every time I talk about SQL I talk about the SQL standard, not a particular implementation of it.
SQL is a huge subject. I cover many of its topics in different blog posts, including:
SQL, creating a table SQL, adding data to a table SQL, how to use SELECT SQL, how to update a table structure SQL, how to update data SQL, how to delete data and tables SQL, Handling empty cells SQL, Unique and Primary keys SQL Views SQL Joins
One more thing! ⚠️ ✋
It's a 10-weeks long cohort online course where I will guide you to becoming a Web Developer.
It's not "just a course". It's a big event I organize once a year.
At the end of the first 10 weeks you'll know how to create web sites and web applications and I'll unlock you the 2nd phase of the Bootcamp: you will get access to a large number of projects exclusive to the Bootcamp graduates, so you can follow my instructions to build things like private areas with authentication, clones of popular sites like Twitter YouTube Reddit, create e-commerce sites, and much much more.
Because once you got the fundamentals, you only learn by working on real, exciting projects.
To find out more, visit bootcamp.dev