{ "media_type": "text", "post_content": "I’m about to get staffed on an assessment analytics role using Microsoft Access and SQL, neither which I have any familiarity with. Role starts in 2 weeks. Any suggestions on resources and quick maths", "post_id": "5b71debea33368001349f3ad", "reply_count": 12, "vote_count": 4, "bowl_id": "5ace5097be6e660013abcc42", "bowl_name": "Data & Analytics Consultants", "feed_type": "bowl" }

I’m about to get staffed on an assessment analytics role using Microsoft Access and SQL, neither which I have any familiarity with. Role starts in 2 weeks. Any suggestions on resources and quick maths

like
Posting as :
works at
You are currently posting as works at

Code academy

like

Khan Academy- Intro to SQL, Microsoft Virtual Academy- Querying with Transact SQL, W3, Coursera, EdX

like

Both are fairly easy. Lynda and Code Academy will do the trick

like

Go to YouTube and watch SQL videos on the channel - kudvenkat. They are the best.

like

I agree 2 weeks is a lot of time to demystify a lot of the unknowns, I would say code academy and within 2 weeks you will have a base to help you figure the rest out. These systems were not designed to be complicated

like

I’m doing a SQL course on Udacity and really enjoying it so far

like

If none of the ones listed above are to your liking, pluralsight is AWESOME. I’ve tried other courses and it’s by far the best. I don’t suggest W3 schools if ur starting from scratch. It leaves a lot of unknowns imo

like

Seconded on code academy.

I started from nothing too. So I did a Udemy course, which provided me with a good basic SQL background, enough to do queries and run reports

Thanks everyone for the feedback. I’m assuming for Microsoft Access specific resources, YouTube is probably be best?

Coursera

Hey A OP I have a pretty nice SQL deck I was a trainer at my last company - I send it to you!

Related Posts

Hello everyone!

How much do you think a customer marketing associate at Velocity Global makes? I applied to their posting but no salary insights to be found for this position.

like

HELP my friends! I’ve been invited to a recruiter screen for the initial interview with HR for Global Safety Associate. This job mainly deals with Adverse event/high prescribing meds product complaints. In my current role I deal with on boarding pt & getting patients work done from A-Z till they get on their meds. The only part which is similar is that I’m the main point of contacts for pt so I can report their complaint to Health Canada. How can I convince them I can handle this new job

like

Hey Guys, please how does secondment work within EY (same country different service line). Is the interview process as serious as standard interviews? Just applied for an internal role and just wondering how much prep I'll need. EY EY-Parthenon

like

I love most of my job, but I don’t see a very good path of progression where I am. I love traveling but with a wife and baby at home I can’t travel a ton, I committed to 50% as a non client facing team, leadership roles are only opening on client facing/traveling teams.
I want to focus more on epic/cerner building but have minimal experience in that area… help?

like
like

For Oracle Cloud Functional tech, what is the maximum salary limit for SA-Projects role in CTS?

like

Applied for a role and reached out to a senior director on LinkedIn who may be the hiring manager to talk about their career and the company. We scheduled time to chat but they didn’t give me any sense of whether the role is on their team. How should I approach the conversation? Focus on asking questions about them or selling myself?

like

How much is Ey paying external fdd hires for Asst manger/ senior position, India?

like

Hi. I am currently manage a tele unit. I also manages second dept but was told this a week after taking this position There is no compensation for managing this 2nd department - as large as the first. Do any other nurse managers manage a second department and if so what is the compensation for this?

like

Folks I need some help and advice on how to act.
Situation:
I am a product manager that oversees the most revenue generating and profitable product of the company been at the company a year. My hiring manager (senior PM) left, I’m now doing his job.
Company got acquired. New director of product, new CPO promoted internally.
A different product manager was hired as senior PM for a different product.
New director wants to consolidate my product with his. Director hinting that I’ll report to 👇🏻

like

Any openings in EY as a Business Analyst...

like

3rd year manager / Director 3, at EY-Parthenon. I had someone reach out to me from the PayPal Corporate Strategy team. New to the tech world and levels. What is an appropriate level / title I should aim for as an exit? ps: the recruiter has mentioned there are roles open from Manager to Director, not sure what it means for me. As background, I have 8 years of M&A and IT consulting experience, T-10 MBA and prior engineer. Thank you!

like

Hi, I am looking for a job in IOS Developer Role.

YoE: 3.6

Notice Period: 30 Days

Current Company: TCS

Location: Channel and Bangalore.

It will be great if anyone refers me. Thanks in Advance.

like

Hi Fishes,
What kind of interview questions does Wells Fargo ask for the CCAR role?

What will be future role of scrum master. Career path ahead?

like

Hi Fishes ,

I am having an overall experience of 2+ yrs as a SCCM ADMIN... actively looking for a job change as my current organization does offer me only 2.5 LPA which is quite low as compared to the industry standards to the job role I am inducted into ... Any referrals/suggestions will be much appreciated ..Thanks in advance

Anyone know anything about the Google Financial Analyst role?

like

For those with HOAs and community amenities, are they going to allow guests after June 15? We have a pool and gym in ours that are residents only for now but they haven’t announced opening up yet, so wondering if yours have. Ready to invite some friends over for a bbq!

like

Question for when hiring PMs: how do you know who to follow up with? We've posted jobs on LinkedIn and gotten a lot of apps but no cover letters or anything, just a resume. Since PMs don't necessarily have portfolios like creatives, is the only move to have a call with any potential candidates?

We've debated sending out surveys to people with the potential to move to the next round but that feels weird. Curious if anyone has used/experienced something else before an intro call.

like

Additional Posts in Data & Analytics Consultants

