Skip to main content
Back to top
Ctrl
+
K
Search
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
4.2. Entity Relationship(ER) Diagrams
Data Preparation
5. Data Preparation
5.1. Structural
5.2. Numerical, Granularity
5.3. Outliers
5.4. Imputation and Entity Resolution
Semistructured Data
6. Semistructured Data
6.1. Semistructured Data
6.2. MongoDB
Appendix
SQL Style Guide
MongoDB Style Guide
Repository
Open issue
.md
.pdf
Data Modeling
4.
Data Modeling
#
4.1. Data Models
4.2. Entity Relationship(ER) Diagrams
