The Essence of Machine Learning
The Essence of Machine Learning A pattern exists The pattern cannot be described mathematically We have data on this problem
SQL-Basics: Create – Read – Update – Delete
This episode is about the basic statements needed to create, read, update and delete data in a database system. It is part of my SQL-Tutorial Motivation Let’s assume we work as a data scientist for Knight Industries. We want to help the Foundation of Law and Government to keep track of our operatives. We decide…
SQL – the dark side
Sometimes your RDBMS does not allow you to do certain changes like updating a table without using a WHERE clause that uses a key column. When you are really sure what you want to do: SET SQL_SAFE_UPDATES = 0; Now the dirty brown magic can begin! Back to the SQL-Tutorial
SQL-Basics – Subqueries: Update column with values from another column
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`)…
SQL comments
You can comment your queries with — This is a comment in SQL SELECT * FROM my_table — WHERE id = 1
My personal road map for learning data science in 2018
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…
Personal Retrospective 2017
As this year is coming slowly to an end, I like to use this Sunday to experiment with a little personal Retrospective. We already did two good retros at work so I decided to one for myself.
ASQF Agile Brunch
Last event for this year: ASQF’s #agilebrunch in Nuemberg. Jürgen Mohr invited me to this event because I was curious about Management 3.0 Workshops and Jürgen told me that he was going to hold a short session about M3.0 at this particular event.
Bayes’ Theorem
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?
Software Engineering Camp 2017
After the Atlassian Roadshow, the next event I attended was just around the corner. Location The Software Engineering Camp 2017 aka #SWEC17 was hosted again in the rooms of method park in Erlangen-Tennenlohe which is the town where I work at e.solutions GmbH, so no big deal traveling. SWEC16 being my first bar camp ever,…