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