by dayo ade | Jan 14, 2021 | Microsoft Excel Articles
Today we are going to be talking about how to use Pivot Table in Excel. Our data set consists of 213 records and 6 fields. Order ID, Product, Category, Amount, Date and Country. Insert a Pivot Table To insert a pivot table, execute the following steps. 1. Click any...
by dayo ade | Mar 3, 2020 | Articles and Short Tutorials, Mysql Database Articles
A normalized database makes life simple either SQL or other types. Whether for work as a database administrator or for play, these wonders of technology organize our lives in more ways than we may realize. We can store just about anything in a database. We just have...
by dayo ade | Feb 27, 2020 | Articles and Short Tutorials, Mysql Database Articles
The data type of a column defines what value the column can hold: integer, character, money, date and time, binary, and so on. SQL data types can be broadly divided into following categories. Numeric data types such as int, tinyint, bigint, float, real etc.Date and...