It's weird that there is this trend, but at the same time people say that the market is tight and it's really hard to find jobs in data right now. I know I should just focus on my journey, learn what I have to learn then I will see for myself, but it's just inconsistent
Hi Mike Got my second microsoft certification today after pl-300, which is azure data fundamentals And now preparing for Azure SQL Admin cert. It's annoying that microsoft cancelled all their SQL dev certs Right now it's hard to get a DA role. This video gives me hope. Will persist till I get the role Thanks a ton
DDL and DML are the most important. DDL is what allows you to create objects in the first place (e.g. tables, views, etc). You cannot even begin to work the data stored within tables if you don’t know any DML. If you’re going the admin route, then DCL is crucial as well.
Hi, I'm new to your channel & new to lworking in the technlogy field. Is working as a data analyst recommended for new people? Or is it more for those with more experience in technology? Thank you.
Hi, Has your opinion changed that developers will not be replaced by AI? And what do you think about Zuckerberg's recent phrase? About replacing mid-level developers.
Nope. I've yet to see a single dev be replaced. You let me know when it happens and then we can talk about it again. I don't live in a world governed by theory, mine is the real-world. I saw what Zuck said yet not a single one of his devs has been replaced by a machine learning model.
Mike, what’s your view on dashboarding tools like Tableau and Power BI being rendered obsolete by AI? Won’t LLMs be able to generate visualizations and KPIs without a human needing a GUI tool to create them?
Not going to happen. If it does, you still need people to write the underlying SQL code for the model to understand. Data professionals aren't going away. No, I've yet to see any LLM generate SQL code in a real-world database.
Mike, would you happen to know how often the edition for the OCA Oracle Database SQL certification changes? And if its almost retired, should you wait to prepare for the newer material in the newest edition?
Hi! Would you say there's a role which would be some crossover of a data analyst and a sysadmin? I'm studying both fields, very interested in both, I just can't decide which one to choose to fully dive in. Even if there's not such role, would you say that solid knowledge of OS, networking, Bash and Powershell could be helpful in data field and vice versa?
Nope. All the cloud vendors have their own Jupyter Notebooks named something differently. Python is now so heavily embedded in the real-world it would be hard to remove. More SQL is always the case. :)
It's weird that there is this trend, but at the same time people say that the market is tight and it's really hard to find jobs in data right now. I know I should just focus on my journey, learn what I have to learn then I will see for myself, but it's just inconsistent
Hi Mike
Got my second microsoft certification today after pl-300, which is azure data fundamentals
And now preparing for Azure SQL Admin cert. It's annoying that microsoft cancelled all their SQL dev certs
Right now it's hard to get a DA role. This video gives me hope. Will persist till I get the role
Thanks a ton
Congrats! That's awesome, keep going.
Mike when you say that we need SQL experinece, it does not matter if we write DDL or DML statements right, we just need SQL experience in general
Primarily DML unless you are designing tables or administering. Mike says his job is mostly data sourcing; so that is DML.
DDL and DML are the most important. DDL is what allows you to create objects in the first place (e.g. tables, views, etc). You cannot even begin to work the data stored within tables if you don’t know any DML. If you’re going the admin route, then DCL is crucial as well.
Hi, I'm new to your channel & new to lworking in the technlogy field. Is working as a data analyst recommended for new people? Or is it more for those with more experience in technology?
Thank you.
Hi, Has your opinion changed that developers will not be replaced by AI?
And what do you think about Zuckerberg's recent phrase? About replacing mid-level developers.
Nope. I've yet to see a single dev be replaced. You let me know when it happens and then we can talk about it again. I don't live in a world governed by theory, mine is the real-world. I saw what Zuck said yet not a single one of his devs has been replaced by a machine learning model.
Mike, what’s your view on dashboarding tools like Tableau and Power BI being rendered obsolete by AI? Won’t LLMs be able to generate visualizations and KPIs without a human needing a GUI tool to create them?
Not going to happen. If it does, you still need people to write the underlying SQL code for the model to understand. Data professionals aren't going away. No, I've yet to see any LLM generate SQL code in a real-world database.
Mike, would you happen to know how often the edition for the OCA Oracle Database SQL certification changes? And if its almost retired, should you wait to prepare for the newer material in the newest edition?
I agree that there is a lot of untapped data right now, is it worth learning SQL even for roles like Project Managers?
Hi! Would you say there's a role which would be some crossover of a data analyst and a sysadmin? I'm studying both fields, very interested in both, I just can't decide which one to choose to fully dive in. Even if there's not such role, would you say that solid knowledge of OS, networking, Bash and Powershell could be helpful in data field and vice versa?
do you think that in the future DE/MLE is going to require more SQL and less Python?
Nope. All the cloud vendors have their own Jupyter Notebooks named something differently. Python is now so heavily embedded in the real-world it would be hard to remove. More SQL is always the case. :)