Tutorials
In-depth AI tutorials — from fundamentals to production: RAG, agents, deployment, fine-tuning and more.
246
Total tutorials
44
Beginner
20
Hands-on
Browse by topic
Query World Cup Data in Plain Language: Text-to-SQL Hands-On (2026)
World Cup data is too vast to query by hand. This guide uses Text-to-SQL to automatically translate natural-language questions into SQL queries, building a match-data assistant you can ask in plain language — focusing on schema design, preventing wrong queries, and SQL-injection safety, the things production must solve.
Dify Enterprise Private Knowledge Base Complete Setup Guide: RAG Configuration & Best Practices (2026)
A detailed walkthrough of building an enterprise private knowledge base with Dify: Docker private deployment, document preprocessing strategies, chunk parameter tuning, embedding model selection, hybrid search configuration, and practical tips to fix common issues like 'irrelevant answers' or 'missing key information'.
Building Enterprise-Grade RAG 2.0 Systems: A Complete Practice from Document Parsing to Knowledge Retrieval
This article systematically introduces the construction and optimization methods of enterprise-grade RAG 2.0 systems, covering key technologies such as document parsing, query rewriting, hybrid retrieval, ranking fusion, ontology constraints, and cache optimization. Combined with real-world scenarios in manufacturing and finance, it explains in detail how to address core challenges like parsing complex document structures, multi-turn dialogue anaphora resolution, and balancing retrieval precision and recall. It also introduces ontology-driven semantic constraints and caching mechanisms to improve accuracy and response efficiency in professional domains. Suitable for developers with basic RAG knowledge who want to build production-level systems.
GitHub Copilot Advanced Tips 2026: 8 Powerful Features 90% of People Don't Use
8 advanced GitHub Copilot tips for 2026: inline Chat slash commands, repo-level copilot-instructions.md (highest leverage), #file/@workspace context variables, Edits multi-file editing, Agent mode acceptance criteria upfront, hidden completion operations, code review, and CLI.
Large Model Post-Training in Practice: From SFT to RL — The Complete Tech Stack
This article systematically explains the key techniques of large model post-training, including supervised fine-tuning (SFT), parameter-efficient fine-tuning (PEFT), reinforcement learning from human feedback (RLHF), and on-policy distillation (OPD). It focuses on the principles, pros and cons, and applicable scenarios of each method, and introduces a stability-plasticity trade-off framework to quantify the general capability loss caused by fine-tuning. By comparing the forgetting characteristics of full fine-tuning, LoRA, OFT, and other PEFT methods, it reveals that the destruction of activation space geometric structure is the key mechanism of forgetting. Finally, it summarizes the advantages of OPD as a new paradigm and provides practical guidelines and FAQs.
LlamaIndex Practical Guide: RAG Application Development from Beginner to Production
LlamaIndex is purpose-built for RAG applications, making it the go-to framework for building enterprise knowledge base Q&A systems. This article covers the core architecture, key differences from LangChain, and 5 complete code examples from document loading to production deployment.
LlamaIndex vs LangChain: Which One to Use for Building RAG (2026 Hands-On Comparison)
Everyone says LlamaIndex focuses on retrieval and LangChain leans toward orchestration, but when it comes to actual projects, you still get stuck. This article breaks it down by 'what you want to do,' with real code and pitfalls, helping you make a decision in 10 minutes.
LLM API Cost Control in Practice: 12 Ways to Cut Your AI Bill from $500 to $80
A practical llm cost optimization guide: 12 actionable methods—model routing, prompt compression, semantic caching, Batch API, context trimming, attribution.
LLM Fallback Strategy: When Models Go Down, Can Your App Survive?
Production LLM fallback: retries with backoff and jitter, circuit breakers, multi-provider fallback routing, timeout budgets, cache safety nets, and pitfalls.
Tongyi Qianwen API Developer Guide 2026: The Most Cost-Effective Domestic LLM Integration Solution
Alibaba Cloud's Tongyi Qianwen (Qwen) series leads domestic models in cost-effectiveness and multilingual capabilities, with Qwen2.5 widely adopted by global developers. This article covers everything from obtaining an API key to building production-grade applications, detailing best practices for Qwen API development.
Stable Diffusion 3.5 Local Deployment Complete Guide: Generate Unlimited Images for Free
SD 3.5 local deployment guide (2026): hardware table (Medium 8GB VRAM works), ComfyUI installation, model and text encoder placement (missing t5 is the #1 error), parameter tips (CFG 4-6), advanced roadmap for LoRA/ControlNet/batch API, and common error quick reference.
Voice Activity Detection (VAD): Detecting Whether Someone Is Speaking with Python
Voice activity detection in Python with webrtcvad and Silero VAD: frame constraints, energy vs. neural VAD, Whisper integration, streaming, tuning tips.