Monday, June 12, 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

Change Point Detection Time Series

  Change Point Detection Methods Kernel Change Point Detection: Kernel change point detection method detects changes in the distribution of ...

  • 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...
  • Basel Modeling and Validation
    General- Pillar 1- describes the guidelines for calculating the bank’s risk profile and capital requirements. ·          Interna...