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
• AND and OR
• Equality
• The WHERE clause only returns rows that match its criteria
• Use BETWEEN to Filter Results
• Use HAVING to check for multiple conditions in a group
• Use HAVING with Aggregate Functions
• Use IN to return rows with a value contained in a list
• Use LIKE to find matching strings and substrings
• WHERE clause with NULL/NOT NULL values
• Where EXISTS
• 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