{"id":7080,"date":"2022-06-20T23:08:37","date_gmt":"2022-06-21T06:08:37","guid":{"rendered":"https:\/\/en.pingcap.com\/?page_id=7080"},"modified":"2023-09-11T01:34:02","modified_gmt":"2023-09-11T08:34:02","slug":"course-learn-sql-with-tidb","status":"publish","type":"page","link":"https:\/\/www.pingcap.com\/ko\/education\/course-learn-sql-with-tidb\/","title":{"rendered":"Course: Learn SQL with TiDB"},"content":{"rendered":"","protected":false},"excerpt":{"rendered":"","protected":false},"author":188,"featured_media":0,"parent":7058,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ub_ctt_via":""},"class_list":["post-7080","page","type-page","status-publish","hentry"],"acf":[],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Course: Learn SQL with TiDB | TiDB<\/title>\n<meta name=\"description\" content=\"This course focuses on the essential SQL query skills and guides the audience to take performance into consideration while writing SQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pingcap.com\/ko\/education\/course-learn-sql-with-tidb\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Course: Learn SQL with TiDB | TiDB\" \/>\n<meta property=\"og:description\" content=\"This course focuses on the essential SQL query skills and guides the audience to take performance into consideration while writing SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/education\/course-learn-sql-with-tidb\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-11T08:34:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2024\/09\/11005522\/Homepage-Ad.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1440\" \/>\n\t<meta property=\"og:image:height\" content=\"714\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/education\/course-learn-sql-with-tidb\/\",\"url\":\"https:\/\/www.pingcap.com\/education\/course-learn-sql-with-tidb\/\",\"name\":\"Course: Learn SQL with TiDB | TiDB\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"datePublished\":\"2022-06-21T06:08:37+00:00\",\"dateModified\":\"2023-09-11T08:34:02+00:00\",\"description\":\"This course focuses on the essential SQL query skills and guides the audience to take performance into consideration while writing SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/education\/course-learn-sql-with-tidb\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/education\/course-learn-sql-with-tidb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/education\/course-learn-sql-with-tidb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Training and Certification\",\"item\":\"https:\/\/www.pingcap.com\/education\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Course: Learn SQL with TiDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pingcap.com\/#website\",\"url\":\"https:\/\/www.pingcap.com\/\",\"name\":\"TiDB\",\"description\":\"TiDB | SQL at Scale\",\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pingcap.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pingcap.com\/#organization\",\"name\":\"PingCAP\",\"url\":\"https:\/\/www.pingcap.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"width\":811,\"height\":232,\"caption\":\"PingCAP\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/pingcap2015\",\"https:\/\/x.com\/PingCAP\",\"https:\/\/linkedin.com\/company\/pingcap\",\"https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Course: Learn SQL with TiDB | TiDB","description":"This course focuses on the essential SQL query skills and guides the audience to take performance into consideration while writing SQL.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pingcap.com\/ko\/education\/course-learn-sql-with-tidb\/","og_locale":"ko_KR","og_type":"article","og_title":"Course: Learn SQL with TiDB | TiDB","og_description":"This course focuses on the essential SQL query skills and guides the audience to take performance into consideration while writing SQL.","og_url":"https:\/\/www.pingcap.com\/ko\/education\/course-learn-sql-with-tidb\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2023-09-11T08:34:02+00:00","og_image":[{"width":1440,"height":714,"url":"https:\/\/static.pingcap.com\/files\/2024\/09\/11005522\/Homepage-Ad.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@PingCAP","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/education\/course-learn-sql-with-tidb\/","url":"https:\/\/www.pingcap.com\/education\/course-learn-sql-with-tidb\/","name":"Course: Learn SQL with TiDB | TiDB","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"datePublished":"2022-06-21T06:08:37+00:00","dateModified":"2023-09-11T08:34:02+00:00","description":"This course focuses on the essential SQL query skills and guides the audience to take performance into consideration while writing SQL.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/education\/course-learn-sql-with-tidb\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/education\/course-learn-sql-with-tidb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/education\/course-learn-sql-with-tidb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Training and Certification","item":"https:\/\/www.pingcap.com\/education\/"},{"@type":"ListItem","position":3,"name":"Course: Learn SQL with TiDB"}]},{"@type":"WebSite","@id":"https:\/\/www.pingcap.com\/#website","url":"https:\/\/www.pingcap.com\/","name":"\ud2f0DB","description":"TiDB | SQL at Scale","publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pingcap.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.pingcap.com\/#organization","name":"PingCAP","url":"https:\/\/www.pingcap.com\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/","url":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","width":811,"height":232,"caption":"PingCAP"},"image":{"@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/pingcap2015","https:\/\/x.com\/PingCAP","https:\/\/linkedin.com\/company\/pingcap","https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA"]}]}},"grav_blocks":[{"acf_fc_layout":"columns","format":"","enable_box_container":false,"column_num":"8","columns":[{"type":"wysiwyg","wysiwyg":"<h2>Introduction<\/h2>\n<p>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.<\/p>\n<p>Free online learning is coming soon!<\/p>\n<p>Private Training is available now. To purchase Private Training, contact sales to build out a custom training plan.<\/p>\n<p><a class=\"button\" href=\"\/contact-us\/\"> Contact Sales <\/a><\/p>\n","accordion_column_title":"","accordion_sections":false,"video_image":false,"video_url":"","video_content":""},{"type":"wysiwyg","wysiwyg":"<h2>Summary<\/h2>\n<ul style=\"padding-left: 1em;\">\n<li><strong>Audience:<\/strong> SQL developer beginners<\/li>\n<li><strong>Level:<\/strong> Introductory<\/li>\n<li><strong>Duration:<\/strong> 1 day<\/li>\n<li><strong>Prerequisites:<\/strong> You know how to connect to TiDB with the MySQL Client.<\/li>\n<li><strong>TiDB Version:<\/strong> v6.x<\/li>\n<\/ul>\n","accordion_column_title":"","accordion_sections":false,"video_image":false,"video_url":"","video_content":""}],"block_background":"block-bg-none","block_background_video_type":"url","block_background_video_url":"","block_background_video_file":false,"block_background_image":false,"block_background_overlay":false,"unique_id":"","block_option_custom_class":"","block_option_padding":[],"block_option_hide":[],"block_add_top_arc":false,"block_increase_bottom_padding":false},{"acf_fc_layout":"tabs","format":"","nav_title":"Course Outline","nav_title_desc":"","nav_block_title":"","nav_content":"<p>Build out a custom training plan?\u00a0 <a class=\"button button--secondary\" href=\"\/contact-us\">Contact Sales<\/a><\/p>\n","format_title":"image","column_num":"12","sections":[{"title":"Module 1: Querying Data in TiDB","image":false,"title_text":"","title_image":false,"content":"<ul style=\"padding-left: 1em;\">\n<li>Use DESC<\/li>\n<li>Retrieve records using a SELECT statement<\/li>\n<li>Query data from a MySQL client<\/li>\n<li>Get query execution plan<\/li>\n<li>Optimize pagination by KeySet seeker<\/li>\n<\/ul>"},{"title":"Module 2: Data Types and Expressions","image":false,"title_text":"","title_image":false,"content":"<ul style=\"padding-left: 1em;\">\n<li>Describe data types<\/li>\n<li>Describe numeric, date, string, and NULL<\/li>\n<li>Describe boolean expression<\/li>\n<li>Choose the right data type<\/li>\n<\/ul>"},{"title":"Module 3: Functions and Expressions","image":false,"title_text":"","title_image":false,"content":"<ul style=\"padding-left: 1em;\">\n<li>Use String functions<\/li>\n<li>Use Date and time functions<\/li>\n<li>Use Numeric functions<\/li>\n<li>Use aggregate functions<\/li>\n<li>Run a simple analysis using RANK window function<\/li>\n<li>Use control flow functions<\/li>\n<li>Understand TiKV expression push down<\/li>\n<\/ul>"},{"title":"Module 4: Joins","image":false,"title_text":"","title_image":false,"content":"<ul style=\"padding-left: 1em;\">\n<li>JOIN concepts<\/li>\n<li>JOIN multiple tables<\/li>\n<li>UNION and other set operations on multiple queries<\/li>\n<\/ul>"},{"title":"Module 5: Subqueries","image":false,"title_text":"","title_image":false,"content":"<ul style=\"padding-left: 1em;\">\n<li>Subquery concept<\/li>\n<li>Simple subqueries<\/li>\n<li>Correlated subqueries<\/li>\n<\/ul>"}],"block_background":"block-bg-none","block_background_video_type":"url","block_background_video_url":"","block_background_video_file":false,"block_background_image":false,"block_background_overlay":false,"unique_id":"","block_option_custom_class":"","block_option_padding":[],"block_option_hide":[],"block_add_top_arc":false,"block_increase_bottom_padding":false},{"acf_fc_layout":"global-block","block_group":62}],"_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/pages\/7080","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/users\/188"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/comments?post=7080"}],"version-history":[{"count":12,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/pages\/7080\/revisions"}],"predecessor-version":[{"id":8884,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/pages\/7080\/revisions\/8884"}],"up":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/pages\/7058"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=7080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}