Lecture
DDL, DML, Views
Related lectures (66)
SQL: Data Manipulation and ViewsMOOC: Introduction to Geographic Information Systems (part 1)
Covers SQL data manipulation language, including DDL and DML commands.
Data Wrangling with Hadoop
Covers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
Relational Model: Basics
Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
Querying a database: the SQL languageMOOC: Geographical Information Systems 1
Covers the SQL language for interacting with databases through structured queries, including selecting, filtering, aggregating, and sorting data.
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.
Conditional queries: An Introduction to GISMOOC: Geographical Information Systems 1
Covers conditional queries and joins in GIS, explaining operators and attribute selection based on conditions.
Database Management Systems: Fundamentals
Introduces the fundamentals of database management systems, covering relational model, storage options, data integrity, queries, and data manipulation languages.
Data formats and data wrangling with Hadoop
Explores Apache Hive for data warehousing, data formats, and partitioning, with practical exercises in querying and connecting to Hive.
Data modeling: Geographic Information SystemsMOOC: Geographical Information Systems 1
Introduces data modeling in the context of Geographic Information Systems, covering the added value and methods used.
SQL Client-Server Architecture + IDE
Covers the architecture of a typical DBMS and SQL interfaces like SQL Developer and DataGrip.