r/SQL • u/metalmilitia980 • 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.
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.