Databases

An introduction to databases. Logistics Intro Data Models Database Design Phases Bad Design ER Model Drawing ER Diagrams SQL (Structed Query Language) SQL Schema SQL Query Anatomy SELECT and FROM WHERE AS keyword String Operations LIKE ORDER BY Set Operations UNION INTERSECT EXPECT Null Values Aggregation GROUP BY HAVING Nested Subqueries Subquery tests for WHERE Subquery test for FROM DELETE, INSERT, UPDATE DELETE INSERT UPDATE JOINS Natural/Inner Joins Outer Joins Views Integrity Constraints Authorization Privileges Roles Object-relational Databases Complex Types User Defined Types Inheritance Textual Data Big Data Streaming Data Physical Storage Types Interfaces Magnetic Disks Flash RAID RAID Levels Indexing Ordered Indices B+ Tree Hash Indices Transactions Scheduling Query Processing Parsing Optimization Evaluation Relational Algebra Building Execution graph Query Cost Relational Algebra Implementations Selection Sorting Joins Duplicate elimination Projection Set Operations Implementation Outer Join Aggregations Evaluating Expressions Pipelining Logistics Course link ...