Today, multiple flavors of SQL databases exist with versatile use cases, like MySQL and Postgres databases. It ends up being a hard choice: which SQL database do you want to use, which SQL database does your organization use; which SQL database is in the most demand? Our post Picking The Right SQL Database For You […]
Normalization of database is an essential skill to know as a database designer and developer. I still remember being intimidated by what it would bring on– back when I took a SQL database course. It was scary hearing about it. Let me assure you: it is easier than you might imagine. What is important though, […]
In this article, we’ll explore the steps of ER modelling for database design. By the end, you will know what database design is and how to create an entity-relationship diagram (ER). In addition, you will also learn how to translate an ER from a case study.
China as a country, and the Chinese people themselves are no strangers to exotic foods. Owing to the fact that they are one of the first civilizations ever to exist in the world, back then, there were really not a lot of options for the food which we are familiar with today. Therefore, food was […]
It’s hard to say goodbye. That’s not just a cliché. Saying goodbye is fairly tough—to a person; to your dream; to your cute little business! It’s tough to accept the fact when your business fails. You had a dream… you had an idea… you wanted it to work, and you took the bold step to […]
China exports all kinds of products. After all, China is a mass manufacturing might. Many economies, big or small, are very much dependent on the products that are imported from China. If you are also considering importing goods from China, or have been importing for a while, would you consider hiring or partnering with a […]
We will be using MySQL for the purposes of this post and connecting it with Python to write CRUD queries– you can use whatever flavor of SQL you are comfortable in (if you’re unsure which to pick, check out our post on How to Pick a SQL Flavor. By the end of this post, you will have found the answer to the question: “How To Write MySQL CRUD Queries In Python”.
A Comparison of SQL Database Flavors: How To Pick The Right SQL Database Flavor For You? SQL, or Structured Query Language, is a database that has widespread uses with many flavors– which we will explore. As such, in our data-driven world, SQL is fast becoming an essential skill. Therefore, in this article, we will look […]