What is the best resource for learning programming?

Question

Programming

I am looking for a resource or aggregator of video courses for teaching programming.
The main criteria:
1. English speaking (I don’t know why, but I don’t digest Russian-speaking teachers at the root)
2. Brevity and capacity of the material
3. As much practice as possible (I really like how everything is arranged in freecodecamp and codeschool)
4. It would be nice to have something something like a learning map.
Thank you.

Answer 1

Если в таблице `recipe_product` пара (`recipe_id`, `product_id`) уникальная, то из данной таблицы можно удалить искусственный ключ `id` и сделать эту пару первичным ключом.
Поиск рецептов, в которые входят все указанные продукты:

SELECT `recipe_id`, COUNT(*) AS `count`
  FROM `recipe_product`
  WHERE (`product_id` = 1 AND `product_weight` > 100)
    OR (`product_id` = 2 AND `product_weight` BETWEEN 200 AND 400)
    OR (`product_id` = 3 AND `product_weight` < 10)
  GROUP BY `recipe_id`
  HAVING `count` = 3

Поиск рецептов, в которые входят все указанные продукты и ничего кроме них:

SELECT `recipe_id`, COUNT(*) AS `count`
  FROM `recipe_product`
  WHERE `recipe_id` NOT IN (SELECT `recipe_id` FROM `recipe_product` WHERE `product_id` NOT IN (1, 2, 3))
    AND ((`product_id` = 1 AND `product_weight` > 100)
      OR (`product_id` = 2 AND `product_weight` BETWEEN 200 AND 400)
      OR (`product_id` = 3 AND `product_weight` < 10))
  GROUP BY `recipe_id`
  HAVING `count` = 3

Answer 2

For English:
https://medium.com/@nechitai/750-hours-of-free-pre...
For practice:
hexlet.io Something like a curriculum here https://ru.hexlet.io/professions/backend

Answer 3

3. As much practice as possible (I really like how everything works in freecodecamp and codeschool)
Is this your practice? =) only a live mentor can check the code.