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.
SQL was originally developed at IBM in the early 1970s. Initially it was called SEQUEL (Structured English Query Language) which was later changed to SQL (pronounced as S-Q-L).
What You Can Do with SQL
There are lot more things you can do with SQL:
You can create a database.
You can create tables in a database.
You can query or request information from a database.
You can insert records in a database.
You can update or modify records in a database.
You can delete records from the database.
You can set permissions or access control within the database for data security.
You can create views to avoid typing frequently used complex queries.
The list does not end here, you can perform many other database-related tasks with SQL. You will learn about all of them in detail in upcoming chapters.
Once you're familiar with the basics, this course takes you to next level that explains the methods of retrieving records through joining multiple tables, searching records in the table based on pattern, etc.
Finally, you'll explore some advanced concepts, such as modifying the existing table structure, performing aggregations and grouping data together, creating views to simplify and secure table access, creating indexes for tables, handling dates and times, cloning of an existing table, creating temporary tables, as well as, concept of SQL subqueries and SQL injection.