| title | date | category | image | tags | authors | mainpage | draft | ||
|---|---|---|---|---|---|---|---|---|---|
SQL |
2021-08-04 05:16:58 +0530 |
language |
images/SQL.jpg |
|
|
false |
false |
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.
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.
- 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
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