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
• Information Schema
• INSERT
• JOIN
• LIKE operator
• Materialized Views
• MERGE
• NULL
• ORDER BY
• Order of Execution
• Primary Keys
• Relational Algebra
• Row number
• SELECT
• Using the wildcard character to select all columns in a query.
• Get aggregated result for row groups
• Select columns which are named after reserved keywords
• Select distinct (unique values only)
• Select Individual Columns
• Select rows from multiple tables
• SELECT Using Column Aliases
• Select with condition of multiple values from column
• Selecting specified number of records
• Selecting with Aggregate functions
• Selecting with CASE
• Selecting with Condition
• Selecting with more than 1 condition.
• Selecting with null
• Selecting with table alias
• Selecting without Locking the table
• Selection with sorted Results
• 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