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
• 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
• Clustered index
• Clustered, Unique, and Sorted Indexes
• Creating an Index
• Dropping an Index, or Disabling and Rebuilding it
• Inserting with a Unique Index
• Non clustered index
• Partial or Filtered Index
• Rebuild index
• SAP ASE: Drop index
• Sorted Index
• Unique Index that Allows NULLS
• 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