수백만 개의 에이전트 브랜치. 하나의 데이터베이스. 2026년 6월 4일, TiDB SCaiLE Europe에서 만나보세요.지금 등록하세요
로그인 무료로 시작하세요
무료로 시작하세요

Introduction

This course focuses on the essential SQL query skills and guides the audience to take performance into consideration while writing SQL from the first place. And, most of the content in this course is applicable with MySQL, learners can understand the compatibility of TiDB and MySQL by practices.

Free online learning is coming soon!

Private Training is available now. To purchase Private Training, contact sales to build out a custom training plan.

영업 담당자에게 문의하세요.

Summary

  • Audience: SQL developer beginners
  • Level: Introductory
  • Duration: 1 day
  • Prerequisites: You know how to connect to TiDB with the MySQL Client.
  • TiDB Version: v6.x

Course Outline

  • Use DESC
  • Retrieve records using a SELECT statement
  • Query data from a MySQL client
  • Get query execution plan
  • Optimize pagination by KeySet seeker
  • Describe data types
  • Describe numeric, date, string, and NULL
  • Describe boolean expression
  • Choose the right data type
  • Use String functions
  • Use Date and time functions
  • Use Numeric functions
  • Use aggregate functions
  • Run a simple analysis using RANK window function
  • Use control flow functions
  • Understand TiKV expression push down
  • JOIN concepts
  • JOIN multiple tables
  • UNION and other set operations on multiple queries
  • Subquery concept
  • Simple subqueries
  • Correlated subqueries

Build out a custom training plan?  영업 담당자에게 문의하세요.

Module 1: Querying Data in TiDB

  • Use DESC
  • Retrieve records using a SELECT statement
  • Query data from a MySQL client
  • Get query execution plan
  • Optimize pagination by KeySet seeker

Module 2: Data Types and Expressions

  • Describe data types
  • Describe numeric, date, string, and NULL
  • Describe boolean expression
  • Choose the right data type

Module 3: Functions and Expressions

  • Use String functions
  • Use Date and time functions
  • Use Numeric functions
  • Use aggregate functions
  • Run a simple analysis using RANK window function
  • Use control flow functions
  • Understand TiKV expression push down

Module 4: Joins

  • JOIN concepts
  • JOIN multiple tables
  • UNION and other set operations on multiple queries

Module 5: Subqueries

  • Subquery concept
  • Simple subqueries
  • Correlated subqueries

TiDB Cloud 전용

A fully-managed cloud DBaaS for predictable workloads

회원가입 더 알아보기

TiDB Cloud 스타터

A fully-managed cloud DBaaS for auto-scaling workloads

무료로 시작하세요 더 알아보기