SQL

Related lectures (32)

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

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

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

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

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

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

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

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

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

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

Introduces the fundamentals of handling data, emphasizing the importance of Pandas and data modeling for effective analysis.

Introduces the relational model and relational algebra, focusing on SQL and its operations for effective database management.

Covers Spark Data Frames, their performance benefits, Catalyst Optimizer, PySpark integration, and Gutenberg corpus analysis.

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

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

Covers OLAP queries, examples of comparisons, ranking, and optimizations for query performance.

Covers the functioning of conditional queries based on the WHERE clause.

Covers the basic principles of the SQL language and selection requests.

Explores views in SQL, covering creation, materialization, maintenance, cube building, and top-k queries optimizations.

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

Page 1 of 2