Data Science- 6 basic commands

I recently started to learn Data Science on Codecademy.com.

I am already fascinated by data so this only came natural.

Here is what I learned so far:

• SQL is a programming language designed to manipulate and manage data stored in relational databases.

• A relational database is a database that organizes information into one or more tables.

• A table is a collection of data organized into rows and columns.

• A statement is a string of characters that the database recognizes as a valid command.

• CREATE TABLE creates a new table.

• INSERT INTO adds a new row to a table.

• SELECT queries data from a table.

• ALTER TABLE changes an existing table.

• UPDATE edits a row in a table.

• DELETE FROM deletes rows from a table.

• Always ad at the end of a command

• Always add ‘ ‘ for text variables