Self Learning Task 5
Here, I'm going to talk about SQL basics that is being taught on KhanAcademy.com SQL stands for Structured Query Language and is used to manage data in a database. There are 2 types of basic databases, Relational and Non-Relational. SQL is used to manage and organize relational databases. Here, the instructor starts off the course by explaining the carious types of databases and why we use sql. SQL is a very simple and easy to understand language. It is very similar to the English language. Syntax used is also explicit and easy to remember. To create tables:- CREATE TABLE table_name (id INTEGER , name VARCHAR); When this is executed, a table is created having 2 columns, id and name. id can store only integer numbers and name string characters of variable length. You may also specify the maximum length that can be stored by specifying it in parenthesis. CREATE TABLE table_name (id INTEGER , name VARCHAR(20)); So her...