Skip to content

Instantly share code, notes, and snippets.

@khattab88
Last active Apr 22, 2021
Embed
What would you like to do?
** 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, ...)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment