SQL

• Getting started with SQL
• SQL Database Recovery
• ALTER TABLE
• AND & OR Operators
• Cascading Delete
• CASE
• Clean Code in SQL
• Comments
• Common Table Expressions
• CREATE Database
• CREATE FUNCTION
• CREATE TABLE
• cross apply, outer apply
• Data Types
• DELETE
• DROP or DELETE Database
• DROP Table
• Check for existence before dropping
• Simple drop
• Example Databases and Tables
• EXCEPT
• Execution blocks
• EXISTS CLAUSE
• EXPLAIN and DESCRIBE
• Filter results using WHERE and HAVING
• Finding Duplicates on a Column Subset with Detail
• Foreign Keys
• Functions (Aggregate)
• Functions (Analytic)
• Functions (Scalar/Single Row)
• GRANT and REVOKE
• GROUP BY
• Identifier
• IN clause
• Indexes
• Information Schema
• INSERT
• JOIN
• LIKE operator
• Materialized Views
• MERGE
• NULL
• ORDER BY
• Order of Execution
• Primary Keys
• Relational Algebra
• Row number
• SELECT
• Sequence
• SKIP TAKE (Pagination)
• SQL CURSOR
• SQL Group By vs Distinct
• SQL Injection
• Stored Procedures
• String Functions
• Subqueries
• Synonyms
• Table Design
• Transactions
• Triggers
• TRUNCATE
• TRY/CATCH
• UNION / UNION ALL
• UPDATE
• Views
• Window Functions
• XML