{"id":23576,"date":"2026-02-08T15:55:35","date_gmt":"2026-02-08T13:55:35","guid":{"rendered":"https:\/\/atharhubs.com\/?post_type=courses&#038;p=23576"},"modified":"2026-02-08T16:55:37","modified_gmt":"2026-02-08T13:55:37","slug":"sql-for-data-engineering","status":"publish","type":"courses","link":"https:\/\/atharhubs.com\/en\/courses\/sql-for-data-engineering\/","title":{"rendered":"\u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0644\u0647\u0646\u062f\u0633\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u2013 \u0645\u0646 \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0627\u062a \u0625\u0644\u0649 \u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0639\u0645\u0644\u064a"},"content":{"rendered":"<p data-start=\"262\" data-end=\"511\">The program aims <strong data-start=\"274\" data-end=\"302\">SQL for Data Engineering<\/strong> \u0625\u0644\u0649 \u062a\u0623\u0647\u064a\u0644 \u0627\u0644\u0645\u062a\u062f\u0631\u0628\u064a\u0646 \u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0644\u063a\u0629 <strong data-start=\"336\" data-end=\"343\">SQL<\/strong> \u0628\u0634\u0643\u0644 \u0627\u062d\u062a\u0631\u0627\u0641\u064a \u0641\u064a \u0645\u0647\u0627\u0645 <strong data-start=\"365\" data-end=\"383\">Data engineering<\/strong>\u060c \u0645\u062b\u0644 \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0643\u0645\u064a\u0627\u062a \u0643\u0628\u064a\u0631\u0629 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0628\u0646\u0627\u0621 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0645\u0639\u0642\u062f\u0629\u060c \u062a\u062c\u0647\u064a\u0632 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0644\u0644\u062a\u062d\u0644\u064a\u0644\u060c \u0648\u062f\u0639\u0645 \u062e\u0637\u0648\u0637 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a (Data Pipelines).<\/p>\n<p data-start=\"513\" data-end=\"722\">\u064a\u0631\u0643\u0651\u0632 \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c \u0639\u0644\u0649 \u0627\u0644\u062c\u0627\u0646\u0628 \u0627\u0644\u0639\u0645\u0644\u064a\u060c \u0645\u0639 \u062a\u0648\u0636\u064a\u062d \u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 SQL \u0641\u064a \u0628\u064a\u0626\u0627\u062a \u0627\u0644\u0639\u0645\u0644 \u0627\u0644\u062d\u0642\u064a\u0642\u064a\u0629 \u0627\u0644\u062e\u0627\u0635\u0629 \u0628\u0645\u0647\u0646\u062f\u0633\u064a \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0628\u0645\u0627 \u064a\u0634\u0645\u0644 \u062a\u0635\u0645\u064a\u0645 \u0627\u0644\u062c\u062f\u0627\u0648\u0644\u060c \u062a\u062d\u0633\u064a\u0646 \u0627\u0644\u0623\u062f\u0627\u0621\u060c \u0648\u062a\u0646\u0641\u064a\u0630 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0628\u0643\u0641\u0627\u0621\u0629 \u0639\u0627\u0644\u064a\u0629 \u0639\u0644\u0649 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0639\u0644\u0627\u0626\u0642\u064a\u0629.<\/p>\n<p data-start=\"724\" data-end=\"850\">\u062a\u0645 \u062a\u0635\u0645\u064a\u0645 \u0627\u0644\u0645\u062d\u062a\u0648\u0649 \u0644\u064a\u0648\u0641\u0651\u0631 \u0623\u0633\u0627\u0633\u064b\u0627 \u0642\u0648\u064a\u064b\u0627 \u064a\u0645\u0643\u0646 \u0627\u0644\u0627\u0639\u062a\u0645\u0627\u062f \u0639\u0644\u064a\u0647 \u0641\u064a \u0645\u0633\u0627\u0631\u0627\u062a <strong data-start=\"790\" data-end=\"849\">Data Engineering\u060c Data Analysis\u060c \u0648Business Intelligence<\/strong>.<\/p>\n<hr data-start=\"852\" data-end=\"855\" \/>\n<h2 data-start=\"857\" data-end=\"886\">\ud83d\udcda The training curriculum\u00a0<\/h2>\n<ul data-start=\"888\" data-end=\"1356\">\n<li data-start=\"888\" data-end=\"929\">\n<p data-start=\"890\" data-end=\"929\">\u0645\u0642\u062f\u0645\u0629 \u0639\u0646 SQL \u0648\u062f\u0648\u0631\u0647\u0627 \u0641\u064a \u0647\u0646\u062f\u0633\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/p>\n<\/li>\n<li data-start=\"930\" data-end=\"964\">\n<p data-start=\"932\" data-end=\"964\">\u0623\u0646\u0648\u0627\u0639 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0639\u0644\u0627\u0626\u0642\u064a\u0629<\/p>\n<\/li>\n<li data-start=\"965\" data-end=\"1003\">\n<p data-start=\"967\" data-end=\"1003\">\u0625\u0646\u0634\u0627\u0621 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0648\u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/p>\n<\/li>\n<li data-start=\"1004\" data-end=\"1064\">\n<p data-start=\"1006\" data-end=\"1012\">\u0623\u0648\u0627\u0645\u0631:<\/p>\n<ul data-start=\"1015\" data-end=\"1064\">\n<li data-start=\"1015\" data-end=\"1025\">\n<p data-start=\"1017\" data-end=\"1025\">SELECT<\/p>\n<\/li>\n<li data-start=\"1028\" data-end=\"1038\">\n<p data-start=\"1030\" data-end=\"1038\">INSERT<\/p>\n<\/li>\n<li data-start=\"1041\" data-end=\"1051\">\n<p data-start=\"1043\" data-end=\"1051\">UPDATE<\/p>\n<\/li>\n<li data-start=\"1054\" data-end=\"1064\">\n<p data-start=\"1056\" data-end=\"1064\">DELETE<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li data-start=\"1065\" data-end=\"1102\">\n<p data-start=\"1067\" data-end=\"1102\">\u0627\u0644\u062a\u0635\u0641\u064a\u0629 \u0648\u0627\u0644\u0641\u0631\u0632 (WHERE \u2013 ORDER BY)<\/p>\n<\/li>\n<li data-start=\"1103\" data-end=\"1152\">\n<p data-start=\"1105\" data-end=\"1152\">\u0627\u0644\u062a\u062c\u0645\u064a\u0639 \u0648\u0627\u0644\u062f\u0648\u0627\u0644 \u0627\u0644\u062a\u062c\u0645\u064a\u0639\u064a\u0629 (GROUP BY \u2013 HAVING)<\/p>\n<\/li>\n<li data-start=\"1153\" data-end=\"1182\">\n<p data-start=\"1155\" data-end=\"1182\">\u0627\u0644\u0631\u0628\u0637 \u0628\u064a\u0646 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 (JOINs)<\/p>\n<\/li>\n<li data-start=\"1183\" data-end=\"1219\">\n<p data-start=\"1185\" data-end=\"1219\">\u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0641\u0631\u0639\u064a\u0629 (Subqueries)<\/p>\n<\/li>\n<li data-start=\"1220\" data-end=\"1247\">\n<p data-start=\"1222\" data-end=\"1247\">\u062a\u0635\u0645\u064a\u0645 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0648\u0627\u0644\u0639\u0644\u0627\u0642\u0627\u062a<\/p>\n<\/li>\n<li data-start=\"1248\" data-end=\"1283\">\n<p data-start=\"1250\" data-end=\"1283\">Indexes \u0648\u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a<\/p>\n<\/li>\n<li data-start=\"1284\" data-end=\"1330\">\n<p data-start=\"1286\" data-end=\"1330\">\u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0641\u064a \u0633\u064a\u0627\u0642 Data Pipelines<\/p>\n<\/li>\n<li data-start=\"1331\" data-end=\"1356\">\n<p data-start=\"1333\" data-end=\"1356\">\u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0639\u0645\u0644\u064a\u0629 \u0648\u062a\u0645\u0627\u0631\u064a\u0646<\/p>\n<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>\u064a\u0647\u062f\u0641 \u0628\u0631\u0646\u0627\u0645\u062c SQL for Data Engineering \u0625\u0644\u0649 \u062a\u0623\u0647\u064a\u0644 \u0627\u0644\u0645\u062a\u062f\u0631\u0628\u064a\u0646 \u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0644\u063a\u0629 SQL \u0628\u0634\u0643\u0644 \u0627\u062d\u062a\u0631\u0627\u0641\u064a \u0641\u064a \u0645\u0647\u0627\u0645 \u0647\u0646\u062f\u0633\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0645\u062b\u0644 \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0643\u0645\u064a\u0627\u062a \u0643\u0628\u064a\u0631\u0629 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0628\u0646\u0627\u0621 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0645\u0639\u0642\u062f\u0629\u060c \u062a\u062c\u0647\u064a\u0632 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0644\u0644\u062a\u062d\u0644\u064a\u0644\u060c \u0648\u062f\u0639\u0645 \u062e\u0637\u0648\u0637 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a (Data Pipelines). \u064a\u0631\u0643\u0651\u0632 \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c \u0639\u0644\u0649 \u0627\u0644\u062c\u0627\u0646\u0628 \u0627\u0644\u0639\u0645\u0644\u064a\u060c \u0645\u0639 \u062a\u0648\u0636\u064a\u062d \u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 SQL \u0641\u064a \u0628\u064a\u0626\u0627\u062a \u0627\u0644\u0639\u0645\u0644 \u0627\u0644\u062d\u0642\u064a\u0642\u064a\u0629 \u0627\u0644\u062e\u0627\u0635\u0629 \u0628\u0645\u0647\u0646\u062f\u0633\u064a \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0628\u0645\u0627 \u064a\u0634\u0645\u0644 [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":23587,"template":"","course-category":[700],"course-tag":[],"class_list":["post-23576","courses","type-courses","status-publish","has-post-thumbnail","hentry","course-category-700"],"acf":[],"_links":{"self":[{"href":"https:\/\/atharhubs.com\/en\/wp-json\/wp\/v2\/courses\/23576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/atharhubs.com\/en\/wp-json\/wp\/v2\/courses"}],"about":[{"href":"https:\/\/atharhubs.com\/en\/wp-json\/wp\/v2\/types\/courses"}],"author":[{"embeddable":true,"href":"https:\/\/atharhubs.com\/en\/wp-json\/wp\/v2\/users\/13"}],"version-history":[{"count":4,"href":"https:\/\/atharhubs.com\/en\/wp-json\/wp\/v2\/courses\/23576\/revisions"}],"predecessor-version":[{"id":23765,"href":"https:\/\/atharhubs.com\/en\/wp-json\/wp\/v2\/courses\/23576\/revisions\/23765"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/atharhubs.com\/en\/wp-json\/wp\/v2\/media\/23587"}],"wp:attachment":[{"href":"https:\/\/atharhubs.com\/en\/wp-json\/wp\/v2\/media?parent=23576"}],"wp:term":[{"taxonomy":"course-category","embeddable":true,"href":"https:\/\/atharhubs.com\/en\/wp-json\/wp\/v2\/course-category?post=23576"},{"taxonomy":"course-tag","embeddable":true,"href":"https:\/\/atharhubs.com\/en\/wp-json\/wp\/v2\/course-tag?post=23576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}