Are there any companies/careers that will train you on Sql?

[daboywonder2002]

Trying to learn sql but for me, I just find it boring. I've watched videos on O'Reilly, sql zoo, ws3 and even shadowed a data analyst at work. She uses sql server management studio. Currently taking a linkedin learning course. But I use my work computer and I dont have admin rights to download anything. It's one thing to go on sql zoo and select countries from lists and populations. It's another to actually use it at your job. On my resume I put basic understanding of sql. I would honestly rather get hired as a Business analyst or Data analyst and they train me on Sql. I feel like I pick up things rather quickly. But I learn better through repetition. actually doing the work. Not watching someone on youtube. Any job titles I can get where I can either be trained on sql or just learn as I go? I'm tired of trying to cram all this sql knowledge just so I can get a job.

 

[Based Lord Zedd]

Ask your job to give you access, they already have sql. Unlikely it costs much to let you use it.

My SQL skills have improved a lot at my current job despite it not being a core part of my role. I had to demand access though. I'd also say most of my SQL skills were developed playing around at work and trying to build stuff on our db.

 

[greenvale]

Trying to learn sql but for me, I just find it boring. I've watched videos on O'Reilly, sql zoo, ws3 and even shadowed a data analyst at work. She uses sql server management studio. Currently taking a linkedin learning course. But I use my work computer and I dont have admin rights to download anything. It's one thing to go on sql zoo and select countries from lists and populations. It's another to actually use it at your job. On my resume I put basic understanding of sql. I would honestly rather get hired as a Business analyst or Data analyst and they train me on Sql. I feel like I pick up things rather quickly. But I learn better through repetition. actually doing the work. Not watching someone on youtube. Any job titles I can get where I can either be trained on sql or just learn as I go? I'm tired of trying to cram all this sql knowledge just so I can get a job.

You are on the right path. Try to cop an analyst job at any fortune 500 company and you will likely have to use SQL

 

[daboywonder2002]

You are on the right path. Try to cop an analyst job at any fortune 500 company and you will likely have to use SQL

will they try to gauge my sql knowledge during an interview?
Because I feel like I understand it. but its one thing to put select name, population from world where area > 3000 and population >4000.
and another to work for a hospital and bank dealing with their database

 

[Trips]

With my current Company, I started out as lower level Data/Reporting Analyst. I had a base level familiarity with SQL at the time that I got hired into the role. The bulk of my initial workload was Excel based and that is what they tested me on to hire me for the role. Within a year or so I was moved to a business analyst. I did the udemy course in my spare time to get more proficient with SQL. But, if the Company you apply for has a reporting/analytics department you'll easily be able to get access to SQL as well as have access to really run/repeat/test stuff often.

I'm now the manager of our Reporting/Analytics division. When I interview new hires if they indicate they have some level of knowledge of SQL - I will ask them general knowledge questions, just to get an idea of what they actually know and what they can actually do. For the most part my entry analyst don't write new SQL scripts/queries. They primarily run existing ones, and occasionally have to edit. So they get ample opportunity to learn on the job.

I would say if you get tested for the job. The test will be like most of the free courses you see at stuff like code academy. These are designed mainly to just make sure you didn't bluff on your resume.. Most of the people I've rejected don't pass our basic excel test, so if they bomb that not really worried about what they say elsewhere.

 

[LV Koopa]

These are basic SQL introductions but try these OP if you want interactive learning:

SQL Murder Mystery

Use SQL queries to solve the murder mystery. Suitable for beginners or experienced SQL sleuths.

mystery.knightlab.com

Select Star SQL

selectstarsql.com

Both are broswer based so no setup needed.

 

[Data-Hawk]

When at work. I only use one website -> SQL Tutorial

Then again I dont really develop complex queries. But it's still a good site.

 

[null]

@daboywonder2002

open a terminal/cygwin/xterm/etc

type 'sqlite3'

if sqlite3 is installed you are good to go

Spoiler: links

SQLite Home Page

Query Language Understood by SQLite

 

[Peter Popoff]

Are you trying to run sql or create coding for sql. Some jobs are vague in what they want. Executing sqls is easy as shıt. I do those all day. I am going to learn the coding part and work my way up though.

 

[Peter Popoff]

You are on the right path. Try to cop an analyst job at any fortune 500 company and you will likely have to use SQL

Yup, this me.

 

[Neo. The Only. The One.]

Learning sql on the job right now. I took a short class last year, but I forgot a lot. Having to use it on the job and see it in action is making the concepts stick a little better this time.

 

[xXMASHERXx]

I don't understand why do you have to learn on the job? Why can't you install SQL at home and use that to learn?

 

[Ethnic Vagina Finder]

youtube and google

I learned that shyt in 2 days.

 

[BaggerofTea]

Set up your own sql database with fake data

 

[Conan]

Not gonna lie I learned SQL much faster on the job than practicing on my own.

But if you really want to learn SQL on your own, then push beyond writing basic SQL queries (SELECT/JOIN/WHERE/HAVING/Window functions). Do the following:

1. Set up your own sql database
2. Learn procedural extensions to SQL (for Oracle, learn PL/SQL. For Microsoft learn T-SQL. And so on).
3. Learn to use those procedural extensions to create/update tables, write functions in SQL, check for errors, and log events that happen in your database
4. Learn query optimization for your specific SQL type. Memory management, making queries efficient and faster, and so on
5. Integration with other languages: can you feed your database off of web data? Can you have your database push daily files out for further data processing in Python or another language?
6. Traditional data engineering works off of the ETL model (extraction of data from original source, transformation of raw data into needed information, loading information into database for storage and use). But with the explosion of big data and the availability of cheap storage, people are moving to the ELT model. Can you use tools within and without your database to be comfortable in the new model?

If you learn all that on your own, you'll be sorted for any basic SQL job. If you just focus on the basics on your own, you'll be overwhelmed in the real world. Just my opinion.