| |
* Database
:
Create, Drop, Attach, Detach, Online, Offline, Snapshot, Trigger, Backup Database, etc...
|
* Table
:
Create, Alter, Drop, Temp Tables, etc...
|
* View
:
Create, Alter, Drop Views, etc...
|
* Stored Procedure
:
Create, Alter, Drop SP, etc...
|
* Data Filtering
:
Where, In, Not in, Wildcards %, _, [ ], [^ ]
|
* Data Grouping
:
Group By, Having, Compute
|
* Joins
:
Inner, Left, Right, Full Joins
|
* Trigger
:
Create After/Instead Of Trigger, Alter, Drop Trigger, etc...
|
* Cursor
:
Fetch Variable, Fetch (First, Next, Last, Prior), Absolute, Relative, Firehose, Monitoring Cursors
|
* Operators
:
Arithmetic, Comparison, Logical, Bitwise Operators
|
* Constraints
:
Not Null, Unique, Primary Key, Foreign Key, Check, Default Constraints
|
* Functions
:
String, Aggregate, Math, Date/Time, Configuration, System Functions
|
* Conditional Processing
:
If..Else, Simple Case, Searched Case, GOTO
|
* Looping
:
While, While..Break, While..Continue
|
* Error Handling
:
Try..Catch
|
* v.IMP Queries
:
Find n th Highest Salary, Count and Delete Duplicate Rows, Sort Rows in Specific Order, Generate CSV Values, Rotate Columns into Rows, etc...
|
* XML
:
Raw, Auto, Explicit, Path
|
* Query Performance
:
How to improve Query Performance with simple Tips
|
* Queries
:
Sub Queries, Recursive Queries
|
* Normalization
:
Process of organizing Data into Tables and establishing Relationships between them.
|
* Create
:
User, Rule, Role, Data Type, etc...
|