{Awesome Works in Progress}
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. [TechTarget]
- Introducing Microsoft SQL Server 2019 - Packt
- Database Design – 2nd Edition - Adrienne Watt
- SQL Server Management Studio
- Course: SSMS Shortcuts and Secrets - Kendra Little
- Azure Data Studio
- Visual Studio Code - Free. Built on open source. Runs everywhere.
- Understanding Memory with SQL Server and Azure SQL (Bob Ward, June 2020)
- Security Considerations for a SQL Server Installation
- Introduction to SQL Server Security ⭐
- Transparent Data Encryption (TDE)
- SQL Backup and Restore - sqlbackuprestore.com
- Understanding SQL Server Backup Types (Prashanth Jayaram, April 2018)
- SQL Server Auditing Best Practices (sqlshack.com, May 2019) - Goal, Scope, Tools, Audit Data, Audit Role, Audit for Audit, Archiving and more.
- 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
- 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
- Database documentation tools - DBMSTools.com
- Intro to SQL - DataCamp
- SQL all kinds of join queries
- Subqueries (Derived Table)
- Learn SQL Cookbook - learnsql.com
- Date and Time
- String
- Aggregate
- Analytic Functions
- SQL Server Queries - WiseOwlTutorials
- Querying with Transact-SQL (Channel 9)
- Like (Advanced) ~11min - Database by Doug
- Intro to Structured Query Language - Database by Doug
- Learn T-SQL Querying (Free) - Packt
- Get Started Querying with Transact-SQL (Path) - Microsoft Learn
- Introduction to Transact-SQL
- Sort and filter results in T-SQL
- Combine multiple tables with JOINs in T-SQL
- Write Subqueries in T-SQL
- Use built-in functions and GROUP BY in Transact-SQL
- Modify data with T-SQL
- Educational SQL resources - Tutorials, quickstarts, and other educational resources meant to teach you to work with SQL Server and Azure SQL Database.
- SQL - sololearn.com
- T-SQL for Beginners - red-gate.com
- SQL Quiz - w3schools.com
- SQL Server - Procedures and Programming - WiseOwlTutorials