Sometimes You screw up your database design and you have redundancies i.e. your database is not normalized. If You want to correct that: Subqueries for the rescue! In our example we have two tables which contain almost the same information: CREATE TABLE installed_device (`id` int, `device` text, `info` text); INSERT INTO installed_device (`id`, `device`, `info`)…
You can comment your queries with — This is a comment in SQL SELECT * FROM my_table — WHERE id = 1
I got confused by all the buzzwords: data science, machine learning, deep learning, neural nets, artificial intelligence, big data, and so on and so on. As an engineer I like to put some structure to the chaos. Inspired by Roadmap: How to Learn Machine Learning in 6 Months and Tetiana Ivanova – How to become…
Imagine that you come home from a party and you are stopped by the police. They ask you to take a drug test and you accept. The test result is positive. You are guilty. But wait a minute! Is it really that simple?