Data Analyst

What is a foreign key and how does it differ from a primary key?

What happens to the table itself when executing the TRUNCATE command?

What skills are necessary for this profession? Name three key ones.

Please tell us, using your work tasks as an example, how you apply the ETL process in your work.

Where would you start on this position, what challenges would you face, what goals would you set, who would you meet first?

What are the aspirations regarding the next position and how much time do you allocate for it?

Please tell me what types of logical joins you know.

What programming languages do you know?

Tell us about yourself (career experience)

Can you tell me more about JOIN operations and how they differ from each other?

What types of DBMS do you know?

create table table1 ( t1 int null ); insert into table1(t1) values (1),(3),(3),(4),(5),(5);

Please tell me, what is a primary key?

Please tell me, in Airflow, do you mostly provide technical specifications or do you also have experience creating DAGs?

Are you familiar with relational and non-relational databases? How do they differ?

Please tell me, what is a DBMS?

What specifically interested you about the company and this position? What strengths do you highlight in yourself and how will you be useful?

Tell me about the ETL process. What do you know about it?

What is the difference between the DROP and TRUNCATE commands?

What qualities do you need to develop?