Hi, Omolara! Thanks so much for your videos; they are lovely to watch and learn from 🙌🙌🙌👌👌👌 Would you kindly do videos on the following for us: - What you do as a Data Migration Specialist - CTE Functions - Window Functions - Query Optimization Thank you once again!
Just watch your last video and subscribe. Just know this if you post a video and you have one view know am the one, if you have thousand of view know am one of the thousands and if you have no view then am probably dead. Keep it coming.
Hi omolara, thanks for your great work. i am confused about sql and would be happy if anyone on this comment section could help me. i am currently learning about sql as part of the skill required for data scientist and when we did excel and tableau, i understood perfectly well from interpreting the data upto visualization. but you see this sql, how i can visualise all my exploratory analysis, how can i give report, in short is there any way for sql deployment to be sure you are actually doing the right thing. seriously confused dear
Hello, please take it one step at a time, data analysis as a field or Data Science as field isn’t just about Data visualisation, SQL itself can be use to answer some data questions, SQL can be used to clean large amount of data which in turn helps in better decision making, SQL can also be used in transforming data, while learning Tableau, am sure you must have heard about ETL, SQL can be used in our ETL processes too and so on,you can rarely see any data role that would not require knowledge of SQL, so I can assure it’s worth learning. I hope this helps🙏
Hello Omolara , see this questions -- Q24: List all addresses in a specific city, e.g., 'New York'. trying to do this, no city bear new 'New York', like this (select city from addresses) are you trying to say we should pull all out all cities. And more also you said addresses in a specific city. (Address, used to have, number of house, name of house or street, city, state, country). can you elaborate more on the questions. or may be is me that didn't understand it.
I think the idea is to play around the question, you question is just testing your where clause and wildcard understanding, you can try where of about two cities present in the data. Regarding address, you can also pay around every col you think should form your address and concat them respectively. I hope this helps
@@OmolaraFash ok. i will check through again, kindly check the answer for this : -- Q23: Count the number of addresses in each country. select country, count(*) AS no_of_address from addresses group by COUNTRY order by COUNTRY asc;
the code u gave for the question "top-selling product within each category along with its total sales amount." in last in github is not running....what should be the changes?
@@aashu90 hello please, it’s working really well, can I know the error you are getting? And by the way the full explanation is here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KGIIvCQ0Bx8.htmlsi=H56nPgtXRKO73cdh