Accés lliure

Materias:

Materias: “…Bíblia. Nou Testament Extractes…”

Materias: “…Bíblia. Nou Testament Extractes…”

Accés restringit als usuaris d'ESADE

Concectar con la versión electrónica

Tabla de Contenidos: “…Starting with Arrays -- Exercise 7.03: Analyzing Sequences Using Arrays -- Using JSON Data types in PostgreSQL -- JSONB: Pre-Parsed JSON -- Accessing Data from a JSON or JSONB Field -- Leveraging the JSON Path Language for JSONB Fields -- Creating and Modifying Data in a JSONB Field -- Exercise 7.04: Searching through JSONB -- Text Analytics Using PostgreSQL -- Tokenizing Text -- Exercise 7.05: Performing Text Analytics -- Performing Text Search -- Optimizing Text Search on PostgreSQL -- Activity 7.01: Sales Search and Analysis -- Summary -- Chapter 8: Performant SQL -- Introduction -- The Importance of Highly Efficient SQL -- Database Scanning Methods -- Query Planning -- Exercise 8.01: Interpreting the Query Planner -- Activity 8.01: Query Planning -- Index Scanning -- The B-Tree Index -- Exercise 8.02: Creating an Index Scan -- Activity 8.02: Implementing Index Scans -- The Hash Index -- Exercise 8.03: Generating Several Hash Indexes to Investigate Performance -- Activity 8.03: Implementing Hash Indexes -- Effective Index Use -- Killing Queries -- Exercise 8.04: Canceling a Long-Running Query -- Functions and Triggers -- Function Definitions -- Exercise 8.05: Creating Functions without Arguments -- Activity 8.04: Defining a Largest Sale Value Function -- Exercise 8.06: Creating Functions with Arguments -- The \df and \sf commands -- Activity 8.05: Creating Functions with Arguments -- Triggers -- Exercise 8.07: Creating Triggers to Update Fields -- Activity 8.06: Creating a Trigger to Track Average Purchases -- Summary -- Chapter 9: Using SQL to Uncover the Truth - a Case Study -- Introduction -- Case Study -- The Scientific Method -- Exercise 9.01: Preliminary Data Collection Using SQL Techniques -- Exercise 9.02: Extracting the Sales Information -- Activity 9.01: Quantifying the Sales Drop -- Exercise 9.03: Launch Timing Analysis…”