just wondering - is access SQL very different from SQL server SQL? Is it kinda like tableau Vs power bi?

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

MS Access uses JET SQL, while SQL Server/Azure uses Transact SQL (T-SQL). Other platforms use different “flavors” of SQL however in my experience the basic functionality is pretty much the same general syntax however the advanced concepts may differ significantly depending on the features of the database. For example, Postgres uses PL/pgSQL that layers on a ton of additional functionality that will be foreign to non-Postgres users.

It’s probably better to think of SQL as a small “standard” and the flavors of SQL are a superset of the standard — they include everything in the SQL standard but each have their own specific additions

like

SQL is a database querying concept. It's important to know the logic on how to query your data, rather than know the syntax. Things like aggregations, joins and window functions (to a great extent) have the same syntax in all SQL flavors. Just have to remember the logic for these, you can always Google for specific syntax then.
And as DS1 mentioned earlier, it is more transferrable than most data viz tools

like

SQL language is very similar, but there can be minor changes to it based on the platform. For some reason every single one likes to add their on nuances.

It is even more transferable across softwares than PowerBI vs tableau though.

like

Related Posts

Please suggest popular areas for 2BHK affordable rent in Toronto. Both my husband and I work from home and have recently moved here. Have stayed in basement accommodation for over 6months. Would like to have a slightly bigger place.
Any recommendations please. Thank you!

anyone here with Salesforce and do product willing to chat?

like

Come on SOS. Lets hit $10

like

First time home buyer here. Currently waiting to close and trying to make a list of everything I want/need when going from an apartment to a house. Think I have all my basic tasks written down regarding canceling accounts, changing address, etc. Also started a list of tools and necessities for upkeep of house/lawn. Also looking at useful things like smart home devices, kitchen tools, automatic soap dispenser. What are the nice to have and splurge type purchases that have made your life better?

like

Starting a new fully remote role Monday with a leader that has never had their own admin, let alone an exec assistant. Any suggestions for developing the relationship or training them to properly use an exec assistant?

like

KPMG EA’s - how many of you are going into the office? Average number of days per week?

like

How much do you tip your driver? I’ve never used ride share before but will have to start this month for work and I’m scaaared lol tipping makes me anxious so please let me know!

like
like

What will be in hand salary? 10.5 lpa

Post Photo
like

Hi,
what will be the inhand salary after TDS deduction for 16.5 LPA.

No investments nothing.

like

Does anyone else constantly put off putting their time in as they go and then hate their life at the end of the month? Then once you get caught up, you don’t want to enter more time, and so you fall behind again. It’s a vicious cycle.

like

I feel like this is the busiest billable December I’ve had. Anyone else absolutely swamped with work this month?

like

Why is it some companies make you reapply to a role when you’re towards the end of the interview process?

When you’re discussing the company on community pages like reddit, do you use your own name or the company name?

like

My wife is around 3 months pregnant. Doctor has recommended Irospan. And my insurance says they don’t cover it. And it is coming aroun 695$ without insurance, I found good Rx coupon which comes around 200$. Does anyone have better suggestions to check for coupons? And is iron deficiency common during pregnancy? Any valuable suggestions are welcome. Thanks

Recently interviewed at Adobe, it was great. Even the senior designer I was connected with escalated it a lot. But then suddenly after the last interview, I haven’t heard in a week from them even after multiple follow ups. Recruiter said she will reach out on Monday, but even Tuesday passed now. Should I wait a week or move on for other offers?

like

Almost 4 weeks in and my status is still wrong. It was correct for the first ~1 day and then bumped down a level. Shouldn’t be hard as all my nights last year were SPG. This is ridiculous.

Hello! I’m currently a Administrative assistant now working at a major medical system in Baltimore. I’ve previously worked for 10 years as a medical assistant in a variety of specialties and primary care. Lately, I’ve been feeling a bit stuck as to my next step. Part of me want to go into management, another part is saying go get your RN, and the other is saying go into Social Work. I’m all over the place. Any ideas? And how would I be able to cross over to management?

like

Netsuite interview for Solutions Consultant Academy.

Has anyone on here interviewed for this position before? How did you prepare? If not, how do you prepare for pre sales interviews. I haven't been able find much insight online about this role.

What a week

like

Additional Posts in Data & Analytics Consultants

Quick survey: Do you guys think having a template package to envelope an ML model as an application would be helpful. The package could contain boiler plate template for unit test, docker image, CI/CD, database connectors etc and act as a starting point for doing that. Tech firms usually have that internally but limited options in open source.

like

Hello, Anyone here from Deloitte Omnia AI who could refer me for an open opportunity.

like

What is Accenture’s data scientist interview process like?

like

McKinsey & Company Does somebody have experience regarding
compensation differences between
QuantumBlack & McKinsey? I am in the process at
QB and disappointed with the salary that's
proposed. (New grad Data science from top
university applying for London) McKinsey & Company QuantumBlack

like

Is anyone working with Elastic at DoD?

Any conda users in here have to install a binary and use conda forge? Need some help installing pdftotext. Throwing a weird message saying “Found conflicts!” Any and all help would be appreciated.

like

Hiring for data scientists and BI analysts across a couple levels, DM me if interested!!

like

In the most unnecessarily complicated phrasing worthy a dissertation, what are you working on this week?

like

Docket + R - I have an container running a rocker image and I’m trying to launch a bash terminal and the RStudio server (/init) at the same time. Is this possible? I tried adding CMD [“/init”] too.

like

How should I move to tech as a ML Engineer? How did people here make the transition?

likehelpful

Looking for an entry-level data analyst position in the DC area. Have a BA in economics & certification in Computer Science. Also 3 years of professional work experience as a full time marketing manager which I performed while attending school full time. I’m a self-starter and extremely driven. I also have a passion for data and statistics, and plan on pursuing my MS in data science within the next year. Please let me know if you know of any positions! Thank you.

like

Is 128k a fair base salary for Consultant in Deloitte Analytics & Cognitive. MS CS and about 3 yrs experience. In one of the fastest growing but midtier tech cities in the US.

like

What’s so good about the Georgia Tech OMSC and OMSA? Is it just the cost? Seems to be recommended by most of reddit

likehelpful
like

Does anyone work at EY in their Decision Modeling team? Not asking for answers, but just wondering if someone is able to share what concepts I should be familiar with when prepping for the case study (i.e. do I need to know how to run an LBO or is a DCF sufficient)?



like

How hard is it to get an interview for SWE at FAANG outside of on campus recruiting? I’m in GT’s OMSCS program right now, hoping to take advantage of career fairs this fall, but I don’t know if I’ll have enough time to prepare for the technical interviews before then. I’m worried about missing out on the recruiting opportunity and having to resort to applying online/LinkedIn afterwards. Any insights into this?

like

Anyone have a ballpark range on dataiku price per seat or however they price? It looks like an interesting product.

My manager continues to ask me to help other teams and do work on other billable projects. I’m sick of it .. and I’m going to explicitly say that no I can’t do it because my hours are taken by the existing project we are doing. Is this appropriate?

like

Anyone in the KPMG Lighthouse practice that would be willing to take a look at my husband’s resume and put in a referral? He’s interested in the Associate, Data Scientist position.

How does everyone in this bowl feel towards master’s degrees in data science/analytics? I didn’t study this in undergrad so I’m looking to get an analytics degree but I’ve heard mixed reviews.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal