Lecture
SQL Client-Server Architecture + IDE
Related lectures (74)
Relational Model: Basics
Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
Data Wrangling with Hadoop
Covers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
Efficient GPU Join Optimization
Covers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.
Convergence & Choice of Finite Element Discretizations
Explores convergence, numerical pathologies, and mesh convergence studies in finite element discretizations.
Efficient GPU Join Optimization
Discusses efficient GPU-accelerated join optimization for complex queries, aiming to improve optimization times and heuristic plan quality.
Symmetry & Boundary Conditions
Explores symmetry and boundary conditions in finite element models, emphasizing the importance of maintaining symmetry for accurate modeling.
Relational Databases: FundamentalsMOOC: Introduction to Geographic Information Systems (part 1)
Covers relational and spatial databases, including storage, management systems, ACID properties, historical typologies, primary and foreign keys, and spatial functions.
DDL, DML, ViewsMOOC: Geographical Information Systems 1
Covers SQL data definition, manipulation, and views in databases.
Spark Data Frames
Covers Spark Data Frames, distributed collections of data organized into named columns, and the benefits of using them over RDDs.
Relational Databases: Fundamentals and ACID PropertiesMOOC: Geographical Information Systems 1
Covers relational databases, transactions, and data consistency in the context of historical database typologies.