SQL
Curated By
SQL is an abbreviation for Structured Query Language. It is a language used to perform actions such as update, retrieve, manipulate and store data on a relational database. Relational systems are made up of a set of tables containing rows and columns of data. It’s a universal coding language that will help you transition into learning other computer languages, including JavaScript and Python.
PREREQUISITES
Nil. There are no prerequisites to learn SQL and it is easier to learn. It’s a query language with English like language. So, anyone who can use English at a basic level can learn and write SQL queries easily.
TOPICS TO LEARN
- Data and Database
- Creating a Database
- Alter the Database
- Drop the Database
- Rename
- Truncate
- Create a Table
- Insert
- Update
- Delete
- Select
- Where
- Grant
- Revoke
- AND, OR, NOT
- Aggregate functions
- Group by, Having, Order by
- NULL
- In and Between Operators
- Aliases
REFERENCES
TUTORIALS
ONLINE COURSES
- Learn SQL Basics for Data Science Specialization
- SQL for beginner – Coursera guided project
- Database creation and Modeling using MYSQL Workbench
BLOGS
- SQL tutorial – learn SQL programming online-intellipaat
- SQL basics – dataquest
- SQL tutorial – W3 School
APPS