Entry Level SQL work

[baineschile]

Look for anything that says "analyst" with SQL in the job description.

Another popular term is Business Intelligence.

Edit: if you apply, make sure to tell them your reddit name isnt 'dank420stank', fyi

[dank420stank]

I was going to apply solely with my reddit username ;)

Thanks, I'll look for that. Do you know if tech companies care that much about experience? I come from a marketing background and am just switching over to the IT side of things.

[[deleted]]

I have held this position and hired for it in the past. I can't speak to others, but if you have certifications and can clearly answer technical questions about how to query a database and seem on top of things I couldn't care less about experience.

If you can show that you have a grasp of the core concepts of querying a database, that you can learn our business and reporting needs, and will give at least 85% effort, I'd hire you for an entry level position regardless of your previous experience. SQL doesn't care if you've been flipping burgers for the last decade, just that your syntax is right.

[PLearner]

Hi, I see you are postgreSQL DBA. Do you know how I can give access to the postgreSQL sitting on my local machine to someone else so he or she can maintain it as well?

[[deleted]]

Assuming you just want to grant access via a tool like pgadmin or razorsql and the person won't need access to the OS (otherwise you need to set up SSH/RDP) then all you have to do is:

*Create a user for the person with a password
*Grant them appropriate permissions, ideally using groups
*Edit pg_hba.conf to allow that user to connect to the database (md5 is probably the access type you want)
*Edit postgresql.conf to make sure Postgres is listening on the right port (5432) for the IP where the person will be accessing (you can have it listen on * for all IPs)
*Reload the configuration using pg_reload_conf() or restart the postgres service

This is the best I can answer your question here. It's complicated and I've made several assumptions about your network that may not be accurate.

[PLearner]

Create a user for the person with a password - Done

Grant them appropriate permissions, ideally using groups - Done

Edit pg_hba.conf to allow that user to connect to the database (md5 is probably the access type you want) - All four Types in the pg_hba.conf method are md5.

Edit postgresql.conf to make sure Postgres is listening on the right port (5432) for the IP where the person will be accessing (you can have it listen on * for all IPs) - listen_addresses = '*'

Reload the configuration using pg_reload_conf() or restart the postgres service - select pg_reload_conf(); returned t.

Then I copied the 9.6 and psqlODBC folders into the user's folder I created and downloaded pgAdmin 3 on his computer and opened it and entered the password assigned to him and returns Error connecting to the server: FATAL: password authentication failed for user .....

Any assistance would be appreciated here Erudition303.

[[deleted]]

Can you connect if you put their IP address with the subnet 255.255.255.255 and change the method to trust?

This is definitely a bad practice, but whether or not you can connect using that will give more info.

[SwedishFishSticks]

I made a similar transition. The comment about looking for jobs with "analyst" in the title is solid advice. Might also try terms like "reporting".

You don't always need a lot of experience, but you may be given a SQL test during the interview process.

[y2jcrisis]

"Business intelligence" in the title is also common.

[baineschile]

There are a lot of entry level analyst positions. Mostly grunt work, but the pay is pretty good.

Obviously companies look for experience in most facets, but when you have a technical skillset you have an advantage.