Full-Text Search y Búsqueda Avanzada

Domina tsvector/tsquery, GIN, pg_trgm, fuzzystrmatch, unaccent, ranking TF-IDF y búsqueda híbrida con PostgreSQL. 12 módulos interactivos.

0
Insignias
0/12
Módulos
0%
Completado
document.getElementById('revealBtn')?.addEventListener('click',function(){ let e=document.getElementById('explainerContainer'); if(e){ e.style.display=e.style.display==='none'?'block':'none'; this.innerHTML=e.style.display==='block'?' Ocultar explicación':' Mostrar explicación de cada opción'; } }); document.querySelectorAll('#quizContainer .quiz-option')?.forEach(b=>{ b.addEventListener('click',function(){ let ans=this.dataset.ans; let fb=document.getElementById('feedback'); // Mark correct/wrong let correctIdx=0; // default first document.querySelectorAll('#quizContainer .quiz-option').forEach((o,i)=>{ if(o.dataset.correct==='true') correctIdx=i; }); if(ans==correctIdx.toString()){ this.className='quiz-option correct'; fb.innerHTML=I18N.t('quiz_correct'); let bd=JSON.parse(localStorage.getItem(BADGES))||[]; if(!bd.includes('i-class-fas-fa-search-i-full-t')){bd.push('i-class-fas-fa-search-i-full-t');localStorage.setItem(BADGES,JSON.stringify(bd))} document.getElementById('insignia')?.classList.remove('hidden'); updateProg(); }else{ this.className='quiz-option wrong'; fb.innerHTML=I18N.t('quiz_wrong'); setTimeout(()=>this.className='quiz-option',600); } document.querySelectorAll('#quizContainer .quiz-option').forEach(o=>o.style.pointerEvents='none'); setTimeout(()=>document.querySelectorAll('#quizContainer .quiz-option').forEach(o=>o.style.pointerEvents=''),2000); }); }); document.getElementById('revealBtn')?.addEventListener('click',function(){ let e=document.getElementById('explainerContainer'); if(e){ e.style.display=e.style.display==='none'?'block':'none'; this.innerHTML=e.style.display==='block'?' Ocultar explicación':' Mostrar explicación de cada opción'; } }); document.querySelectorAll('#quizContainer .quiz-option')?.forEach(b=>{ b.addEventListener('click',function(){ let ans=this.dataset.ans; let fb=document.getElementById('feedback'); // Mark correct/wrong let correctIdx=0; // default first document.querySelectorAll('#quizContainer .quiz-option').forEach((o,i)=>{ if(o.dataset.correct==='true') correctIdx=i; }); if(ans==correctIdx.toString()){ this.className='quiz-option correct'; fb.innerHTML=I18N.t('quiz_correct'); let bd=JSON.parse(localStorage.getItem(BADGES))||[]; if(!bd.includes('i-class-fas-fa-search-i-full-t')){bd.push('i-class-fas-fa-search-i-full-t');localStorage.setItem(BADGES,JSON.stringify(bd))} document.getElementById('insignia')?.classList.remove('hidden'); updateProg(); }else{ this.className='quiz-option wrong'; fb.innerHTML=I18N.t('quiz_wrong'); setTimeout(()=>this.className='quiz-option',600); } document.querySelectorAll('#quizContainer .quiz-option').forEach(o=>o.style.pointerEvents='none'); setTimeout(()=>document.querySelectorAll('#quizContainer .quiz-option').forEach(o=>o.style.pointerEvents=''),2000); }); }); document.getElementById('revealBtn')?.addEventListener('click',function(){ let e=document.getElementById('explainerContainer'); if(e){ e.style.display=e.style.display==='none'?'block':'none'; this.innerHTML=e.style.display==='block'?' Ocultar explicación':' Mostrar explicación de cada opción'; } }); document.querySelectorAll('#quizContainer .quiz-option')?.forEach(b=>{ b.addEventListener('click',function(){ let ans=this.dataset.ans; let fb=document.getElementById('feedback'); // Mark correct/wrong let correctIdx=0; // default first document.querySelectorAll('#quizContainer .quiz-option').forEach((o,i)=>{ if(o.dataset.correct==='true') correctIdx=i; }); if(ans==correctIdx.toString()){ this.className='quiz-option correct'; fb.innerHTML=I18N.t('quiz_correct'); let bd=JSON.parse(localStorage.getItem(BADGES))||[]; if(!bd.includes('i-class-fas-fa-search-i-full-t')){bd.push('i-class-fas-fa-search-i-full-t');localStorage.setItem(BADGES,JSON.stringify(bd))} document.getElementById('insignia')?.classList.remove('hidden'); updateProg(); }else{ this.className='quiz-option wrong'; fb.innerHTML=I18N.t('quiz_wrong'); setTimeout(()=>this.className='quiz-option',600); } document.querySelectorAll('#quizContainer .quiz-option').forEach(o=>o.style.pointerEvents='none'); setTimeout(()=>document.querySelectorAll('#quizContainer .quiz-option').forEach(o=>o.style.pointerEvents=''),2000); }); });  SQL Avanzado | Curso 3 - Full-Text Search

Full-Text Search y Búsqueda Avanzada

Domina tsvector/tsquery, GIN, pg_trgm, fuzzystrmatch, unaccent, ranking TF-IDF y búsqueda híbrida con PostgreSQL. 12 módulos interactivos.

0
Insignias
0/12
Módulos
0%
Completado
document.getElementById('revealBtn')?.addEventListener('click',function(){ let e=document.getElementById('explainerContainer'); if(e){ e.style.display=e.style.display==='none'?'block':'none'; this.innerHTML=e.style.display==='block'?' Ocultar explicación':' Mostrar explicación de cada opción'; } }); document.querySelectorAll('#quizContainer .quiz-option')?.forEach(b=>{ b.addEventListener('click',function(){ let ans=this.dataset.ans; let fb=document.getElementById('feedback'); // Mark correct/wrong let correctIdx=0; // default first document.querySelectorAll('#quizContainer .quiz-option').forEach((o,i)=>{ if(o.dataset.correct==='true') correctIdx=i; }); if(ans==correctIdx.toString()){ this.className='quiz-option correct'; fb.innerHTML=I18N.t('quiz_correct'); let bd=JSON.parse(localStorage.getItem(BADGES))||[]; if(!bd.includes('i-class-fas-fa-search-i-full-t')){bd.push('i-class-fas-fa-search-i-full-t');localStorage.setItem(BADGES,JSON.stringify(bd))} document.getElementById('insignia')?.classList.remove('hidden'); updateProg(); }else{ this.className='quiz-option wrong'; fb.innerHTML=I18N.t('quiz_wrong'); setTimeout(()=>this.className='quiz-option',600); } document.querySelectorAll('#quizContainer .quiz-option').forEach(o=>o.style.pointerEvents='none'); setTimeout(()=>document.querySelectorAll('#quizContainer .quiz-option').forEach(o=>o.style.pointerEvents=''),2000); }); }); document.getElementById('revealBtn')?.addEventListener('click',function(){ let e=document.getElementById('explainerContainer'); if(e){ e.style.display=e.style.display==='none'?'block':'none'; this.innerHTML=e.style.display==='block'?' Ocultar explicación':' Mostrar explicación de cada opción'; } }); document.querySelectorAll('#quizContainer .quiz-option')?.forEach(b=>{ b.addEventListener('click',function(){ let ans=this.dataset.ans; let fb=document.getElementById('feedback'); // Mark correct/wrong let correctIdx=0; // default first document.querySelectorAll('#quizContainer .quiz-option').forEach((o,i)=>{ if(o.dataset.correct==='true') correctIdx=i; }); if(ans==correctIdx.toString()){ this.className='quiz-option correct'; fb.innerHTML=I18N.t('quiz_correct'); let bd=JSON.parse(localStorage.getItem(BADGES))||[]; if(!bd.includes('i-class-fas-fa-search-i-full-t')){bd.push('i-class-fas-fa-search-i-full-t');localStorage.setItem(BADGES,JSON.stringify(bd))} document.getElementById('insignia')?.classList.remove('hidden'); updateProg(); }else{ this.className='quiz-option wrong'; fb.innerHTML=I18N.t('quiz_wrong'); setTimeout(()=>this.className='quiz-option',600); } document.querySelectorAll('#quizContainer .quiz-option').forEach(o=>o.style.pointerEvents='none'); setTimeout(()=>document.querySelectorAll('#quizContainer .quiz-option').forEach(o=>o.style.pointerEvents=''),2000); }); }); document.getElementById('revealBtn')?.addEventListener('click',function(){ let e=document.getElementById('explainerContainer'); if(e){ e.style.display=e.style.display==='none'?'block':'none'; this.innerHTML=e.style.display==='block'?' Ocultar explicación':' Mostrar explicación de cada opción'; } }); document.querySelectorAll('#quizContainer .quiz-option')?.forEach(b=>{ b.addEventListener('click',function(){ let ans=this.dataset.ans; let fb=document.getElementById('feedback'); // Mark correct/wrong let correctIdx=0; // default first document.querySelectorAll('#quizContainer .quiz-option').forEach((o,i)=>{ if(o.dataset.correct==='true') correctIdx=i; }); if(ans==correctIdx.toString()){ this.className='quiz-option correct'; fb.innerHTML=I18N.t('quiz_correct'); let bd=JSON.parse(localStorage.getItem(BADGES))||[]; if(!bd.includes('i-class-fas-fa-search-i-full-t')){bd.push('i-class-fas-fa-search-i-full-t');localStorage.setItem(BADGES,JSON.stringify(bd))} document.getElementById('insignia')?.classList.remove('hidden'); updateProg(); }else{ this.className='quiz-option wrong'; fb.innerHTML=I18N.t('quiz_wrong'); setTimeout(()=>this.className='quiz-option',600); } document.querySelectorAll('#quizContainer .quiz-option').forEach(o=>o.style.pointerEvents='none'); setTimeout(()=>document.querySelectorAll('#quizContainer .quiz-option').forEach(o=>o.style.pointerEvents=''),2000); }); });