⛔ How would you rate your SQL skill over 10? ✅ " I am quite comfortable working with any form of RDBMS, That said, from a Database developer point of view, I would say 6, while from a Data Analyst point of view, I would say 7.5.

🔎Questions about the types of databases you have worked with. ⚠️ You want to mention your experience with both relational and non-relational DBs, types you have worked with but more importantly explain that SQL is quite universal and ...

you can certainly find your way around even the ones you have never used. ⛔ How familiar are you with Oracle RDBMS? ✅ " I have spent the last year working majorly with SQL Server, mySql and PostgreSQL which are all very similar in term of syntax to Oracles.

Although I have never worked with Oracle before, I have no doubt I will quickly find my way around it, with a little help from google of course 🤭". (Be certain to gauge the interviewer before making a statement like this) 🔎Questions about some common concepts/terms in RDBMs

⚠️ Here you want to be familiar with common terms like Servers, schemas, Tables, Views, Stored Procedures, Index, CTEs, Subqueries etc. ⛔ What is the difference between a table and a View?

✅ "A view is a saved query that can return data from one or more tables based one the conditions provided in the query, while a Table is an entity of collection of related data held together in a rows and column based format".

🔎 Questions about SQL Syntaxs ⚠️ This is the most difficult part, where you might be asked to write a query or walk them through how you would right one. I recommend a proper training here as this thread does not provide the answer.

I also advise you focus your learning on all the popular syntax you can see on sites like w3schools, but it's also nice to know a few windows functions like Partition, Rank, Row_number ... guys, dont panic, as I mentioned earlier,

you dont even have to know how to use some of these things, but you want to understand them and what they are used for. ⛔ What is the difference between Having and Where? ✅ I would say they are both filter syntax, but “Where” clause is used to filter the records from a table

that is based on a specified condition, while the “Having” clause is used to filter the record from the groups based on the specified condition. 🔎Questions about Joins

⚠️ Although we have quite a lot of joins depending on what RDBMS you're working with, every Data Analyst needs to fully understand Inner join, outer join, left join and right join. It is also important to understand the similarities and differences.

⛔ Can you explain the difference between a left join and a right join? ✅ "In my opinion, there is no actual difference between them asides the arrangement of the tables. The left join will favour the first table (table to the left) and

return that with only the commons rows in the right, while the right join would do just opposite of that." 📌Cloud/On Prem based questions. ⚠️Have basic understanding of what an on-premise server is and what a cloud server is.

Recognize that some tools have both cloud and OnPrem version e.g Cloud | OnPrem Azure SQL DB | SQL Server PBI paginated report | SSRS Azure AS | SSAA Data Factory | SSIS You dont know to know how to use all of this things, but you should have an understanding of what they do.

@Femi_OfMainland Omo With this thread i just realised i know nothing But i just started learning data analytics sha.... there's alot to do! Alot!!!

@Itz_pep Take a step everyday.

@Femi_OfMainland It was really fun using the questions to test my knowledge and level in data analytics …. Thank you so much

@kennytim01 You're welcome man.

@Femi_OfMainland Thanks for sharing this... It's really helpful atleast one has an idea of what to expect. But mhen! You lost me when you started talking about cloud 😄

@dosumu_adesola Oh, please read up on it, it might make the difference