Reddit reviews Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference)

I think this is a great beginners / fundamentals book. It will give you an in depth focus on the basics:

​

https://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145/ref=sr_1_3?ie=UTF8&qid=1536613857&sr=8-3&keywords=tsql+fundamentals

This book Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference) was really helpful in my learning tsql from scratch a few years back. I recommend it to anyone asking about a good book to learn sql

Edit: I'll add that it's a great starting point for the fundamentals, but it's a never ending learning game. Source: I've been a database engineer for 4 years and still learn new things all the time

MSSQL doesn't use PLSQL, it uses T-SQL.

As someone else said, you can lookup details on technet.

I've written more SQL than I care to remember. The best book on it, that I know of, is T-SQL Fundamentals by Itzik Ben-gan.

That's basically just a list of predicates.

Pick up an Itzik Ben-Gan book, that should help immensely.

Not losing any data is VERY expensive.

I'm talking millions.

Here's my recommendation.

https://www.brentozar.com/sql-server-training-videos/sql-server-disaster-recovery-basics/

https://www.brentozar.com/archive/2016/07/updated-high-availability-disaster-recovery-planning-worksheet/

https://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145/ref=sr_1_7?s=books&ie=UTF8&qid=1481301275&sr=1-7

https://www.amazon.com/Professional-Microsoft-Server-2014-Administration/dp/1118859138/ref=sr_1_9?s=books&ie=UTF8&qid=1481301275&sr=1-9

https://ola.hallengren.com/

http://www.sqlskills.com/blogs/paul/category/corruption/

This website is really helpful for upping your SQL skills because it gives you instant feed back and provides problems that aren't overly easy to google.

This book is excellent and written by a God that is known to mortals as Itzik Ben-Gan.

This online SQL code formatter is my personal favorite

When you hit the wall this is also helpful

Hope that helps and remember in Codd we trust!

I really enjoyed the CBT Nuggets videos. I happened upon them for free, but they offer $99 a month subscriptions which isn't so bad if you have your own lab to work with.

http://www.cbtnuggets.com/it-training-videos/microsoft

Just search for SQL Server 2012

---
Microsoft SQL Server 2012 T-SQL Fundamentals is awesome too, and possible more helpful that the above info. http://www.amazon.com/Microsoft-Server-2012-T-SQL-Fundamentals/dp/0735658145

You might be able to find the above book in PDF form if you look hard enough...

This http://www.amazon.com/Microsoft-Server-2012-T-SQL-Fundamentals/dp/0735658145 excellent with great examples

The best book would be Itzik Ben-Gan's T-SQL Fundamentals: http://www.amazon.com/gp/aw/d/0735658145/ref=mp_s_a_1_2?qid=1375556912&sr=1-2&pi=SL160_PIsitb-sticker-arrow-dp,TopRight,12,-18_SH30_OU01_AA160

You can also check out our free SQL tutorials on MidnightDBA.com I have a number of introductory videos on T-SQL (under the Dev) section.

We cover it in depth at our bootcamp. :)

However if you're looking for a great book on T-SQL try this one

For SSIS there is a really nice step by step tutorial on SQL Server Central

The Itzik Ben Gan books on Querying T-SQL are invaluable imo. T-SQL fundamentals covers most things you will need to know:

http://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145/ref=asap_bc?ie=UTF8

For the language aspect of SQL this book is great:

http://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145/ref=sr_1_1?s=books&ie=UTF8&qid=1452317305&sr=1-1&keywords=tsql+fundamentals

I'm a fan of SQLZOO.com as well

You absolutely MUST read these books:


1 - Microsoft SQL Server 2012 T-SQL Fundamentals


2 - Inside Microsoft SQL Server 2008 T-SQL Querying

Happy learnig!

If you want to stay in the SQL Server world (T-SQL/SSIS/SSRS/SSAS), I highly recommend reading T-SQL Fundamentals and The Data Warehouse Toolkit (and other Ralph Kimball books) over and over again. These were invaluable to me in my SQL days, as many SQL interviews tend to be less reliant on puzzle games and more reliant upon pure knowledge of the engine you're dealing with. Knowing the SQL Server engine really well will help you with DBA knowledge, also (which tends to focus on optimization and disaster recovery aspects).

Other than that, what do you want to do, specifically? All interviews are going to be different for different jobs.

Try this book: http://www.amazon.com/Microsoft-Server-2012-T-SQL-Fundamentals/dp/0735658145. It will be useful to you working with SQL Server

Microsoft SQL Server 2012 T-SQL Fundamentals

https://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145

Look at MS exams: This would in addition to Application development platforms.

https://www.microsoft.com/en-us/learning/exam-70-761.aspx

https://www.microsoft.com/en-us/learning/exam-70-762.aspx

Feel free to ping if you have more questions