This episode is about the basic statements needed to create, read, update and delete data in a database system.
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 to use a classic relational database management system or RDBMS. In order to explore Database Management Systems we can either install one locally or we can use an online tool like SQLFiddle.
To interact with RDBMS we use SQL – the Structured Query Language.
As the name says SQL (speak either S-Q-L or Sequel) is used to write structured queries. Think of “conversations” when You think of “queries”.
So, let’s fire up SQLFiddle. Continue reading “SQL-Basics: Create – Read – Update – Delete”
Sometimes your RDBMS does not allow You certain changes like updating a table without using a WHERE that uses a key column.
When You are really sure what You want to do:
SET SQL_SAFE_UPDATES = 0;
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! Continue reading “SQL-Basics – Subqueries: Update column with values from another column”
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 a Data Scientist in 6 months a hacker’s approach to career planning I build my own learning road map for this year: Continue reading “My personal road map for learning data science in 2018”
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.
Set the stage
As a method for setting the stage I use Check In-Questions
What do I expect to get out of this Retrospective?
Analyzing good and bad habits
Because I’m not really mad or sad about things happening this year I formulate the questions to: What do I want to
- Do More
- Do Less
- Keep Doing
Here are my items
- Spend time with kids
- Eat healthier
- Buying books
- Social Media (FB, 9Gag)
- Going to barcamps
- Drink enough water
- Budgeting with YNAB
As a method to generate insights I choose the 5 Whys.
Let’s start with the do Less list:
I buy so many books that I barely read them cover to cover.
- Why do I buy so many books? – Because I enjoy reading
- Why? – Because I like to know more about things
- Why? – Because I want to have an knowledge advantage at work
- Why? – Perhaps I fear a job loss
- Why? – Times are tough in the automotive industry
Decide what to do
Regarding books I will restrict myself to buying one book per month.
Close the Retrospective
I drink a beer 🍺
Last event for this year: ASQF’s 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.
Continue reading “ASQF Agile Brunch”
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? Continue reading “Bayes’ Theorem – Part 1”
What can You expect from a day when you are awake at 4am after just 5 hours of sleep still dealing with headache and a cold? Actually a lot 🙂
Thanks to my wife I attended -against all odds- the Atlassian Roadshow “Agile Evolution in Companies” in Nuremberg, on November 14th 2017. Continue reading “Atlassian Roadshow “Agile Evolution in Companies””