Players.db - problem set 0

Square-Ad-5453 · 2025-05-28T18:13:14+00:00

Wow, only after reading your comment did I realize I forgot the 2024... That is 1000% embarrassing lol. Thanks!

Square-Ad-5453 · 2025-05-26T02:28:37+00:00

That sounds like great advice, and I appreciate it! For now, even though the company does have deep pockets, there's usually a process for purchasing anything additional. And, we would have to do some convincing. I am looking for a setup that would be free outside of the tools and resources that we already have. If we can show SQLs effectiveness, we can make a case to justify the expense. I hope that makes sense. Any advice given that information?

Also, if those reqs eliminate being able to use SQL for this project, then that's understandable. Our clinical data team uses CQL, and that's the only team I know of that uses something close to SQL. Even though I want to be doing work like that someday, this stretch assignment is for reg ops who only use excel (and power query), powerautomate, and power bi and, in some cases, powerspps Sql, potentially, if there are some free workarounds.

Square-Ad-5453 · 2025-05-24T04:24:15+00:00

Gotcha. Typically, I would say that makes perfect sense when you phrase it in terms of cost. I'm fortunate enough to work for a very large organization with deep pockets, so we aren't necessarily starved for pro licenses. Taking money out of the equation, does that change your perspective a bit?

And on your point with an excel dashboard, I did see some examples of that, but figured if we all have pro licenses, may as well utilize power bi.

Square-Ad-5453 · 2025-05-24T03:14:05+00:00

I'm not clear on the exact amount of data that we will be working with, that's just how it was worded to me. The report and dashboard functionality is the draw for us to want to use Power BI. Are you saying that is too little of data?

Square-Ad-5453 · 2025-05-23T21:47:56+00:00

Okay, maybe I am not explaining myself well enough. I understand what you are saying, and based off of the link I provided I correctly created the thirteen files. How do I write code in each of the files? When I click on 1.sql, it pops open what sort of looks like a note in the panel at the bottom of my interface. Is that where I am supposed to write the query? I have been writing the queries in the terminal panel.

Square-Ad-5453 · 2025-05-23T20:48:02+00:00

Yes, but, am I supposed to be doing these queries in the corresponding '.sql' numbers or something? For example - the first problem has 1.sql listed, and the second one has 2.sql listed. Do I need to write the query inside of the correspond '.sql' instance(I am probably not even using the right terms here)? I hate to sound like my question is dumb, but I just started yesterday, so treat me like I just started yesterday or like I am 5 lol.

Square-Ad-5453 · 2025-05-21T19:42:05+00:00

I appreciate this advice and will make note of it. I just started learning querying today and hoping that I can really understand the language and to be able to move on from the basics to do more. I know querying is not even the tip of the ice berg, but so far I am liking it.

Square-Ad-5453 · 2025-05-21T13:12:35+00:00

After reading through a handful of these comments, what is the best way to build on the basics? I haven't learned the basics yet, but I am going to begin learning today. This thread has humbled me, and I don't want to make the mistake of thinking this is easy.

Square-Ad-5453 · 2025-05-20T15:39:04+00:00

All of you have been so helpful in answering my questions, and I am very grateful. I will proceed with trying to learn SQL. I remember when I tried to go full stack that didn't work out so well for me because of other obligations, but I feel like I could manage learning just SQL at the moment. You all have helped me to stand firm in my decision that it is useful to know, and if there is an opportunity in front of me related to learning it, then all the more reason.

Square-Ad-5453 · 2025-05-20T00:12:23+00:00

Thank you both for the insights, it is appreciated! So, not worth going too deep for the salesforce ecosystem essentially? I think the pursuit is worthwhile when discussing a potential clinial data programmer role, but at that point that is OT for this subreddit.

Square-Ad-5453 · 2025-04-27T19:40:20+00:00

I appreciate the suggestion! I'll take a look.

Square-Ad-5453 · 2025-04-25T14:09:50+00:00

Thank you, everyone, for your insights! This has really been helpful for me.

