Derrick Reuben

Industrial Microbiology and Biotechnology Graduate | Retail Sales Associate | Inventory Controller |

[Derrick Reuben @ReubenDerrick]

@wamweaaa A quote in psychology of money states that an average low income Americans spend 420$ on gambling, but raising 400$ for a emergency fund is usually a big problem.

[Derrick Reuben @ReubenDerrick]

With all due respect, and I might be wrong as well. But Nyoro seems like a stock market manipulator.
#NSE #kplc

[Derrick Reuben @ReubenDerrick]

@EACinvestor So Knre is not an option to you guys

[Derrick Reuben @ReubenDerrick]

@akafaceUS Stare deep into the darkness and become one.

[Derrick Reuben @ReubenDerrick]

@curiosityonx Where's Elon going though?

[Derrick Reuben @ReubenDerrick]

@chepchumba_val Kuna tofauti ya the highest and strongest. Dollar is a stronger currency, KWD is the highest currency. Dinar is no longer useful outside its territory unlike the dollar you can trade with it in so many places.

[Splendor of SQL 🇬🇧🇩🇪💖 @iam_Uchenna]

SQL Interview Questions which can be asked in a Data Analyst Interview.

1️⃣ What is difference between Primary key and Unique key?

◼Primary key- A column or set of columns which uniquely identifies each record in a table. It can't contain null values and only one primary key
can exist in a table.

◼Unique key-Similar to primary key it also uniquely identifies each record in a table and can contain null values.Multiple Unique key can exist in a table.

2️⃣ What is a Candidate key?

◼A key or set of keys that uniquely identifies each record in a table. It is a combination of Primary and Alternate key.

3️⃣ What is a Constraint?

◼Specific rule or limit that we define in our table. E.g - NOT NULL,AUTO INCREMENT

4️⃣ Can you differentiate between TRUNCATE and DELETE?

◼TRUNCATE is a DDL command. It deletes the entire data from a table but preserves the structure of table. It doesn't deletes the data row by row hence faster than DELETE command, while DELETE is a DML command and it deletes the entire data based on specified condition else deletes the entire data,also it deletes the data row by row hence slower than TRUNCATE command.

5️⃣ What is difference between 'View' and 'Stored Procedure'?

◼A View is a virtual table that gets data from the base table .It is basically a Select statement,while Stored Procedure is a sql statement or set of sql statement stored on database server.

6️⃣ What is difference between a Common Table Expression and temporary table?

◼CTE is a temporary result set that is defined within execution scope of a single SELECT ,DELETE,UPDATE statement while temporary table is stored in TempDB and gets deleted once the session expires.

7️⃣ Differentiate between a clustered index and a non-clustered index?

◼ A clustered index determines physical ordering of data in a table and a table can have only one clustered index while a non-clustered index is analogous to index of a book where index is stored at one place and data at other place and index will have pointers to storage location of the data,a table can have more than one non-clustered index.

8️⃣ Explain triggers ?

◼They are sql codes which are automatically executed in response to certain events on a table.They are used to maintain integrity of data.

[truthache @truthache68]

A goof rule of thumb to consider—if any problem is being presented as a global crisis, then it is a scam. Pattern recognition.

[The Kenyan Vigilante @KenyanSays]

Safaricom is planning to launch a "New Mpesa"

[Derrick Reuben @ReubenDerrick]

@InternetH0F And hacking was possible?

[Jaynit @jaynitx]

Conor Neill literally exposed why smart people stay broke:

[Shay Boloor @StockSavvyShay]

Jeff Bezos basically said that if the AI economy keeps driving energy demand higher then $AMZN will eventually need data centers in space because Earth will not supply enough power.

The early pieces of that space economy are already taking shape with $RKLB building the logistics layer & $ASTS extending connectivity.

[Elon Musk @elonmusk]

Yes

[Elon Musk @elonmusk]

It is a hard path to 100GW/year of AI in space, but we know what to do

[Derrick Reuben @ReubenDerrick]

@aron_kiplangat @moneyacademyKE Mansa ni special fund

[Derrick Reuben @ReubenDerrick]

@moneyacademyKE Gulf cap je?

[Derrick Reuben @ReubenDerrick]

@KhalifKairo Just had a convoy with an indian juzi, alisema difference ni wao hawana one hundred thousand, they have lakh. Na apo ndio difference inaanza

[Derrick Reuben @ReubenDerrick]

@Coopbankenya Kindly reply to my DM

[Derrick Reuben @ReubenDerrick]

@Coopbankenya My payment hasn't reflected in Dhow csd and cbk has cancelled the transaction, the refund hasn't reflected in my account.

[Derrick Reuben @ReubenDerrick]

@SangKip4