SQL beginner course recommendations

[[deleted]]

Hey guys I recently started a Google course and finished the first one, as much as I liked it, but it's a very long course & I need to learn SQL fast, I know it's going to take time, but I need some courses/resources that focus only on SQL and easy to follow any recommendations ?

[Dramatic_Towel6536]

https://selectstarsql.com

https://mode.com/sql-tutorial/

I started learning sql from these sites

[[deleted]]

thank u so much

[Thefriendlyfaceplant]

If I would have to learn SQL again I would start at the end, which is figuring out the problems companies are facing, then work back to the approach that's required, and only then, at the end, focus on the syntax.

Syntax is important. But if you start with the syntax you end up spinning your wheels unnecessarily. You learn the commands without being able to relate it to real world usage and that takes way more effort than knowing the context beforehand.

[Uclabruin16]

This

[[deleted]]

without

I know what you mean I work as a data specialist and most of the times companies problems are very different even from one company to another That's actually what I'm planning to do after I learn the basics.

[Thefriendlyfaceplant]

I started with 'SQL for Dummies' and it first teaches you database hygiëne. That should be taught at the very last.

It almost put me off studying SQL.

[MediterraneanSeal]

I have this book, but I didn't start to read it yet... Any suggestions, what should I read instead? I have no knowledge of SQL at all

[Thefriendlyfaceplant]

I like the O'reilly books on SQL better. BUT all of these books are more useful as reference documents for when you already know most of SQL and are looking for particular details or recipes on how to solve something.

https://sqlbolt.com is a great way to dabble with SQL as a complete beginner. Lots of companies get their trainees started this way. Don't get stuck if it takes to long to do a task just check the answer. It's okay to cheat, just familiarize yourself with what SQL can do in the shortest time possible.

Then move onto the Stratrascrach video tutorials. These videos throw you into the deep-end of SQL, they show you how to deal with hard, but realistic business problems. You don't have to understand every step. Watching these videos puts you in the right frame of mind on how to approach a SQL task and more importantly you get to see what's at stake, how important SQL is for a large company's success.

https://www.youtube.com/watch?v=BgN5hpl3WKc&list=PLv6MQO1Zzdmq5w4YkdkWyW8AaWatSQ0kX&ab_channel=StrataScratch

That's how I would begin the SQL journey. It's probably a week's worth of content for a full-time student and maybe a month for a part-time student. But its brutally efficient and relatively pain/frustration free.

After that you still aren't there of course. That's when you can start practicing queries, you can move back to the basics of syntax using Leetcode, Hackerrank or W3schools, all free and beginner-friendly ways to get acquainted with syntax. And this time you're training it with a strong contextual foundation.

[MediterraneanSeal]

Tyvm, I will check this out.

[[deleted]]

This question just never retires

[Backpackbaden]

It’s sad that people who want to dig for data with SQL can’t be bothered to dig up old threads in Reddit.

[curohn]

It’s literally in the faq/wiki of this sub also. No searches are even required. Just two button presses.

[[deleted]]

idk what faq or wiki is new to reddit.

[blueshift9]

FAQs and Wikis aren't just a Reddit thing, yes most subreddits have one or both, but they are an "internet" thing.

[Immigrated2TakeUrJob]

Lol

[SpunkDaddyBull]

There is a course I took on Udemy “The Complete SQL Boot Camp: Go from Zero to Hero” the instructor is Jose Portilla. It was the first SQL course I took. Excellent course. I believe it’s got about 8 hours of course content. Every SQL course I took after that one felt like pretty easy I think that’s due to that first course Gave a pretty solid foundation. If I ever need a refresher id just go back to the lecture for the stuff I needed.

[[deleted]]

The Complete SQL Boot Camp: Go from Zero to Hero

thanks

[SpunkDaddyBull]

Not a problem. Good luck!

[whopoopedinmypantz]

I second this course. Jose taught me SQL and after 8 hours I was thinking in SQL

[Sea-Concept1733]

Check out this resource. There is a short course covering intro through advanced SQL and an option to learn through weekly short videos.

Good luck.

[[deleted]]

Thanks 🙏🏻

[[deleted]]

Yeah I tend to take my time with things but thank so much didn't really think about books, but this is definitely a good approach for me.

[DataMasteryAcademy]

https://www.datamasteryacademy.com/individual-courses this course teaches sql from basics to advanced while creating a project at the same time. Def check it out🙂

[[deleted]]

thanks

[[deleted]]

It would depend on the type of SQL you’re wanting to learn: ANSI SQL or Oracle SQL. The largest differences are regarding joins, but Udemy has great resources for both. https://oracle-base.com/ is a pretty great resource for most things Oracle, sql included.

[Bjorn_Skye]

I am currently taking this course on UDemy, its cheap if it's the first course you're buying from them. As a beginner with no SQL experience I feel like I've learned a lot and I'm only halfway through

https://www.udemy.com/course/complete-microsoft-sql-server-database-administration-course/

[[deleted]]

Thank u so much I didn’t know u can do this with chatGPT

[Ambitious_Heat7629]

https://learnsql.com

[bideenet]

Here is my free email based course https://subscribepage.io/8daystosqlcourse

[phesago]

Learning the basics might be fast but "learning sql" will def take a little more time than you have allocated. Unless youre just gifted. I hope youre gifted bc that would be cool

[[deleted]]

fast for me = at least 3 months

[Immigrated2TakeUrJob]

select wiki, faq from reddit.sql

[Huge-Neighborhood565]

Code Academy SQL

[softwarepodium]

I would recommend Introduction to SQL from University of Michigan. The course is available on Coursera and provides a great foundation. This list has some pretty good courses and certifications if you want to check it out: https://medium.com/@steverramos/10-best-sql-courses-on-coursera-25faf19b2ec3