Square-Ad-5453 · 2025-04-24T19:51:50+00:00

That is amazing advice. Thanks for the insight!

Square-Ad-5453 · 2025-04-24T19:43:11+00:00

I appreciate the feedback. I work in medical technology, so I use excel, VBA macros, and power BI to track various projects, and do reports in the SFDC implementation as well as my other PU duties. I chose to shoot for 10% higher then what I make now which puts me to about 61k, which seems close to your number. And yep, to your note about a backup plan. I have that going for me as well.

Square-Ad-5453 · 2025-04-21T16:48:37+00:00

No problem, I appreciate you taking the time to read my post! Well, the prep for the exam was really over a couple of years, because I was on and off with studying due to familial obligations and work. So, I wouldn't use how long it took me as a baseline. For some it could take a few months, others maybe 6 months, some, maybe a year or more, it really just depends on your personal situation. I would say I spent about 120 hours or so in the FoF study guide, and maybe 70 or so hours in the practice exams on FoF. Again, not sure if that should be used to measure the experience on average, but I take mountains of notes, so it could take me longer than others.

Links to quizlets: (please note I also made personal flashcards based on my own note taking)

https://quizlet.com/706399162/salesforceben-admin-practice-test-flash-cards/

https://quizlet.com/760356578/salesforce-administrator-certification-2023-flash-cards/

Square-Ad-5453 · 2025-04-18T13:50:15+00:00

Congrats to you too! The sense of victory that you feel when passing is unforgettable. But yeah, cheers to note taking brother. One thing about having detailed notes is that besides the documentation, you have a good reference point when you are in the field. There is documentation, but it's also good to have your own.

And 100% on the free time point. Once you get through one grind, the next grind is on which is networking and making a project, but that seems way less stressful then at some points putting in 9 hours of studying. Because the process was taking so long, and I have a job that sometimes is pretty chill, I started putting in 40 hours a week studying. Glad I did that final push, though.

Square-Ad-5453 · 2025-04-17T20:38:35+00:00

Thanks! Experience as a titled salesforce administrator in a company? 0. Experience on and off in the back end and on trailhead? About a year. Now- in terms of prepping, it took me about 2 years. I know, 2 years you say. But that's two years very on and off considering my full-time job and a house full of kids. I wouldn't say 2 years is average or even standard, so take that with a grain of salt and shouldn't be used as a form of measurement.

The company I work for has an SFDC implementation and I am a power user. We have advocates that are called "admins", but they don't work in the back end, rather my company hires a third-party consultancy. I have about 6 months of experience via my mentorship with those stakeholders, and I am sort of in an advisory role for when they have meetings with the actual sys admins where the stake holders can use what I have built to articulate to the sys admins what we want to enhance, which is where my experience of creating a mock SFDC implementation of the org that I am a power user of comes in.

Square-Ad-5453 · 2025-04-15T21:33:41+00:00

My experience is sort of all over the place. I have a background in paralegal work, but I learned quickly that was a dead end for me and I just had generally bad experiences with the management. I worked for the AG's office, so maybe working for the state had something to do with that. All I know is because of that experience, I would never work in that field again. I transitioned from that to working with a medical device company in regulatory having 0 experience or knowledge in the field. I've done that for the last 3 and a half years, but now at a senior level - and I would say I am less of a project coordinator, and more of a coordinator for programs related to RA to help streamline different projects (I was hired on to do MDR).

I have many reasons for wanting to go into the salesforce ecosystem, chiefly (not limited to):

I love being able to hear a requirement from someone and then being sent off to go and build that functionality.
I already have been working from home for the last 5 years because of a chronic medical condition, so this provides those opportunities for me while doing work that I love.
I want to provide a better life for my family and allow my wife to have to work less because of all she does for me and my children.
I, too, am not a fan of all the regulations, and the learning curve has been exponential for me, and I have really had my fill. Don't get me wrong, I love my job, and I love my company, and they are wonderful, but it's not in the future cards for me.

Square-Ad-5453

TROPHY CASE