# SQL

## Articles
- [SQL Query Optimization: How to Tune Performance of SQL Queries](https://blog.devart.com/how-to-optimize-sql-query.html)
- [SQL Server Execution Plans](https://blog.devart.com/sql-server-execution-plans.html)
- [Using the SQL Execution Plan for Query Performance Tuning](https://www.sqlshack.com/using-the-sql-execution-plan-for-query-performance-tuning/)
- [How to write subqueries in SQL](https://www.sqlshack.com/how-to-write-subqueries-in-sql/)
- [SQL Server Common Table Expressions (CTE)](https://www.sqlshack.com/sql-server-common-table-expressions-cte/)
- [SQL Server indexes – series intro](https://www.sqlshack.com/sql-server-indexes-series-intro/)
- [SQL index overview and strategy](https://www.sqlshack.com/sql-index-overview-and-strategy/)
- [SQL Server table structure overview](https://www.sqlshack.com/sql-server-table-structure-overview/)
- [SQL Server index design basics and guidelines](https://www.sqlshack.com/sql-server-index-design-basics-and-guidelines/)
- [SQL Server index operations](https://www.sqlshack.com/sql-server-index-operations/)
- [Designing effective SQL Server clustered indexes](https://www.sqlshack.com/designing-effective-sql-server-clustered-indexes/)
- [Designing effective SQL Server non-clustered indexes](https://www.sqlshack.com/designing-effective-sql-server-non-clustered-indexes/)
- [Working with different SQL Server indexes types](https://www.sqlshack.com/working-with-different-sql-server-indexes-types/)
- [Tracing and tuning queries using SQL Server indexes](https://www.sqlshack.com/tracing-and-tuning-queries-using-sql-server-indexes/)
- [Gathering SQL Server indexes statistics and usage information](https://www.sqlshack.com/gathering-sql-server-indexes-statistics-and-usage-information/)
- [Maintaining SQL Server indexes](https://www.sqlshack.com/maintaining-sql-server-indexes/)
- [SQL WHILE loop with simple examples](https://www.sqlshack.com/sql-while-loop-with-simple-examples/)
- [Overview of SQL RANK functions](https://www.sqlshack.com/overview-of-sql-rank-functions/)
- [SELECT INTO TEMP TABLE statement in SQL Server](https://www.sqlshack.com/select-into-temp-table-statement-in-sql-server/)
- [SQL PARTITION BY Clause overview](https://www.sqlshack.com/sql-partition-by-clause-overview/)
- [SQL Server table hints – WITH (NOLOCK) best practices](https://www.sqlshack.com/understanding-impact-clr-strict-security-configuration-setting-sql-server-2017/)
- [CASE statement in SQL](https://www.sqlshack.com/case-statement-in-sql/)
- [SQL Variables: Basics and usage](https://www.sqlshack.com/sql-variables-basics-and-usage/)
- [SQL Convert Date functions and formats](https://www.sqlshack.com/sql-convert-date-functions-and-formats/)
- [Query optimization techniques in SQL Server: tips and tricks](https://www.sqlshack.com/query-optimization-techniques-in-sql-server-tips-and-tricks/)
- [How to identify slow running queries in SQL Server](https://www.sqlshack.com/how-to-identify-slow-running-queries-in-sql-server/)
- [All about locking in SQL Server](https://www.sqlshack.com/locking-sql-server/)
- [SQL Server stored procedures for beginners](https://www.sqlshack.com/sql-server-stored-procedures-for-beginners/)
- [What is the difference between Clustered and Non-Clustered Indexes in SQL Server?](https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/)
- [Difference between Clustered and Non-clustered index](https://www.geeksforgeeks.org/difference-between-clustered-and-non-clustered-index/)
- [An overview of the SQL GROUP BY clause](https://www.sqlshack.com/an-overview-of-the-sql-group-by-clause/)
- [Learn SQL: Aggregate Functions](https://www.sqlshack.com/learn-sql-aggregate-functions/)
- [Learn SQL: INNER JOIN vs LEFT JOIN](https://www.sqlshack.com/learn-sql-inner-join-vs-left-join/)
- [A step-by-step walkthrough of SQL Inner Join](https://www.sqlshack.com/a-step-by-step-walkthrough-of-sql-inner-join/)
- [Learn SQL: SQL Server Cursors](https://www.sqlshack.com/learn-sql-sql-server-cursors/)
- [SQL OUTER JOIN overview and examples](https://www.sqlshack.com/sql-outer-join-overview-and-examples/)
- [Learn SQL: Types of relations](https://www.sqlshack.com/learn-sql-types-of-relations/)
- [Learn SQL: Join multiple tables](https://www.sqlshack.com/learn-sql-join-multiple-tables/)
- [Learn SQL: How to Write a Complex SELECT Query](https://www.sqlshack.com/learn-sql-how-to-write-a-complex-select-query/)
- [The difference between WHERE and HAVING clause in SQL](https://www.sqlshack.com/learn-sql-sql-data-types/)
- [Learn SQL: SQL Data Types](https://www.sqlshack.com/learn-sql-sql-data-types/)
- [Learn SQL: User-Defined Functions](https://www.sqlshack.com/learn-sql-user-defined-functions/)
- [Learn SQL: User-Defined Stored Procedures](https://www.sqlshack.com/learn-sql-user-defined-stored-procedures/)
- [Learn SQL: SQL Views](https://www.sqlshack.com/learn-sql-sql-views/)
- [Learn SQL: Non-Equi Joins in SQL Server](https://www.sqlshack.com/learn-sql-non-equi-joins-in-sql-server/)
- [SQL Server CTE](https://www.sqlservertutorial.net/sql-server-basics/sql-server-cte/)
- [SQL Server GROUP BY](https://www.sqlservertutorial.net/sql-server-basics/sql-server-group-by/)
- [SQL Server Aggregate Functions](https://www.sqlservertutorial.net/sql-server-aggregate-functions/)
- [SQL Server Joins](https://www.sqlservertutorial.net/sql-server-basics/sql-server-joins/)
- [SQL Server Left Join](https://www.sqlservertutorial.net/sql-server-basics/sql-server-left-join/)
- [SQL Server Subquery](https://www.sqlservertutorial.net/sql-server-basics/sql-server-subquery/)
- [SQL Server HAVING](https://www.sqlservertutorial.net/sql-server-basics/sql-server-having/)
- [SQL Server RANK Function](https://www.sqlservertutorial.net/sql-server-window-functions/sql-server-rank-function/)
- [SQL Server ROW_NUMBER Function](https://www.sqlservertutorial.net/sql-server-window-functions/sql-server-row_number-function/)
- [A Basic Guide to SQL Server Stored Procedures](https://www.sqlservertutorial.net/sql-server-stored-procedures/basic-sql-server-stored-procedures/)
- [SQL Server Clustered Indexes](https://www.sqlservertutorial.net/sql-server-indexes/sql-server-clustered-indexes/)
- [SQL Server CREATE INDEX](https://www.sqlservertutorial.net/sql-server-indexes/sql-server-create-index/)
- [SQL Server Index Fragmentation Overview](https://www.mssqltips.com/sqlservertip/4331/sql-server-index-fragmentation-overview/)