SQL

Related lectures (32)

Page 2 of 4

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.