sql.txt

** Maurach's SQL Server 2012 for Developers

- Queries: 
  (select, distinct, where)
  (AND, OR, NOT)
  (like, IsNull)
  (orderby)
  
- Joins:
  (inner, outer, cross, self)
  (union)
  (except, intersect)
  
- Aggregation:
  (groupby, having)
  (summary => rollup, cube, grouping set, over)
  
- SubQueries: 
  (In, All, Some, Exists)
  
- CTE (Common Table Expressions):
  (simple, reverse)
  
- DML (Data Manipulation):
  (select into)
  (insert, update, delete)
  (merge)
  
---------------------------------

- Data Types:
  (Numeric, String, Date/DateTime)
  (CAST, CONVERT)
  
- Functions:
  (String, Numeric, Date)
  (Other => CASE, IIF, Choose, COLEASE, IsNull, Grouping)
  
---------------------------------
  
- Database Design:
  (primary / foreign keys)
  (relations => one-to-one, one-to-many, many-to-many)
  (Indexes)
  (Normalization)
  
- DDL (Data Definition Language):
  (Database, Table, Index, Constraints, Sequences)
  (Scripts)
  
---------------------------------
  
- Advanced SQL:
  (Views)
  (Stored Procedures)
  (Scripts => variables, conditionals, dynamic sql, errors)
  (Triggers)
  (Cursors)
  
---------------------------------
  
- Transactions:
  (concurrency, locking, deadlocks)
  
---------------------------------
  
- Security:
  (logins, permissions, roles)
  
---------------------------------
  
- Working with:
  (XML, BloB, GeoSpatial, Json, ...)