Awesome SQL Server

Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments.

The Awesome-SQLServer is a github repository by Naji El Kotob

Books

• Introducing Microsoft SQL Server 2019 – Packt
• Database Design – 2nd Edition – Adrienne Watt

Technical white papers

• Microsoft SQL Server 2019

YouTube

https://www.youtube.com/channel/UCrJ8WLrVoKxL94mKv2akxTA

Tools

---

Database Tools

• SQL Server Management Studio
  • Course: SSMS Shortcuts and Secrets – Kendra Little
• Azure Data Studio
  • The A to S of Azure Data Studio 
• Visual Studio Code – Free. Built on open source. Runs everywhere.

Installation

• SQL Server Developer

Administration

---

Articles and Videos

Architecture

• Understanding Memory with SQL Server and Azure SQL (Bob Ward, June 2020)

Tuning

Security

• Security Considerations for a SQL Server Installation
• Introduction to SQL Server Security
• Transparent Data Encryption (TDE)

Backup and Restore

• SQL Backup and Restore – sqlbackuprestore.com
• Understanding SQL Server Backup Types (Prashanth Jayaram, April 2018)

RPO/RTO

• RPO and RTO – definition and understanding the difference – acronis.com

Audit

• SQL Server Auditing Best Practices (sqlshack.com, May 2019) – Goal, Scope, Tools, Audit Data, Audit Role, Audit for Audit, Archiving and more.

Troubleshooting

• Connect to SQL Server when system administrators are locked out
• Service Packs (SP), Cumulative Updates (CU), patches and hotfixes
  • Microsoft SQL Server Versions List – This unofficial build chart lists all of the known Service Packs (SP), Cumulative Updates (CU), patches and hotfixes.
  • How do I find SQL Server version?
• SQL Server Configuration Manager Missing from Start Menu – sqlauthority.com

GitHub

• SQL Server and Azure SQL Labs and Workshops
• SQL Server 2019 (Labs)
• SQL Docs (GitHub)

Database Design

---

• 9 reasons why there are no foreign keys constraints in your database – Piotr Kononow
• What is Entity Relationship Diagram (ERD)
• Database Answers (Data Models) – databaseanswers.org

Documentation

• Database documentation tools – DBMSTools.com

Querying

---

• Intro to SQL – DataCamp
  • Venkatramani Rajgopal
• SQL all kinds of join queries
• Subqueries (Derived Table)
• Learn SQL Cookbook – learnsql.com
  • Window Functions vs. GROUP BY
  • SQL Window Functions Cheat Sheet
• Date and Time
  • ISO 8601
  • GETDATE, GETUTCDATE
  • YEAR, MONTH, DAY
  • DATEPART, DATENAME
  • DATEADD, DATEDIFF
  • ISDATE
• String
  • LEN, LEFT, RIGHT
  • UPPER, LOWER
  • CHARINDEX, PATINDEX
  • STRING_AGG, STRING_SPLIT
• Aggregate
  • Statistical aggregate functions
    • SUM, COUNT, MIN, and MAX
    • AVG,VAR, VARP, STDEV and STDEVP
• Analytic Functions
  • LAG, LEAD

YouTube 

---

• SQL Server Queries – WiseOwlTutorials
• Querying with Transact-SQL (Channel 9)
• Like (Advanced) ~11min – Database by Doug

Books

• Learn T-SQL Querying (Free) – Packt

Learning

---

Get Started Querying with Transact-SQL

• Get Started Querying with Transact-SQL (Path) – Microsoft Learn

1. Introduction to Transact-SQL
2. Sort and filter results in T-SQL
3. Combine multiple tables with JOINs in T-SQL
4. Write Subqueries in T-SQL
5. Use built-in functions and GROUP BY in Transact-SQL
6. Modify data with T-SQL

Microsoft Learning

• DP-080T00: Querying Data with Microsoft Transact-SQL
• Querying with Transact-SQL

Educational SQL resources

• Educational SQL resources – Tutorials, quickstarts, and other educational resources meant to teach you to work with SQL Server and Azure SQL Database.

SoloLearn

• SQL – sololearn.com

Quizzes

• SQL Quiz – w3schools.com

Development

---

Vidoes

• SQL Server – Procedures and Programming – WiseOwlTutorials

Microsoft Learning

• Get Started Querying with Transact-SQL
• Program with Transact-SQL
• Write advanced Transact-SQL queries
• Optimize query performance in SQL Server

Edx

• Developing SQL Databases (Microsoft DAT215.1x)

---