{"id":5875,"date":"2024-12-21T11:10:55","date_gmt":"2024-12-21T11:10:55","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/hoc-va-thuc-hanh-ngon-ngu-truy-van-du-lieu-sql-ngay-trong-excel-khong-can-cai-dat\/"},"modified":"2024-12-21T11:10:55","modified_gmt":"2024-12-21T11:10:55","slug":"hoc-va-thuc-hanh-ngon-ngu-truy-van-du-lieu-sql-ngay-trong-excel-khong-can-cai-dat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/hoc-va-thuc-hanh-ngon-ngu-truy-van-du-lieu-sql-ngay-trong-excel-khong-can-cai-dat\/","title":{"rendered":"H\u1ecdc v\u00e0 th\u1ef1c h\u00e0nh ng\u00f4n ng\u1eef truy v\u1ea5n d\u1eef li\u1ec7u SQL ngay trong Excel kh\u00f4ng c\u1ea7n c\u00e0i \u0111\u1eb7t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>C\u00f3 th\u1ec3 \u0111\u00e2y l\u00e0 l\u1ea7n \u0111\u1ea7u ti\u00ean b\u1ea1n nghe v\u1ec1 ng\u00f4n ng\u1eef truy v\u1ea5n d\u1eef li\u1ec7u SQL, tuy nhi\u00ean SQL \u0111\u00e3 c\u00f3 tu\u1ed5i \u0111\u1eddi t\u1eeb kh\u00e1 l\u00e0 l\u00e2u r\u1ed3i. B\u1ea1n c\u00f3 th\u1ec3 s\u1ebd th\u1eafc m\u1eafc SQL l\u00e0 g\u00ec v\u00e0 SQL d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec th\u00ec trong b\u00e0i vi\u1ebft n\u00e0y, m\u00ecnh s\u1ebd tr\u1ea3 l\u1eddi cho c\u00e1c b\u1ea1n v\u1edbi nh\u1eefng ng\u00f4n t\u1eeb \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c kh\u00e1i ni\u1ec7m v\u00e0 \u00fd t\u01b0\u1edfng v\u1ec1 SQL.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6766a23eb4898\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/hoc-va-thuc-hanh-ngon-ngu-truy-van-du-lieu-sql-ngay-trong-excel-khong-can-cai-dat.html#Ngon_ngu_SQL_la_gi\" title=\"Ng\u00f4n ng\u1eef SQL l\u00e0 g\u00ec\">Ng\u00f4n ng\u1eef SQL l\u00e0 g\u00ec<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/hoc-va-thuc-hanh-ngon-ngu-truy-van-du-lieu-sql-ngay-trong-excel-khong-can-cai-dat.html#Bat_dau_hoc_SQL_nhu_the_nao\" title=\"B\u1eaft \u0111\u1ea7u h\u1ecdc SQL nh\u01b0 th\u1ebf n\u00e0o?\">B\u1eaft \u0111\u1ea7u h\u1ecdc SQL nh\u01b0 th\u1ebf n\u00e0o?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/hoc-va-thuc-hanh-ngon-ngu-truy-van-du-lieu-sql-ngay-trong-excel-khong-can-cai-dat.html#Tiep_tuc_hoc_SQL_nhu_the_nao\" title=\"Ti\u1ebfp t\u1ee5c h\u1ecdc SQL nh\u01b0 th\u1ebf n\u00e0o?\">Ti\u1ebfp t\u1ee5c h\u1ecdc SQL nh\u01b0 th\u1ebf n\u00e0o?<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ngon_ngu_SQL_la_gi\"><\/span>Ng\u00f4n ng\u1eef SQL l\u00e0 g\u00ec<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y, c\u00f3 th\u1ec3 b\u1ea1n ph\u1ea3i ti\u1ebfp x\u00fac v\u1edbi r\u1ea5t nhi\u1ec1u b\u1ea3ng bi\u1ec3u v\u00e0 s\u1ed1 li\u1ec7u, v\u00e0 m\u1ed9t trong nh\u1eefng c\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 truy v\u1ea5n \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng ng\u00f4n ng\u1eef truy v\u1ea5n d\u1eef li\u1ec7u c\u00f3 c\u1ea5u tr\u00fac SQL. V\u1edbi c\u00e1c b\u1ea1n s\u1ee3 ph\u1ea3i h\u1ecdc m\u00f4n ng\u00f4n ng\u1eef m\u1edbi, c\u00e1c b\u1ea1n h\u00e3y y\u00ean t\u00e2m b\u1edfi v\u00ec ng\u00f4n ng\u1eef SQL c\u00f3 c\u1ea5u tr\u00fac v\u00e0 t\u1eeb ng\u1eef r\u1ea5t gi\u1ed1ng ti\u1ebfng anh v\u00e0 kh\u00e1 \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 h\u1ecdc<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bat_dau_hoc_SQL_nhu_the_nao\"><\/span>B\u1eaft \u0111\u1ea7u h\u1ecdc SQL nh\u01b0 th\u1ebf n\u00e0o?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 b\u1eaft \u0111\u1ea7u h\u1ecdc SQL m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t m\u00e0 g\u1ea7n nh\u01b0 kh\u00f4ng ph\u1ea3i c\u00e0i th\u00eam b\u1ea5t c\u1ee9 ph\u1ea7n m\u1ec1m n\u00e0o th\u00ec b\u1ea1n c\u00f3 th\u1ec3 download file excel sau \u0111\u00e2y:<\/p>\n<p><strong><a href=\"https:\/\/drive.google.com\/open?id=1oDoYcGoxK1XN2abGuEyoyZnMRRYIqhmQ\" target=\"_blank\" rel=\"noopener noreferrer\">DOWNLOAD T\u00c0I LI\u1ec6U<\/a><\/strong><\/p>\n<p>Sau khi download file excel \u201cCh\u01b0\u01a1ng tr\u00ecnh h\u1ecdc SQL\u201d c\u1ee7a ch\u00fang ta, b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i video sau \u0111\u1ec3 c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u 1 c\u00e1ch nhanh nh\u1ea5t. \u0110\u1eebng qu\u00ean <strong><a href=\"https:\/\/www.youtube.com\/user\/ductnguy?sub_confirmation=1&amp;UTM_SOURCE=F\" target=\"_blank\" rel=\"noopener noreferrer\">subscribe \/ \u0111\u0103ng k\u00fd<\/a><\/strong> theo d\u00f5i \u0111\u1ec3 \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt nh\u1eefng ki\u1ebfn th\u1ee9c m\u1edbi nh\u1ea5t<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/0ehpTsxKBYc\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<h2><span class=\"ez-toc-section\" id=\"Tiep_tuc_hoc_SQL_nhu_the_nao\"><\/span>Ti\u1ebfp t\u1ee5c h\u1ecdc SQL nh\u01b0 th\u1ebf n\u00e0o?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n h\u1ecdc ti\u1ebfp v\u00e0 bi\u1ebft \u0111\u01b0\u1ee3c SQL \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng v\u00e0o l\u1eadp tr\u00ecnh nh\u01b0 th\u1ebf n\u00e0o, h\u00e3y tham kh\u1ea3o <a href=\"https:\/\/hocexcel.online\/course\/preview\/vba201-lap-trinh-vba-nang-cao-trong-excel\" target=\"_blank\" rel=\"noopener noreferrer\">kho\u00e1 h\u1ecdc VBA \u2013 n\u00e2ng cao c\u1ee7a H\u1ecdc Excel Online<\/a> t\u1ea1i \u0111\u1ecba ch\u1ec9:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-220.gif\" title=\"vba101_92019-nho-220\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-520.gif\" title=\"ex101_92019-nho-520\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/vba201-lap-trinh-vba-nang-cao-trong-excel\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/hocexcel.online\/course\/preview\/vba201-lap-trinh-vba-nang-cao-trong-excel<\/a><\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n ti\u1ebfp t\u1ee5c h\u1ecdc SQL m\u00e0 kh\u00f4ng mu\u1ed1n \u0111i qu\u00e1 s\u00e2u v\u00e0o l\u1eadp tr\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o 1 s\u1ed1 \u0111\u01b0\u1eddng link sau \u0111\u00e2y (ti\u1ebfng Anh):<\/p>\n<p><a href=\"https:\/\/www.w3schools.com\/sql\/\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc SQL c\u01a1 b\u1ea3n \u1edf W3Schools<\/a><\/p>\n<p><a href=\"http:\/\/www.sqlcourse.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc SQL t\u01b0\u01a1ng t\u00e1c online<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-220.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5876,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5875","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=5875"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5875\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5876"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}