Time to Join.
How was your Madaraka day my devotee reader? Do you feel like we have achieved internal self-rule yet? My Holiday was amazing and tranquil. Speaking of amazing news! there’s a new EV truck in town. Haha, it’s been doing rounds on my Twitter page. The Rivian R1-T . This EV was released in September last year and now it’s here! for a small price of $70,000+ with Taxes and shipping you can flex this legit truck. It’s not a Ford Raptor but hey you gotta give credit where it’s due.
The past week I read an article by Bikozulu. It gave me a vivid description of a disconsolate ordeal. A chilling story it was. It made me appreciate life a little bit more and thus Today, I find myself full of positive energy.
From the online review, its off-road capabilities are impressive. It has 8 built-in driving modes — four are for the road, and four for when it ends — drivers can adjust ride height, suspension, pedal response, all-wheel drive, and more to optimize for comfort, efficiency, and performance. This makes it a formidable truck.
Picture a silent off-road drive upcountry.
I also dived further into SQL during the week, and got to learn more about Joins and how they are used. I bumped into two new elements i.e. the primary key and the foreign key. Now, a primary key is a column that uniquely identifies each row in a table. whereas A foreign key is a column or a set of columns in a table whose values correspond to the values of the primary key in another table. These keys make it possible to join multiple tables to achieve the desired outcome. There’s an interesting article on this Link. It gives a detailed description of how each of the keys and need to know differences between the two.
One might ask why you need to join tables, a textbook answer to this question is to combine two tables based on a specified common field between them. A simple answer is that joins help us interpret a particular set of relatable data in order to accomplish a particular set goal. There are several types of Joins and their use depends on your needs. They include Inner, Outer, Left, and Right Join. They are useful tools in the day-to-day manipulation of databases.
I also got a learn about Alias. They are used to give a table, or a column in a table, a temporary name. Aliases are important in this way, it allows you, a Data analyst to be more efficient in the number of characters you need to write, while at the same time you can assure that your column headings are informative of the data in your table.
A short example of this is — let’s say you have a table name called CustomerName, you can easily give it a temporary name as Customer by writing the below line:
SELECT CustomerName AS Customer.
Not so hard.
Have a great week and month ahead.
It’s always a 2min Read.
