Tuesday, June 13, 2017

SQL Basic Queries and Quick References Tutorial



1- Creating Table
2-  Basic Queries
3- Key Words
4- Scalar Value Functions
5- String
6- Constraints
7- Joins
8- Sub-Queries
9- Analytical Functions
10- Table and Table Variables
11- Transaction Control
12- Stored Procedures
13- User Defined Functions
14- Triggers
15- Performance Tunning.

https://drive.google.com/file/d/0Bx3mfFH5R-y3WG9fdnZvR2J2cmM/view?usp=sharing
-
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

R3 chase - Pursuit

Huber M-estimation (CCF for EAD):

  Huber M-estimation is a robust regression technique used to address the influence of outliers on model parameters. It is used to calculate...

  • PCA: Eigenvalues & Eigen Vectors
      Excel (Macro enable workbook) and VBA code: https://drive.google.com/drive/folders/18tIKLLg8MfJ2MYDjLPAWHspEbApVIpGz?usp=sharing PCA: Eige...
  • Low Default Portfolio (PD)
      Modeling Low Default Portfolio (Independent Default Events): Pluto and Tasche method for calculating probability of default for portfolios...
  • Modeling Low Default Portfolio Dependent Case:
      Modeling Low Default Portfolio Dependent Case: VASCIEK MODEL: Dependence between the default is explained by by Vasicek model. By using co...