Skip to content

Instantly share code, notes, and snippets.

Last active April 22, 2021 07:08
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
What would you like to do?
** Maurach's SQL Server 2012 for Developers
- Queries:
(select, distinct, where)
(like, IsNull)
- Joins:
(inner, outer, cross, self)
(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)
- Data Types:
(Numeric, String, Date/DateTime)
- 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)
- DDL (Data Definition Language):
(Database, Table, Index, Constraints, Sequences)
- Advanced SQL:
(Stored Procedures)
(Scripts => variables, conditionals, dynamic sql, errors)
- Transactions:
(concurrency, locking, deadlocks)
- Security:
(logins, permissions, roles)
- Working with:
(XML, BloB, GeoSpatial, Json, ...)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment