thanks bro. nikkas was clowning me on the coli when I said I was making 15 with a bachelors lol. I had to grind up
BI Dev/Data Analyst/Data Science and Careers (Official Discussion Thread)
- Thread starter Secure Da Bag
- Start date
I know the feeling. My first job out of college with a bachelor's degree, I was making 12hr
Good to know. I somewhat felt that was gonna be the case looking at the board the past few days. Finished the course last week after taking more time than expected. Supplementing studying on DataCamp. Just trying to prepare myself mentally for these opportunities. I find myself more attracted to R but have been brushing up more on SQL lately. I have no experience in the field so applying is daunting right now tbh.
I would focus on SQL
Answering my own question here:
It's not primarily used for SQL but I'll connect my SSMS to GitHub ().
It's not primarily used for SQL but I'll connect my SSMS to GitHub ().
Clickbait title but good info:
Finally started learning the basics of Stored Procedures and wondering what the hell I've been doing for the last +7 years of working with SQL 
I plan on automating as much as possible and using the extra time to study or fukk off and do my own thing without feeling guilty.
One concern I have is that I think I will need to schedule jobs inside SQL in order to fully automate everything and I don't think my department has those permissions, so I might tip my hand or my boss might get looped into the convo
I plan on automating as much as possible and using the extra time to study or fukk off and do my own thing without feeling guilty.
One concern I have is that I think I will need to schedule jobs inside SQL in order to fully automate everything and I don't think my department has those permissions, so I might tip my hand or my boss might get looped into the convo
Secure Da Bag
Veteran
Finally started learning the basics of Stored Procedures and wondering what the hell I've been doing for the last +7 years of working with SQL
The Advanced SQL Server Masterclass For Data Analysis
Take your SQL skills - and your career - to the next level
www.udemy.com
He has another in-depth VBA course I might take since I like how he teaches but it is on a different website that costs more so I'm in no rush
null
...
About a third through this course and strongly recommend it. Definitely bridging the gap with a lot of SQL techniques that I was not familiar with previously. The one downside is that it gives me too many options to find a solution. I started applying it to my job today and was overwhelmed with the 3-4 different directions I could take a complex query,The Advanced SQL Server Masterclass For Data Analysis
Take your SQL skills - and your career - to the next level
can you bullet point / TL;DR that?
null
...
Finally started learning the basics of Stored Procedures and wondering what the hell I've been doing for the last +7 years of working with SQL
I plan on automating as much as possible and using the extra time to study or fukk off and do my own thing without feeling guilty.
One concern I have is that I think I will need to schedule jobs inside SQL in order to fully automate everything and I don't think my department has those permissions, so I might tip my hand or my boss might get looped into the convo
if you use linux/unix and you have sql client command line connectivity to your target you could just use cron on your local machine.
cron - Wikipedia
Use something like sqsh (if possble) to pipeline scripts
The request was to compare a consistent cohort members' data over time (pre-pandemic versus post-pandemic)
| Unique MemberID | ID for the question answered | Most recent result pre-pandemic | Most recent result post-pandemic |
Typically I'd do an inner join on the same table twice and break things down via the unique criteria.
Based on what I learned, I could've went down the following rabbit holes:
- Use EXIST( ) in the WHERE clause to limit to members that have both pre/post pandemic records, and then build the query out as normal
- Create a base table for the first two columns and then use unique correlated queries for the final two columns
- Using scalar sub-queries I could move my criteria around policy year into the WHERE clause and otherwise build the query out as normal
- Using LEAD( ) and/or Row_Number( ) I could sort the data and sequentially grab records that match up with the pre/post requirements
- Using XML & STUFF( ) I could have just exported all results per member into a single, csv-delimited column and then exported to Excel and split it up for based on calendar year
Secure Da Bag
Veteran
About a third through this course and strongly recommend it. Definitely bridging the gap with a lot of SQL techniques that I was not familiar with previously. The one downside is that it gives me too many options to find a solution. I started applying it to my job today and was overwhelmed with the 3-4 different directions I could take a complex query, whereas previously, there was only one convoluted route to get the right answer. Right now I have like five additional tools that are more efficient under the right circumstances but I don't know 100% when that is. Over time I will get better fwiw.The Advanced SQL Server Masterclass For Data Analysis
Take your SQL skills - and your career - to the next level
He has another in-depth VBA course I might take since I like how he teaches but it is on a different website that costs more so I'm in no rush
Just remember temp tables should be the very 1st tool you reach for.
You should be able to use temp tables for the 1st 3 bullet points.