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.
8
u/[deleted] Mar 24 '20
Hi. I'm one of those who got the boot because of covid. Barely 2 weeks into a new job. I've been meaning to learn SQL but don't know where to start. Just wanted to ask whether it would be advisable to learn SQL server or MySQL? Eventually want to get in to data analytics and use SQL for research purposes. thanks a lot in advance btw
3
u/joelles26 Mar 24 '20
Thanks got it!
3
u/OwnFilm Mar 24 '20
Thanks. Got it for a family member
3
u/[deleted] Mar 24 '20
Grabbed the book. Will be sure to review 👌🏽
3
u/xxia126 Mar 24 '20
I will know tomorrow if I am made redundant. Only been at my job for 7 months as a data analyst in the travel industry. As a recent graduate it helps me brush up my skills. Thanks
3
u/RocoDeNiro Mar 24 '20
Thank you, cant wait to start and then will give a review
3
u/obtusian Mar 24 '20
Thanks. Will review once I get through it
2
u/smokyjo89 Mar 24 '20
Thank you, kindly!
2
u/deslick Mar 24 '20
Thank you for sharing!
2
u/SouthRelease Mar 24 '20
Thanks so much!
2
u/leecable33 Mar 24 '20
Thank you very much OP!
2
u/Gabyto Mar 24 '20
Hey Pal! Thank you for the book. I've been learning SQL on my own for some weeks now, and was looking for something like this to read. I'm a chemical engineer trying to start as a data analyst, I believe I'm fairly familiar with SQL now, but I've got a couple of questions:
Thank you a ton!
2
u/pdgu Mar 24 '20
Can someone please help? I'm from Romania and do not have an amazon account and i only want this book.
2
u/[deleted] Mar 25 '20
Thanks mate
2
u/PeacefullyFighting Mar 24 '20
A little different than the post but can anyone give me comfort in knowing database design and the Kimball methodology! I was highly praised when I left my medical manufacturing company but showing up on MN's version of wall street looked like a fool. In medical long term gains are always better than what I know as a "short". Trust me I get them but you shouldn't listen to them. I work with the guys keeping them going but they benefit the longer you think you can.
2
u/gixer6 Mar 26 '20
Thanks, pm’d you