Where can I create my own sql database and practice around?? Do I need a monthly subscription? Where would you recommend?

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

Or just do a local install of Postgres or something

like

Assuming you’re just trying to do some pretty basic exploratory testing and no performance / scalability

Spin one up on Microsoft Azure. Cheap and easy. Enroll in some free courses on EdX and you’ll be all set

like

Download Oracle Express, its free and can handle up to 11gb of data

like

Honestly, I’ve found docker to be the simplest and most expedient way to play around with different database engines. You can be up and running in minutes with several different RDBMS flavors. MySQL, PostgreSQL, MariaDB, DB2, etc. https://hub.docker.com/search?category=database&source=verified&type=image

like

Ds1, not sure. I tried this in my deloitte laptop

GitHub allows SQL and python free. Azure charges for everything, usually Google does too. Microsoft SQL is also free and MySQL. You can run SQL through Access too. Find out what your company will approve. I've had some ridic companies that plan everything for just Excel then you gotta create a cloud account and hope the server isn't blocking it via admin. Ok, I will go NoSQL and play with Access a bit! ROFL. Even Excel and Access are best with MicrosoftSQL or MySQL though.

likehelpful

Dude, sqlite3.

like

Setup up your own on your laptop.

like

You can locally install MS Sql server express edition 2019.

like

Sql server DB performs better than any listed above on PC.

like

MA SQL Server Development is free

like

Yeah just a small data set I want to play with for complex queries as I prep for interviews. I’m set up on google sql cloud, is that a good option as well?

So long as you can run your DDL to build a basic model, load your data, and read your data.. you’re good (so any of the numerous options should suffice) best of luck prepping!

like

How can I even start from the bottom of sql? I don’t even understand any of the lingo ^

Try to get the syntax down via sqlbolt, Hackerrank, sqlzoo! Took me a few days but getting the hang of it

like

So many opinions. I’m just waiting for someone to swear on access 😂

Related Posts

Need 15 likes for DM. please help.

like
like

I just got an offer with almost double of what i make now. I'm so worried about the recession. First in first out. Is that something I should bring up when im signing my offer?

like

Any thoughts or experience on Manager of Analytics v. Sr. Manager of Analytics v. Head of Analytics titles? Is that a typical progression for an analytics career? Any titles I’m missing? What are the biggest differences between the titles? Any estimate for years of experience in the field associated with each?

I know this is a long question :) Answers to any small subset of this question would be greatly appreciated! I understand one answer to the entire question is a lot.

like

Can an American creative freelance in London? What visas do you need? Anyone done it?

like

Apartment gym and pool have opened back up ! Finally!!!

like

Any good strategy consulting firms in LA that don’t have a toxic work culture? Very ready to leave Deloitte and don’t want to work 60+ hr weeks anymore. Pipe dream? (Also taking recs for other jobs)

like

Hi All, pls give me 11 likes so that I can DM people's. Thanks in advance

like

Anyone with IT project management experience in wealth management/financial services industry, please reach out. At least 3-4+ years of experience

like

anyone in agency life who made the decision to be a floater? thinking about asking but don’t wanna seem like i can’t play nice with others. i legit just like the rhythm of mixing things up and working with different people.

like

Any good resources for finding competitor communications from pre-2005? Looking to do a trawl of some TVC advertising (and print if possible) from 2001.

like

Any recommendations on silk pjs? I’m trying to treat myself. Preferably shorts/shirt sleeved shirt rather than longer pants and shirts.

like

Hello everyone,

I will be joining a venture capital and private equity firm in Bangalore as a Analyst Intern. Very excited and looking forward to it as it's my first time in a corporate setting.

- Any tips, advices, and resources which will increase my chance to get a full time role at the same organisation?

Thank you and have a great day!

like

Will Cognizant provide accommodation to new joiners for at least 1 week for relocating?

like

Anyone has moved to Germay or other part of Europe and successfully landed a job as a US CPA?

like

Anyone open to providing a referral into a Product Manager role?

Does anyone have tips for social anxiety at work? I’ve just moved to a new office in a new city - it feels cliquey and is giving me anxiety I haven’t felt since high school. I’ve been feeling so stressed that I’m just working from home, which can’t be helping me make friends / meet new people.

like

Hi All, Does anyone know who are eligible for Accenture Annual salary review process? What is cut off date after which if you join you will not be eligible for salary review process for that year? Kindly share inputs if you know this clause. Thanks.

like

Additional Posts in Data & Analytics Consultants

like

Hey all. Question regarding Presto SQL and Arrays.

I’m working within a Presto DB and the column contains a nested array. I need to pull out the 3rd item of each array. Does anyone got any info on how to approach this?

like

Would working with a data lake be valuable experience? Was offered that as my next project.

like

Would recommend data engineer or software engineer for pay and growth potential?

like

I have 2YOE and a liberal arts undergrad. Does an MSBA open more doors into analytics? I don’t really see myself getting an MBA at this stage of my life, but I’m not entirely closed off to the idea yet.

like

Data engineering or data science as your starting career for job security and ease of moving around to different jobs?

like

Vibe check - do you also feel often times that you are a wizard who pulls a rabbit out of his hat on each project, with unrealistic timelines, no data, understaffing and lack of clear requirements?

like

Hi All,
I have a question about replicating an Alteryx model in python. Basically the Alteryx model used to clean, combine, prep, run some business rules and spit out a formatted file ready for running further analysis/viz. Can this same process be automated using a python script? I’m new to python and would like to know what packages to learn to do this.
Thanks!

like

I’m 3 months into a my first job as an entry level Business analyst with high data focus at a big investment bank but contracted by a consulting firm. I don’t come from a tech/finance background so I was promised training. I don’t feel like I’m don’t feel like I’m learning anything though and everything is so slow placed I feel more like an intern given small tasks. my manager is also new to tech so I don’t know who to look for as a mentor… any advice pls ?

like

Lunch discussion at the office, curious to hear your thoughts: Does one need to learn data science first to be a good data engineer / architect? Why / why not?

like

Any recommendations for resources to learn intermediate / advanced Tableau? All the firm-provided resources I could find seemed very basic

like

Anybody have any luck using virtual box to load a VM on windows 10? Throwing an error saying:

“The hardware virtualization is enabled in the Acceleration section of the system page”

like

Wanting to get out of fed space. I am a data scientist with 5YOE. What are good companies to look for in DC area that’d hire someone with gov consulting experience?

like

I studied for 2 months with a friend and doubled my income to 200k+ the consulting game is a a racket and to that extent big tech is too BUT big but tech and large streaming companies actually pay top dollar for good talent that can code . These suits have been lying to you ALL. Wake up in the morning and studying my friends you do not need these consulting firms they need you! Do not feed into there bs…studying for interviews and get you fare share of this tech wave… I am making more than my Ms

likefunny

Any highly recommended videos or resources that give a comprehensive approach to sales forecasting?

like

What’s the best company for machine learning projects?

like

Considering a data and analytics role for a data migration project. What kinds of SQL queries will I be expected to know?

like

Has anyone here taken the Nike SQL assessment via HireVue? Wondering what to expect.

like

DM for referral at a boutique consulting firm:

- fully remote
- good WLB
- hiring all levels with above average pay
- 3+ YOE with experience in analytics/BI in financial services background preferred

likehelpful

Anyone else has the feeling data science consulting is over glorified? Projects are so small they have little bottom line impact.

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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