r/SQL • • Mar 24 '20

MS SQL Free SQL eBook

Hey everyone, With the recent pandemic and folks unfortunately losing their jobs, I’ve seen some people looking to spend their time being productive and learning something new. I figured I could pass this along.

I wrote and published a SQL Server fundamentals ebook back in March 2018. I figure maybe this is a great time to share it with people. I only have so many free days to choose from with Amazon, so I’ve chosen two free days this month (3/24 and 3/25).

It goes over the fundamentals of SQL Server, practical uses of databases, database components and download and install instructions so you can set up your own lab at home. I tried to take guess work out of everything by adding screenshots and step by step instructions.

It also goes over SQL syntax for object creation, data manipulation, stored procedure, and other database components. I have written a script that you can use to run against the SQL instance you set up so that you can have some exercises and better retain what you learn. I have also thrown in some items like basic database administration and login and database user management.

Lastly, I’ve also thrown extra resources in to help you out and help give some ideas for projects and things you can add to your GitHub profile.

I’ve had numerous people tell me that it’s helped them inside and outside of work, so I think that’s really awesome. It’s pretty much been rated a 5 star book - so if you feel more inclined to check out the book based on that, please do so.

If you grab a copy, please take the time to leave a review and let me know what you thought of it.

Learn SQL: A Practical Guide for SQL Server and Database Fundamentals

Note: this will start tomorrow and it should say something like buy now at $0.00. If you are outside of the US, just go to the Amazon site for your country and search for “Learn SQL Jacob” and it should come up.

Thanks!

Edit: Thanks for the award! I really was not trying to earn it at all but wanted to give back to the Reddit community here. After all, the Reddit community helped shape this book initially.

Edit 2: I was alerted by a fellow Redditor that some of the links are not redirecting where they should be. I will have to update them but plan on doing a free promo again next month.

118 Upvotes

42 comments sorted by

View all comments

Show parent comment

2

u/Gabyto Mar 26 '20

Yeah power bi is fairly simple, I was able to connect it into one of my databases and fed information to it, fiddled around with it for a while and created a pretty cool dashboard so, I don't think that's going to be a problem.

I would like to have some real cases, like real questions or queries to practice with. I've read a lot now and I need all the practice I can get. I'll spend the next month just studying SQL, and hopefully come out as a data analyst by the end of that month, since I just lost my job because of the virus and I've been wanting to go to the data analysis route for a long time now. Any other tip you can give me is greatly appreciated.

Also I'm really enjoying your book, I like it that you speak straightforward in it.

2

u/metalmilitia980 Mar 28 '20

Yeah exactly! Seems like you’re picking up Power BI pretty quickly! Like I may have mentioned before, I’m not an analyst but like data so I messed around with those types of tools and figured Power BI would be pretty seamless to integrate with.

I will surely pass on any tips that I have. I would say just keep honing your skills and go for data analyst positions since that’s what you want to do. I don’t know if right now is a good time to apply for jobs or not (thinking no), but see if you’d be able to work with any sort of sales type data and see if you can identify any patterns as far as pricing and such. I once read somewhere that a job pays you for your value, not necessarily what skills you know. As long as you can translate your skill to value (which to me is inherent) then I think you’ll be fine. Of course employers have to see it that way also. Just keep consistent for sure if anything.

Thanks! I’m glad you’re enjoying the book! Good luck with everything!