The Complete SQL Bootcamp 2022
Go from Zero to Hero

I'm a huge fan of Pieran's lessons on Udemy. I banged this course out over the course of 3 days at about 3-4 hours of study per day and feel very comfortable playing around in PostGRE and MS SQL Server.

https://www.udemy.com/course/the-complete-sql-bootcamp/

On another post someone recommended this udemy course for SQL if that interest you. I’m also hoping to see their response though.

A tip to get it for way cheaper, copy the url and paste in an incognito window and it’ll be like $13.

Here’s course I did on SQL https://www.udemy.com/course/the-complete-sql-bootcamp/

Also use SQLzoo.net to practice

This udemy course is really good and is only $11 right now: Udemy SQL bootcamp

I did this course which is a great deal when you wait for it to go on sale, and it gave me a pretty good handle on the topic for cheap.

The SQL boot camp course on udemy is really good and will give you a core understanding of writing SQL statements.

https://www.udemy.com/course/the-complete-sql-bootcamp/

https://www.udemy.com/course/the-complete-sql-bootcamp/

340 is teaching a little of SQL. But I found this to be a pretty good crash course on SQL. It used PostGreSQL instead of MySQL but the syntax is awfully similar.

The Complete SQL Bootcamp for the Manipulation and Analysis of Data | Udemy

This Udemy Course uses PostgreSQL and is tbh one of the best courses I've ever taken. There are some commands for PostgreSQL that may be unique, however the logic can also be applied elsewhere.

You should try something a little comprehensive IMO. Udemy.com has dirt cheap online SQL courses that you can do at your own pace. All material is provided including software.

SQL bootcamp course is on a flash sale now for $12

https://www.udemy.com/course/the-complete-sql-bootcamp/

I've been using the SQL Bootcamp on Udemy, it's given me a really good grasp on the basics.

I took a Postgres SQL bootcamp on Udemy. It was very in-depth a well structured. The Complete SQL Bootcamp

I recommend this exact course:

https://www.udemy.com/course/the-complete-sql-bootcamp/

This is what I am using and its great, won’t literally take you to “hero” but will teach you the fundamentals before moving on.

You could run this course in 7-8 hours or less, easily.

https://www.udemy.com/course/the-complete-sql-bootcamp/

Someone recommended this course to me. Looks pretty decent. https://www.udemy.com/course/the-complete-sql-bootcamp/

Not the best source to master SQL and also I feel proper command comes from practice but you can definitely start with this. The instructor covers all the basics and you're not gonna find it difficult even if you're from a non-technical background. You can definitely give this a try.

Also, buy this course when there's an off, Udemy courses are very expensive but every few days they roll out huge discounts.

Course Link = https://www.udemy.com/course/the-complete-sql-bootcamp/

Hope this helps you :)

I'm currently taking this SQL course on Udemy. I like it so far, and it's pretty easy to understand.

https://www.udemy.com/course/the-complete-sql-bootcamp/

This one?

https://www.udemy.com/course/the-complete-sql-bootcamp/

There's a bunch of free courses out there if you google around, but Udemy has some decent and relatively inexpensive ones like https://www.udemy.com/course/the-complete-sql-bootcamp/

Did you get anywhere else with this thought process?

I did economics then worked in manufacturing industry (office based). But I have been looking at data analysis too. I assumed it would be more economics/finance related but a lot of them seem IT related.

Ideally I would like a remote job, I mean perfectly I would love a remote work from any country job, so think data analyst is better for that than say supply chain manager. Was tempted to learn python but haven't got around to it yet.

I did a SQL course

https://www.udemy.com/course/the-complete-sql-bootcamp/

It's pretty piss easy. Don't need any programming experience.

Also I did a tableau course through their website when it was free. It's basically like excel + for graphs and charts. Also easy but a little bit memory for what goes where.

Still haven't got a job yet but they are some extra strings on my bow

https://www.udemy.com/course/the-complete-sql-bootcamp

Hey buddy just a tip but this SQL course is on sale right now and if the sale doesn’t work, I found a code online today that works for it and makes it like $12.

"The Complete SQL Bootcamp 2021: Go from Zero to Hero" by Jose Portillo is pretty solid and has good reviews.

https://www.udemy.com/course/the-complete-sql-bootcamp/

Of course with Udemy courses I would only purchase when they are on sale.

