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