Thanks for this it cleared up some questions I had on joins. And good practice in general. I'm sure these are your run of the mill SQL job interview questions one might get. On another note what do you think about getting power BI or tableau certified to better ones chances for an interview over another candidate.
I'd say as long as it doesn't cost a ton of money, it wouldn't hurt to have it on your resume. I dont think it would be a big difference maker though in getting an interview. I think what's more important is analytical experience, whether through personal projects, or through related schooling/work.
Good point about projects and experience. About experience I've been thinking of reaching out to non profits or mom n pop shops on doing pro bono DA work.
Hi Josh, Great explanation I have two questions for you 1. what is the use of a lower command in the statement - lower(t2.description) like '%covid%' ?? 2. In the below query you have mentioned distinct commands only to the t1.id column, not to the rest of the commands in the select clause. Do you know if the distinct command will apply to the rest of the columns?? select distinct t1.id, t1.first, t1.last, t2.date t2.descripition............ ...like '%covid%'
Yes you could use visual studio code to interact with SQL. This is just a different type of graphical user interface (GUI). I have been using pgadmin. Another you can use is dbeaver.
Hey Josh, thank you for posting. I was hoping if you could make a bootcamp or series of projects in the domain of Healthcare. Although I have ideas for projects it's hard deciding questions to solve based on a project. I hope you understand what I mean
Hello, Yes, the next video I will release will be a Tableau tutorial for a project you can put in a portfolio. I also have this one here as well for an Emergency room dashboard th-cam.com/video/RKRHozoSlVk/w-d-xo.html I am also working on a class called the clinical analytics accelerator, which I plan to release sometime this year. Here's the mailing list signup if you're interested! datawizardry.academy/p/clinical_analytics_accelerator
I dont think I could narrow it down to 3. The statements I use the most often are select, from, where, join, group by, and having. So my advice would be to focus on learning those. I rarely use insert and update because the tables I query off of are typically maintained by data engineers who work with the etl, and updating of sql tables.
You are a great instructor and I will be waiting for future videos on SQL. Thank you so much for making these tutorials!
You brought attention to a good topic. Thank you for this reminder on how you can get duplicate rows when joining tables.
Thanks, Josh, I am looking forward to your course. Can not wait as I believe it will be a very exciting course.
Thanks for this it cleared up some questions I had on joins. And good practice in general. I'm sure these are your run of the mill SQL job interview questions one might get. On another note what do you think about getting power BI or tableau certified to better ones chances for an interview over another candidate.
I'd say as long as it doesn't cost a ton of money, it wouldn't hurt to have it on your resume.
I dont think it would be a big difference maker though in getting an interview. I think what's more important is analytical experience, whether through personal projects, or through related schooling/work.
Good point about projects and experience. About experience I've been thinking of reaching out to non profits or mom n pop shops on doing pro bono DA work.
@@joeltorres1237 Great idea!
Hi Josh,
Great explanation
I have two questions for you
1. what is the use of a lower command in the statement - lower(t2.description) like '%covid%' ??
2. In the below query you have mentioned distinct commands only to the t1.id column, not to the rest of the commands in the select clause. Do you know if the distinct command will apply to the rest of the columns??
select distinct t1.id,
t1.first,
t1.last,
t2.date
t2.descripition............
...like '%covid%'
FYI I am still watching this video again for a reminder about the joins
is it necessary for data profs to learn Window Comand Prompt ?
It's certainly useful to know. I don't personally use the command prompt much though.
Can Visual Studio Code be used instead of SQL Workbench?
Yes you could use visual studio code to interact with SQL. This is just a different type of graphical user interface (GUI).
I have been using pgadmin. Another you can use is dbeaver.
Hey Josh, thank you for posting. I was hoping if you could make a bootcamp or series of projects in the domain of Healthcare. Although I have ideas for projects it's hard deciding questions to solve based on a project. I hope you understand what I mean
Hello,
Yes, the next video I will release will be a Tableau tutorial for a project you can put in a portfolio.
I also have this one here as well for an Emergency room dashboard th-cam.com/video/RKRHozoSlVk/w-d-xo.html
I am also working on a class called the clinical analytics accelerator, which I plan to release sometime this year. Here's the mailing list signup if you're interested!
datawizardry.academy/p/clinical_analytics_accelerator
what are the 3 most used sql statement in DA role?
are they the basic stuffs everyone got introduced when they first started learning sql? (select, insert and update)?
I dont think I could narrow it down to 3. The statements I use the most often are select, from, where, join, group by, and having.
So my advice would be to focus on learning those.
I rarely use insert and update because the tables I query off of are typically maintained by data engineers who work with the etl, and updating of sql tables.