Concept

Microsoft SQL Server

Related lectures (32)

Covers query fusion, nested queries, and SQL operators in a geographical context.

Covers aggregation logic, sorting results, and writing SQL queries based on specific attributes.

Covers the basics of SQL, including components of the language and syntax of SELECT clause.

Covers SQL data definition, manipulation, and views in databases.

Covers the architecture of a typical DBMS and SQL interfaces like SQL Developer and DataGrip.

Covers merging and embedded queries in SQL for Geographic Information Systems.

Covers the SQL language for interacting with databases through structured queries, including selecting, filtering, aggregating, and sorting data.

Covers SQL data manipulation language, including DDL and DML commands.

Covers aggregation queries and sorting of results in Geographic Information Systems.

Covers data wrangling techniques using Apache Hive for efficient big data management.

Explores adaptive sharing in analytical databases to reduce costs and improve efficiency through novel execution paradigms.

Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.

Explores the architecture of CockroachDB, focusing on transaction management, concurrency control, and scalability.

Covers the syntax and usage of conditional queries, including joins and filtering data.

Explores challenges in scaling up window aggregation in JIT-compiled engines and presents a new system for streaming aggregation.

Covers the creation, modification, and deletion of tables, data manipulation, and views.

Covers the basic principles of the SQL language and select queries.

Explores the data ingestion process in SmartDataLake, including datasets and the RAW platform.

Covers interactions between vector layers in GIS using QGIS tools.

Explores how views simplify query writing and are key in data warehouses.