Can someone here share on avg the time spent in the team matching stage? I have now been ‘rejected’ by 2 teams in favour of an internal candidate despite performing extremely well on team match calls. How many Google employees are moving internally compared to new candidates? Feels like an unfair battle, really…

like

Looking to buy a simple watch, < 40mm case, brown strap, preferably leather, simple black face with not too much detailing. Cost < $200.

Any suggestions?

like

Any 🐠 at Miami pride?

Hi M&A professionals, please recommend between Deloitte M&A M vs Aon M&A AD. Both in London.

like

Something to brighten up your day 🤗

Post Photo
like
like

After YEARS of coming out to people, someone came out to me! I feel like I earned someone’s trust. Just wanted to share.

like

Hello! What is the best way to structure a discovery call for SaaS sales? e.g. share a deck, only focus on their use case (current state, goals, pain, etc.), share a story, etc. Lastly, how do you go further than surface level, like if they mention they are having issues with xyz, which is usually a symptom of the problem and not the problem itself. Any info would be appreciated, thanks.

like

Have you been ghosted after an interview?

4 rounds of interviews with Software Testing company & each interview I’ve become more excited about joining them. Each time they have been a little slow for me to hear back, but after the last interview, which I thought went really well, I’ve literally not heard anything! I’ve sent follow-up to the hiring manager & administrator… nothing

Now I’m pretty certain I haven’t been selected, but is it common to not even turn a candidate down?

like

Portfolio valuations exit opps?

like

Best breast pump? Preferably Canada 🇨🇦 but any first time mom advice helps?

like

I joined birlasoft two weeks before.
How many days will be taking to receive Joining kit?

IP associate search in NYC — A+ firm looking for jr/midlevel with chemistry or biochem background. DM me.

like
like

[Urgent]Hello fishes after receiving the offer if I want to update something related to my address in ibegin portal can I do it? I want to update my present address actually please help. My offer acceptance and BCG is pending yet.

like

I'm looking for some kind of Japanese language classroom environment in the Santa Monica / West LA area.

I've been self-learning via Duolingo and other apps for the past year, and I've hit a wall. No problems with reading hiragana/katakana, doing all right with kanji.

I currently need classmates and an instructor to motivate me to memorize speaking phrases and practice active conversation. I know there are apps for this type of language exchange, but they're usually 1:1 matches and virtual.

like
likehelpful

What is your biggest regret in your life so far?

likesmart

What is the base pay for a first year senior manager in digital consulting in Chicago?

Hi Fishes,

I am hiring for automation test engineers with below skillsets.

Selenium + java + API automation: 1 open position
Experience: 3-7 years

Selenium + C# + API automation: 1 open position
Experience: 6-9 years

Company: Atyeti
Work shift: 12pm to 9pm
Location: Pune
Working model: Hybrid (3 days work from office mandatory)

Anyone interested kindly DM.

like

Additional Posts (overall)

I have two contract offers: One is about Data Management/Quality project for 6 months, the pay is 5000£ per month, the other is product data scientist for an early stage startup based in San Francisco for 4 months, the pay is a lot lot less (less than 1000£ per month). Tbh, I am not a big fan of data management, and I totally see myself doing product analytics which is becoming a hot skill in DS field. Is it stupid to turn down the first offer and accept the second one? I would love some advice

like

I am looking for any recruitment agencies that place (VP /Director level candidates in data science and analytics domain in F100 companies. Please do share If you have worked with any particular recruiter in the past and you liked working with .

like

Would you company pay for a real well-crafted course to help novices get to proficiency within a week?

like

Folks who did an Online masters in AI, ML, Data Science or Data Engineering, did it help with your career change, prospects or growth?

like

Anyone with experience at Bureau of Labor Statistics?

like

Interviewed yesterday with a startup and the tech screen involved SQL. Is it always the case you have to write SQL based on a schema? I struggled to write code into a notepad with just schema and it took a bit of time than usual that I would have taken to write those simple-medium statements. Do I need more practice?

like

All I want is a data scientist role at Facebook !! Is it too much to ask for? 😭

likehelpful

Vscode or pycharm, and why?
Pretty much all my work is in python and CLI tools, and I'm lukewarm on notebooks

Anyone at BCG Gamma interested in speaking about their experience? Currently in a data science role at a boutique consultancy and interested in what that looks like elsewhere.

like

How is BCG gamma for career growth? Do people get to partner level from the group? Also what kind of projects do you usually get involved in?

like

I am hiring a Cyber Analytics Lead for my large public sector analytics practice (DC based). Would be overseeing 25+ staff across multiple federal engagements. Looking for someone with experience with hands on analytics (with a focus on cyber), people management, and business development.

Send me a DM if you or anyone you know is interested. I am the decision maker for this role (with my team), so if I like your resume, you will be fast tracked through our process.

like

Since people are posting puzzles, here is one to think about. Using four 1s and no other digit and any mathematical operation, arrive at output 5.

like

This might be a long shot ... but I have a Statistics assignment due for tonight in a few hours

Does anyone know how to do Linear Discriminant Analysis with more than one predictor - by hand? I know how to compute in R but my professor wants it done by hand .... fml

likefunny

Question of the day: How would a retail store go about forecasting orders given the disruption of covid? What model would you use and how would you account for typical yearly seasonality along with current year disruptions.

Have an idea myself but would love to hear from all you expert fishes :)

like

Best consulting firm for Big Data work? I have spark, Hadoop, data lake and warehousing experience with MPP databases, etc..

like

Slalom 🐠, friend got contacted by a recruiter from Slalom, does anyone know if they apply for new H1s & what the interview process is like for a Data Analytics person? Any info appreciated!Thank you!