SQL for Data Analysis - with SQL Server
Below are the top discussions from Reddit that mention this online Udemy course.
The most direct path to mastering the SQL skills you'll actually use on the job
Reddemy may receive an affiliate commission if you enroll in a paid course after using these buttons to visit Udemy. Thank you for using these buttons to support Reddemy.
Taught by
Travis Cuzick
Reddit Posts and Comments
0 posts • 8 mentions • top 7 shown below
1 points • theLimeTime
SQL for Data Analysis on Udemy. The instructor uses MS SQL Server and will walk you through basic queries and operations on the AdventureWorks DB.
I completed it recently and it's a great (albeit short) beginner course for learning SQL on a sample DB.
1 points • doitordontdoit
I wonder what class you will be taking - will you be working with MSSQL (Microsoft SQL)? Reason I bring this to the table (sorry, no pun intended - I am a dad afterall) is because back in my early days I was influenced toward mySQL as opposed to MSSQL.
However, at the end of the day, without going into technical semantics, they are both rather similar. But for professional reasons, I now work exclusively with MSSQL; except at home, where I still have a couple of projects that utilize a mySQL server. I find it valuable to have learned both platforms, but if you will be working exclusively with MSSQL, I would head down that road for a head start.
This link was posted the other day for a free Udemy course (not sure if expired or not): https://www.udemy.com/course/sql-basics-crash-course-with-sql-server/ Focus is on first steps on setting up and using SQL development environment. But there's tons of free online 'classes' - you just need to do some research and figure out what one suits your learning habits.
1 points • TravisCuzick
Hmm, that is strange...you could try navigating directly the course page at
https://www.udemy.com/course/sql-basics-crash-course-with-sql-server,
then entering coupon code FREE-SQL-TRAINING at checkout. Hope that helps!
1 points • DA38655
You can download SQL Server express version. It's free and you get SSMS with it. Only caveat is you cannot have individual databases larger than 10 GB. But you can have multiple databases under that limit. I had to use it when I needed to upsize from an Access DB for work when the dataset I was analyzing got too big.
There is also a course on Udemy that shows you how to set it up and walks through a bunch of the basic to intermediate SQL with the sample adventure works dataset.
https://www.udemy.com/course/sql-basics-crash-course-with-sql-server/learn/lecture/21827334#overview
There are some other courses on there for Postgre or MySQL as well that are probably more comprehensive. I believe they also show you how to set up a free environment to play with
2 points • drunkondata
https://selectstarsql.com/beazley.html is fun
I liked https://sqlzoo.net/
https://www.kaggle.com/learn/intro-to-sql uses Python as well, so maybe not quite ideal.
https://pgexercises.com/gettingstarted.html is good once you've gotten a bit down, as it wants you to answer, then see the process.
r/udemyfreebies has gotten me many free SQL classes too.
​
If your boss is paying i quite enjoyed https://www.udemy.com/course/sql-basics-crash-course-with-sql-server/ and https://www.udemy.com/course/advanced-sql-server-masterclass-for-data-analysis/ when they were so kindly given away on Reddit (one of the few SQL Udemy freebies I actually went through)
I also really enjoyed Datacamp for their Python when they were free (never tried their SQL but I believe all the part 1's are free)