Date

Market insights

Stack

Apply

Upload your CV — we will connect you with the employer directly through our pool.

Description

#Day30 #TraditionalRoles Date - [phone] Company name: IBM Role: Data Analyst Topic: Rank vs Dense rank, Join, OLTP, Joining vs Blending, Worksheet Excel 1. What is a Self-Join? A self-join is a type of join that can be used to connect two tables. As a result, it is a unary relationship. Each row of the table is attached to itself and all other rows of the same table in a self-join. As a result, a self-join is mostly used to combine and compare rows from the same database table. 2. What is OLTP? OLTP, or online transactional processing, allows huge groups of people to execute massive amounts of database transactions in real time, usually via the internet. A database transaction occurs when data in a database is changed, inserted, deleted, or queried. 3. What is the difference between joining and blending in Tableau? Joining term is used when you are combining data from the same source, for example, worksheet in an Excel file or tables in Oracle databaseWhile blending requires two completely defined data sources in your report. 4. How to prevent someone from copying the cell from your worksheet in excel? If you want to protect your worksheet from being copied, go into Menu bar > Review > Protect sheet > Password. By entering password you can prevent your worksheet from getting copied. 5. What is the difference between the RANK() and DENSE_RANK() functions? The RANK() function in the result set defines the rank of each row within your ordered partition. If both rows have the same rank, the next number in the ranking will be the previous rank plus a number of duplicates. If we have three records at rank 4, for example, the next level indicated is 7. The DENSE_RANK() function assigns a distinct rank to each row within a partition based on the provided column value, with no gaps. If we have three records at rank 4, for example, the next level indicated is 5. . . . React ❤ for more parts in #TraditionalRoles Series ! To access all parts in : 1. Traditional Roles Interview Series : click on #TraditionalRoles hashtag 2. AI Engineering Interview Series : click on #ExperienceFromTheField hashtag 3. AI System Design Series : click on #AISysDesign hashtag Follow our linkedin page : [linkedin] for daily job updates !

Employer contacts (email/phone/telegram) are hidden from the public preview — send your CV, and we will connect you directly.