If you fall into that category who likes to read books especially books on SQL Server, you might find this page helpful. Below is the list of all the books I have read while I started my journey in the database world and still keep them for reference. Contents in the book can get obsolete over time as technologies keep changing. But it still helps you fill your bookshelf.
- T-SQL Fundamentals by Itzik Ben-Gan
- T-SQL Window Functions: For data analysis and beyond (Developer Reference) by Itzik Ben-Gan
- T-SQL Querying – Itzik Ben-Gan, Dejan Sarka, Adam Machanic, Kevin Fardee
- Learn T-SQL Querying: A guide to developing efficient and elegant T-SQL code by Pedro Lopes and Pam Lahoud
- Pro SQL Server 2019 Administration – Peter A. Carter
Microsoft exam preparation books are also very helpful and I find them pretty insightful. (not that I am recommending Microsoft certifications)
- Exam Ref 70-761 Querying Data with Transact -SQL – Itzik Ben-Gan
- Exam Ref 70-762 Developing SQL Databases – Louis Davidson, Stacia Varga
- Exam Ref 70-764 Administering a SQL Database Infrastructure – Victor Isakov
- Exam Ref 70-765 Provisioning SQL Databases – Joseph D’Antoni, Scott Klein
- Exam Ref 70-767 Implementing a SQL Data Warehouse – Jose Chinchilla, Raj Uchhana
- Exam Ref 70-768 Developing SQL Data Models – Stacia Varga
- Exam Ref 70-778 Analyzing and Visualizing Data with Microsoft Power BI – Daniil Maslyuk