Indexes

Sort options

Oracle SQL Performance Tuning (Coursera)

Mar 25th 2024
Oracle SQL Performance Tuning (Coursera)
Course Auditing
Categories
Effort
Languages
This course is designed to provide you with skills needed to improve query performance in Oracle databases. In real-world scenarios, slow report generation and query execution often result from the sheer volume of data. To address this issue, this course covers topics such as Query Compilation and Execution, [...]

Database Architecture, Scale, and NoSQL with Elasticsearch (Coursera)

Mar 25th 2024
Database Architecture, Scale, and NoSQL with Elasticsearch (Coursera)
Course Auditing
Categories
Effort
Languages
In this final course, you will explore database architecture, PostgreSQL, and various scalable deployment configurations. You will see how PostgreSQL implements basic CRUD operations and indexes, and review how transactions and the ACID (Atomicity, Consistency, Isolation, Durability) requirements are implemented. [...]

JSON and Natural Language Processing in PostgreSQL (Coursera)

Within this course, you’ll learn about how PostgreSQL creates and uses inverted indexes for JSON and natural language content. We will use various sources of data for our databases, including access to an online API and spidering its data and storing the data in a JSON column in PostgreSQL. [...]

Global Statistics - Composite Indices for International Comparisons (Coursera)

In this course on global statistics, offered by the University of Geneva jointly with the ETH Zürich KOF, you will learn the general approach of constructing composite indices and some of resulting problems. We will discuss the technical properties, the internal structure (like aggregation, weighting, stability of time series), [...]