Not meaning to steal this, but I did Complete SQL Bootlcamp on Udemy and am looking for somewhere to go after this course that sort of picks up where it left off.

https://www.udemy.com/course/the-complete-sql-bootcamp/

Ese tiene todo lo basico, son 9 hrs

https://www.udemy.com/course/sql-mysql-for-data-analytics-and-business-intelligence/

Este es mucho mas completo pero da en el mismo tiempo mas temas, asi que no se que tan rapido puede ir, a veces que vayan rapido hace que no puedas entender bien lo que dicen o quieren decir

Igualmente, nada como agarrar una base de datos y cagarte a palos aprendiendo

Cool, thanks!

There was a sale last night, and I ended up purchasing this one just based off the Bestseller tag: https://www.udemy.com/course/the-complete-sql-bootcamp/

Any idea whether it can substitute or complement either of your recommendations? Wondering whether it's worth keeping or whether I should get a refund.

This course ( https://www.udemy.com/course/the-complete-sql-bootcamp/ ) is highly recommended.

P.S: open the link in the incognito :D

My Friend, check this Counse on Udemy.

https://www.udemy.com/course/the-complete-sql-bootcamp/

The best part about this course is, it is the latest.

its on Udemy - https://www.udemy.com/course/the-complete-sql-bootcamp/

Thats because I got the name way wrong. It was Jose Portilla. I took the course years ago, but it established a solid baseline and was well structured.

https://www.udemy.com/course/the-complete-sql-bootcamp

https://www.udemy.com/course/the-complete-sql-bootcamp/

This ^ is the one I've completed so far, Jose is a good instructor who explained things in a way that clicked with how I learn very well. I hope to take more of his classes some time.

The BI one I'm working through is related to QlikSense, so you'd have to be using that particular BI tool to care about it.

I've started this one: https://www.udemy.com/course/the-data-science-course-complete-data-science-bootcamp/ and so far it's good, but the voice over is... let's just say I cant always tell if it's a robot or an actual human with weird inflection (or maybe just bad editing). But it seems comprehensive (I do it on my down time at work so I'm not super far in it) and I hope it teaches me something useful.

New SQL learner. I really learned a lot from this guy. https://www.udemy.com/course/master-sql-for-data-science/

And this 1 https://www.udemy.com/course/the-complete-sql-bootcamp/

Good luck!

I could recommend you this one, obviously only when is on "sale": https://www.udemy.com/course/the-complete-sql-bootcamp

It touches the essentials and you can practice on yourself with the datasets given.
Then, depends a lot of your job's requirements because honestly sometimes the job descriptions themselves are a bit...bloated. Because if you end up in a team as an intern/junior/entry level they already have some kind of database and written queries they already use; hence most of what you're going to do is going to be to select the data based on certain criteria.

https://www.udemy.com/course/the-complete-sql-bootcamp/

But I didn't took that one, so I don't know if he focus on MySQL only...

SQL Bootcamp: https://www.udemy.com/course/the-complete-sql-bootcamp/ Python Bootcamp: https://www.udemy.com/course/complete-python-bootcamp/

Both of these are hands-on and very digestible. Good luck.

Their "Foundations of EDB" postgres training seems to be truly free.

I can also recommend This for a quick intro to postgres SQL.

This is a more advanced course when compared to the first udemy course I linked to.

This one is highly rated: https://www.udemy.com/course/the-complete-sql-bootcamp/

I took this one and found it good, author is a bit dry (British): https://www.udemy.com/course/70-461-session-2-querying-microsoft-sql-server-2012/

Book wise, you cannot beat Itzik Ben-Gan: https://www.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X

Beginner to completion time?

Hi all,

I’m hoping to matriculate into medical school next fall but am seeking a a stable job for the next year or so. I have a BA in economics that included advanced stats coursework and projects. I also have a bit of experience using Python and SPSS in my research. I’m seeking advice on how to get started and assume it will be easier to start as a data analyst. I’ve been sending out my resume with no luck but figure COVID is at least playing a role. Does anyone have an estimate for how long it will take to get hired? Also, how long after completing intro courses like these can I get hired? I’m currently a PT tutor but am looking for more hours and higher pay. I’m wondering if I should take a customer FT service job or just dedicate all my time to learning these tools. All advice is greatly appreciated!

https://www.udemy.com/course/complete-python-bootcamp/?LSNPUBID=JVFxdTr9V80&ranEAID=JVFxdTr9V80&ranMID=39197&ranSiteID=JVFxdTr9V80-rKxfnF1FoCy3TcLlaIGzfg

https://www.udemy.com/course/the-complete-sql-bootcamp/

https://www.udacity.com/course/data-analyst-nanodegree--nd002

There are a lot of good courses on Udemy. Some may look expensive but they have frequent "sales" where you can get +$200 courses for less than $20. I've listed a few I've taken myself below.

The Ultimate Excel Programmer Course

The Complete SQL Bootcamp

Maven Analytics

Thanks! Is Udemy a truly good place to learn SQL? I am currently debating between these 2 courses: The Complete SQL Bootcamp 2022 by Jose Portilla - https://www.udemy.com/course/the-complete-sql-bootcamp/ and The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert - https://www.udemy.com/course/the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert/

There are just so many courses that look really good, but are they actually effective?

Check out Udemy! That’s where I did SQL learning. I wasn’t really fully taught it in school and had an internship coming up so I looked around on there. There’s also some that are more role specific. Here’s a few of the top SQL courses...

Complete SQL Bootcamp

Ultimate MySQL Bootcamp. Go From SQL beginner to expert

Complete Oracle SQL Certification

SQL/MySQL For Data Analytics and Business Intelligence

https://www.youtube.com/watch?v=HXV3zeQKqGY

​

and one of those Udemy, but dont buy it now, wait for a sale.

https://www.udemy.com/course/the-complete-sql-bootcamp/

Here are the topics/certifications that I have been studying, in order. If you can commit to studying 2-3 hours per day, you can knock out the essential skills of all of these tools within 1 year.

Source: Me. I am currently on the R step of this learning path toward becoming an analyst.

1. APICS/ASCM certifications: https://www.ascm.org/
2. Excel/power query/ power BI: https://www.youtube.com/user/ExcelIsFun
3. SQL: https://www.udemy.com/course/the-complete-sql-bootcamp/
4. Tableau: https://www.udemy.com/course/tableau10/
5. R programming language: https://university.business-science.io

Hope this gives you more ideas!

I never had a mentor but I think you can learn those 3 topics by yourself. If you have questions, you can google the answer or post them on dedicated subreddits

1) Sql - start with this video https://youtu.be/HXV3zeQKqGY. I think that's more than enough. If you would like to take another approach, here's a course that helped me to prepare for an interview: https://www.udemy.com/course/the-complete-sql-bootcamp/

2) Tableau - buy a subscription to plural sight and there are multiple courses

