SQL

Links

• Postrgresql

• https://www.khanacademy.org/computing/hour-of-code/hour-of-sql/v/welcome-to-sql#!

• http://sqlfiddle.com/

• http://use-the-index-luke.com/de/sql/vorwort

  From: https://gist.github.com/hofmannsven/9164408

  Login: mysql -u [username] -p

  show databases; use [database];

WHERE

• http://www.w3schools.com/sql/sql_in.asp

JOIN

• https://stackoverflow.com/questions/12475850/how-can-an-sql-query-return-data-from-multiple-tables/12475851#12475851

  select
        cars.ID,
        models.model
    from
        cars
            join models
                on cars.model=models.ID