{"id":10230,"date":"2024-05-26T09:00:00","date_gmt":"2024-05-26T02:00:00","guid":{"rendered":"http:\/\/localhost\/fstudy\/courses\/thuc-hanh-sql-tu-a-z-de-tro-thanh-data-analyst-udemy-tieng-viet\/"},"modified":"2024-05-26T09:00:00","modified_gmt":"2024-05-26T02:00:00","slug":"thuc-hanh-sql-tu-a-z-de-tro-thanh-data-analyst-udemy-tieng-viet","status":"publish","type":"courses","link":"https:\/\/studaca.online\/courses\/thuc-hanh-sql-tu-a-z-de-tro-thanh-data-analyst-udemy-tieng-viet\/","title":{"rendered":"Th\u1ef1c h\u00e0nh SQL t\u1eeb A &#8211;> Z \u0111\u1ec3 tr\u1edf th\u00e0nh Data Analyst (Udemy &#8211; Ti\u1ebfng Vi\u1ec7t)"},"content":{"rendered":"<p>Views<\/p>\n<p>What you&#8217;ll learn:<br \/>\u0110\u1ea9y d\u1eef li\u1ec7u t\u1eeb Excel, CSV,\u2026 v\u00e0o MS SQL SERVER<br \/>Vi\u1ebft c\u00e1c c\u00e2u l\u1ec7nh CREATE, UPDATE, SELECT \u0111\u1ebfn ph\u00e2n t\u00edch d\u1eef li\u1ec7u chuy\u00ean s\u00e2u v\u1edbi Analytic Function&#8230;<br \/>T\u00ecm hi\u1ec3u c\u00e1c l\u1ec7nh SQL JOIN ph\u1ed5 bi\u1ebfn v\u00e0 li\u00ean k\u1ebft ph\u1ee9c t\u1ea1p nhi\u1ec1u b\u1ea3ng<br \/>S\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o truy v\u1ea5n con (Subqueries)<br \/>Bi\u1ebft c\u00e1ch ph\u00e2n bi\u1ec7t v\u00e0 \u1ee9ng d\u1ef1ng \u0111\u1ec3 g\u1ed9p d\u1eef li\u1ec7u v\u1edbi Union\/ Union All<br \/>Hi\u1ec3u r\u00f5 v\u00e0 c\u00f3 kh\u1ea3 n\u0103ng s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c c\u00e1c to\u00e1n t\u1eed kh\u00e1c nhau trong SQL<br \/>Hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1c nguy\u00ean t\u1eafc thi\u1ebft y\u1ebfu c\u1ee7a H\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u quan h\u1ec7 (RDBMS) v\u00e0 Ng\u00f4n ng\u1eef truy v\u1ea5n c\u00f3 c\u1ea5u tr\u00fac (SQL)<br \/>S\u1eed d\u1ee5ng c\u00e1c h\u00e0m x\u1ebfp h\u1ea1ng \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1, x\u1ebfp h\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n&#8230;<br \/>S\u1eed d\u1ee5ng c\u00e1c h\u00e0m d\u1ef1ng s\u1eb5n: X\u1eed l\u00fd chu\u1ed7i, to\u00e1n h\u1ecdc&#8230;<\/p>\n<p>Link g\u1ed1c:<br \/> https:\/\/www.udemy.com\/course\/thuc-hanh-sql-tu-a-z-e-tro-thanh-data-analyst\/<\/p>\n<p>Time Course: <br \/>10.5 hours (83 Lectures + Documents)<\/p>\n<p>Instructor<br \/>:\u00a0Th\u1ea7y S\u01a1n BI<br \/>Total Weight:<br \/>\u00a07.77 GB<br \/>** Note<br \/>: \u00a0<\/p>\n<p>Ch\u00fa \u00fd:<\/p>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Views What you&#8217;ll learn:\u0110\u1ea9y d\u1eef li\u1ec7u t\u1eeb Excel, CSV,\u2026 v\u00e0o MS SQL SERVERVi\u1ebft c\u00e1c c\u00e2u l\u1ec7nh CREATE, UPDATE,<\/p>\n","protected":false},"author":1,"featured_media":9895,"template":"","course-category":[81],"course-tag":[],"class_list":["post-10230","courses","type-courses","status-publish","has-post-thumbnail","hentry","course-category-it"],"_links":{"self":[{"href":"https:\/\/studaca.online\/api\/wp\/v2\/courses\/10230","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studaca.online\/api\/wp\/v2\/courses"}],"about":[{"href":"https:\/\/studaca.online\/api\/wp\/v2\/types\/courses"}],"author":[{"embeddable":true,"href":"https:\/\/studaca.online\/api\/wp\/v2\/users\/1"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studaca.online\/api\/wp\/v2\/media\/9895"}],"wp:attachment":[{"href":"https:\/\/studaca.online\/api\/wp\/v2\/media?parent=10230"}],"wp:term":[{"taxonomy":"course-category","embeddable":true,"href":"https:\/\/studaca.online\/api\/wp\/v2\/course-category?post=10230"},{"taxonomy":"course-tag","embeddable":true,"href":"https:\/\/studaca.online\/api\/wp\/v2\/course-tag?post=10230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}