3) Storytelling with data: start with the best book on the subject: https://www.amazon.com/Storytelling-Data-Visualization-Business-Professionals/dp/1119002257/ref=sr_1_1?crid=13361Y2KECDA3&keywords=storytelling+with+data&qid=1579990640&sprefix=storytelling+%2Caps%2C261&sr=8-1 . It has a workbook also.

1. Bought this and currently going through it. This is MS SQL Server

https://www.udemy.com/course/70-461-session-2-querying-microsoft-sql-server-2012/

1. Already took this. This is PostgreSQL

https://www.udemy.com/course/the-complete-sql-bootcamp/

1. Just bought this last night so I can learn MySQL and do data analytics

https://www.udemy.com/course/advanced-sql-mysql-for-analytics-business-intelligence/

1. I also bought this, started it but planning on finishing after I finish above. This one goes through several backend including node.js

https://www.udemy.com/course/node-postgresql/

These are some of the courses I’ve taken or is taking. You can google Udemy Promo code and should be able to find some code that will bring the price down to around $10-$12 or so. Just gotta try few out to see which works but I always get my udemy courses for this price.

A few thoughts:

EasyMorph is a great visual data transformation tool that can help you understand the data you are working with and is a great place to work on your queries before taking them into Tableau.

This Udemy course is pretty good (just make sure you don't pay more than $15). It's for Postgres, but there's not a whole lot of difference.

As others have mentioned, SQL is fairly straightforward. Get some example queries, look up everything you see ( here, or just google), watch a few videos and play around.

It's also worth mentioning that custom SQL can cause performance issues and it's best avoided if possible:

https://community.tableau.com/thread/255414

https://kb.tableau.com/articles/issue/custom-sql-performance-issues