DownloadsDownload 3 Query PerformanceData 101 Course Notes1 SQL1.1 SQL Review1.2 String Manipulation1.3 Truncating Relations1.4 Creating Tables and Views from Data1.5 Common Table Expressions (CTE)1.6 Subqueries1.7 Window Functions1.8 DML—Data Manipulation Language1.9 DDL–Data Definition Language1.10 Keys & Constraints2 Relational Algebra2.1 Relational Algebra Overview2.2 Extended RA Operators3 Query Performance3.1 Index Selection3.2 Query Planning3.3 Rules of Thumb3.4 PostgreSQL Schemas4 Data Modeling4.1 Data Models4.2 Entity Relationship(ER) Diagrams5 Data Preparation5.1 Structural5.2 Numerical, Granularity5.3 Outliers5.4 Imputation and Entity Resolution6 Semistructured Data6.1 Semistructured Data6.2 MongoDB7 SamplingDatabase Sampling8 Transactions8.1 Transactions9 Parallel/Distributed ComputingParallel and Distributed Computing10 Data Operations and PipelinesData Operations and Pipelines11 Business Intelligence (BI)Business Intelligence (BI)12 Graph DatabasesProperty GraphsTriplestores/RDFsOntologiesSpreadsheetsThe Spreadsheet Data ModelAppendix12.1 SQL Style Guide12.2 MongoDB Style Guide