Skip to main content
Back to top
Ctrl
+
K
Overview
SQL
1. SQL
1.1. SQL Review
1.2. String Manipulation
1.3. Truncating Relations
1.4. Creating Tables and Views from Data
1.5. Common Table Expressions (CTE)
1.6. Subqueries
1.7. DML—Data Manipulation Langauge
1.8. DDL–Data Definition Language
1.9. Keys & Constraints
Relational Algebra
2. Relational Algebra
2.1. Relational Algebra Overview
2.2. Extended RA Operators
Query Performance
3. Query Performance
3.1. Index Selection
3.2. Query Planning
3.3. Rules of Thumb
Data Modeling
4. Data Modeling
4.1. Data Models
Data Preparation
5. Data Preparation
5.1. Structural
5.2. Numerical, Granularity
5.3. Outliers
5.4. Imputation and Entity Resolution
Appendix
SQL Style Guide
Repository
Open issue
.md
.pdf
Data Modeling
4.
Data Modeling
#
4.1. Data Models
