{"id":819,"date":"2017-05-13T21:11:51","date_gmt":"2017-05-13T21:11:51","guid":{"rendered":"http:\/\/mesbahi.net\/fa\/?p=819"},"modified":"2024-01-29T19:45:56","modified_gmt":"2024-01-29T19:45:56","slug":"%d8%af%d9%88%d8%b1%d9%87-%d8%a2%d9%85%d9%88%d8%b2%d8%b4%db%8c-sql-server","status":"publish","type":"post","link":"https:\/\/mesbahi.net\/fa\/blog\/1396\/02\/23\/%d8%af%d9%88%d8%b1%d9%87-%d8%a2%d9%85%d9%88%d8%b2%d8%b4%db%8c-sql-server\/","title":{"rendered":"\u062f\u0648\u0631\u0647 \u0622\u0645\u0648\u0632\u0634\u06cc SQL Server"},"content":{"rendered":"<p dir=\"rtl\">\u0627\u0633\u062a\u0642\u0628\u0627\u0644 \u0648 \u0645\u062d\u0628\u062a \u062f\u0648\u0633\u062a\u0627\u0646 \u0645\u062e\u062a\u0644\u0641 \u0628\u0627\u0639\u062b \u0634\u062f \u062a\u0627 \u0628\u0631\u0627\u06cc \u06cc\u06a9 \u062f\u0648\u0631\u0647 \u0622\u0645\u0648\u0632\u0634\u06cc SQL Server \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0631\u06cc\u0632\u06cc \u06a9\u0646\u0645. \u0628\u0639\u062f \u0627\u0632 SQL Server 2000 \u062f\u0648\u0631\u0647\u200c\u0647\u0627\u06cc 2005, 2008, 2012, 2014, 2016 \u0631\u0627 \u0628\u0647 \u062f\u0648 \u0635\u0648\u0631\u062a \u06a9\u0647 \u06cc\u06a9\u06cc \u0645\u0631\u06a9\u0628 \u0627\u0632 Develop+Admin \u0648 \u062f\u06cc\u06af\u0631\u06cc SSIS+SSAS \u0628\u0648\u062f\u0647 \u0627\u0633\u062a \u062a\u062f\u0631\u06cc\u0633 \u06a9\u0631\u062f\u0647\u200c\u0627\u0645 (\u0627\u0644\u0628\u062a\u0647 \u0628\u0647\u200c\u062c\u0632 \u06a9\u0627\u0631\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062a\u062e\u0635\u0635\u06cc Tuning \u0648 Recovery). \u0648\u0644\u06cc \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u06af\u0633\u062a\u0631\u062f\u0647 \u062f\u0631 2016 SQL Server \u0648 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0627\u0632 \u0632\u0628\u0627\u0646 R\u060c \u0645\u06cc\u200c\u0628\u0627\u06cc\u0633\u062a \u0627\u06cc\u0646 \u0631\u0648\u0646\u062f \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc\u200c\u06a9\u0631\u062f\u060c \u062f\u0648\u0631\u0647\u200c\u0647\u0627\u06cc 2016 \u0637\u0628\u0642 \u0631\u0648\u0627\u0644 \u06af\u0630\u0634\u062a\u0647 \u0628\u0648\u062f \u0648 \u062f\u0648\u0631\u0647 \u0645\u062c\u0632\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc R \u0628\u0631\u06af\u0632\u0627\u0631 \u06a9\u0631\u062f\u0645\u060c \u0648\u0644\u06cc \u0628\u0631\u0627\u06cc SQL Server 2017 \u06a9\u0647 \u062a\u0627 \u0686\u0646\u062f\u06cc \u067e\u06cc\u0634 \u0628\u0647\u200c\u0639\u0646\u0648\u0627\u0646 vNext \u0627\u0632 \u0622\u0646 \u06cc\u0627\u062f \u0645\u06cc\u200c\u06a9\u0631\u062f\u06cc\u0645\u060c \u0645\u062c\u062f\u062f\u0627\u064b \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0639\u0645\u06cc\u0642\u06cc \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u060c \u0648 \u0627\u06a9\u0646\u0648\u0646 \u0645\u0628\u0627\u062d\u062b \u0627\u062f\u0645\u06cc\u0646 \u0631\u0627 \u0628\u0627\u06cc\u062f \u0628\u0627 \u062f\u0648 \u06af\u0631\u0627\u06cc\u0634 Linux \u0648 Windows \u0628\u0631\u06af\u0632\u0627\u0631 \u06a9\u0631\u062f \u0648 \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u0637\u0648\u0644\u0627\u0646\u06cc \u0634\u062f\u0646 \u062f\u0648\u0631\u0647 \u06a9\u0647 \u0647\u0645\u06cc\u0646 \u062d\u0627\u0644\u0627 \u0647\u0645 \u0628\u06cc\u0634 \u0627\u0632 \u06f1\u06f0\u06f0 \u0633\u0627\u0639\u062a \u0627\u0633\u062a\u060c \u0627\u0645\u06a9\u0627\u0646\u200c\u067e\u0630\u06cc\u0631 \u0646\u06cc\u0633\u062a \u0648 \u0628\u0647 \u062f\u0631\u0627\u0632\u0627 \u06a9\u0634\u06cc\u062f\u0647 \u0634\u062f\u0646 \u062f\u0648\u0631\u0647 \u0648 \u0628\u0627\u0644\u0627 \u0631\u0641\u062a\u0646 \u0647\u0632\u06cc\u0646\u0647\u200c\u0647\u0627 \u062a\u0623\u062b\u06cc\u0631 \u0645\u0646\u0641\u06cc \u0628\u0631 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0634\u0631\u06a9\u062a\u200c\u06a9\u0646\u0646\u062f\u06af\u0627\u0646 \u062e\u0648\u0627\u0647\u062f \u062f\u0627\u0634\u062a.<\/p>\n<p dir=\"rtl\">\u0627\u0632\u0627\u06cc\u0646\u200c\u0631\u0648 \u062a\u0635\u0645\u06cc\u0645 \u062f\u0627\u0631\u0645 \u062f\u0648\u0631\u0647 \u067e\u06cc\u0634 \u0631\u0648 \u06a9\u0647 \u0627\u0648\u0644\u06cc\u0646 \u062f\u0648\u0631\u0647 \u0628\u0627 \u0645\u0637\u0627\u0644\u0628 \u062c\u062f\u06cc\u062f SQL Server 2017 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f \u0631\u0627 \u0628\u0647 \u06af\u0648\u0646\u0647\u200c\u0627\u06cc \u0645\u062a\u0646\u0627\u0633\u0628 \u0628\u0627 \u0634\u0631\u0627\u06cc\u0637 \u062c\u062f\u06cc\u062f \u0628\u0631\u06af\u0632\u0627\u0631 \u0646\u0645\u0627\u06cc\u0645. \u0627\u06cc\u0646 \u062f\u0648\u0631\u0647 \u0634\u0627\u0645\u0644 \u0645\u0628\u0627\u062d\u062b Development \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f \u0648 \u0633\u06cc\u0644\u0627\u0628\u0633 \u0622\u0646 \u0628\u0647 \u06af\u0648\u0646\u0647\u200c\u0627\u06cc \u062a\u0646\u0638\u06cc\u0645 \u0634\u062f\u0647 \u062a\u0627 \u0627\u0641\u0631\u0627\u062f \u0631\u0627 \u062f\u0631 \u0632\u0645\u06cc\u0646\u0647 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 SQL \u0648 R \u0647\u062f\u0627\u06cc\u062a \u0646\u0645\u0627\u06cc\u062f. \u0627\u0632\u0627\u06cc\u0646\u200c\u0631\u0648 \u0645\u0628\u0627\u062d\u062b Admin \u0628\u0647 \u062d\u062f\u0627\u0642\u0644 \u062e\u0648\u0627\u0647\u062f \u0631\u0633\u06cc\u062f. \u0645\u0637\u0627\u0644\u0628 \u0645\u0646\u0637\u0628\u0642 \u0628\u0627 SQL Server 2016 \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a\u06cc \u06a9\u0647 \u062a\u0627\u06a9\u0646\u0648\u0646 \u062f\u0631 SQL Server 2017 \u0627\u0639\u0645\u0627\u0644 \u0634\u062f\u0647 \u0627\u0633\u062a \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f \u0648 \u0628\u0647\u200c\u0639\u0646\u0648\u0627\u0646 \u0633\u0637\u062d \u06f1 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0648\u0631\u0647\u200c\u0647\u0627\u06cc \u062a\u0631\u0628\u06cc\u062a Data Scientist \u0634\u0645\u0631\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n<p dir=\"rtl\">\u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0627 \u0627\u0647\u062f\u0627\u0641 \u062f\u0631 \u0627\u06cc\u0646 \u062f\u0648\u0631\u0647\u060c \u0645\u0628\u0627\u062d\u062b\u06cc \u067e\u06cc\u0631\u0627\u0645\u0648\u0646 \u0622\u0645\u0627\u0631 \u0646\u06cc\u0632 \u0645\u0648\u0631\u062f \u0628\u0631\u0631\u0633\u06cc \u0642\u0631\u0627\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f (\u0622\u0632\u0645\u0648\u0646 T\u060c \u0631\u06af\u0631\u0633\u06cc\u0648\u0646 \u0648&#8230;)<\/p>\n<ul>\n<li dir=\"rtl\" style=\"text-align: right;\">\u00a0\u0622\u063a\u0627\u0632 \u062f\u0648\u0631\u0647 \u067e\u0646\u062c\u0634\u0646\u0628\u0647 \u06f2\u06f8 \u0627\u0631\u062f\u06cc\u0628\u0647\u0634\u062a \u06f9\u06f6<\/li>\n<li dir=\"rtl\" style=\"text-align: right;\">\u0632\u0645\u0627\u0646 \u0628\u0631\u06af\u0632\u0627\u0631\u06cc: \u067e\u0646\u062c\u0634\u0646\u0628\u0647\u200c\u0647\u0627 \u06f9 \u0635\u0628\u062d \u0627\u0644\u06cc \u06f1\u06f2<\/li>\n<li dir=\"rtl\" style=\"text-align: right;\">\u0637\u0648\u0644 \u062f\u0648\u0631\u0647 \u0627\u0648\u0644: \u06f4\u06f0 \u0633\u0627\u0639\u062a<\/li>\n<li dir=\"rtl\" style=\"text-align: right;\">\u0647\u0632\u06cc\u0646\u0647: \u06f1\u06f6\u00a0\u0645\u06cc\u0644\u06cc\u0648\u0646 \u0631\u06cc\u0627\u0644 (\u062f\u0631 \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u0646\u0648\u0628\u062a)<\/li>\n<li dir=\"rtl\" style=\"text-align: right;\">\u0633\u06cc\u0644\u0627\u0628\u0633 \u062f\u0648\u0631\u0647 \u0627\u0648\u0644:<\/li>\n<\/ul>\n<div style=\"direction: ltr;\">\n<ul>\n<li>Review core SQL concepts and its mathematical roots<\/li>\n<li>CREATE TABLE IF NOT EXISTSs and enforce data integrity<\/li>\n<li>Perform effective single-table queries by using the SELECT statement<\/li>\n<li>Query multiple tables by using joins, subqueries, table expressions, and set operators<\/li>\n<li>Use advanced query techniques such as window functions, pivoting, and grouping sets<\/li>\n<li>Insert, update, delete, and merge data<\/li>\n<li>Use transactions in a concurrent environment<\/li>\n<li>Get started with programmable objects\u2013from variables and batches to user-defined functions, stored procedures, triggers, and dynamic SQL<\/li>\n<li>Query temporal and non-relational data, and output XML or JSON<\/li>\n<li>Design and implement database objects<\/li>\n<li>Optimize database objects and SQL infrastructure (Indexing, In-Memory OLTP, Partitioning, Execution Plan Anayzing, Statistics)<\/li>\n<li>Getting Started with R<\/li>\n<li>An Overvie on Statistics (Central Tendency, Variability, Distributions, Standardizing, Z-Test, T-Test, Linear Regression)<\/li>\n<li>Working with the Data<\/li>\n<li>Visualization in R<\/li>\n<\/ul>\n<\/div>\n<p><a href=\"https:\/\/evand.com\/events\/\u062f\u0648\u0631\u0647-\u0622\u0645\u0648\u0632\u0634\u06cc-sql-server-2016-r-372233\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-823 size-full\" src=\"http:\/\/65.21.105.65\/wp-content\/uploads\/sites\/3\/2017\/05\/EvandRegister.png\" alt=\"\u062b\u0628\u062a\u200c\u0646\u0627\u0645 \u062f\u0631 \u0633\u0627\u06cc\u062a \u0627\u06cc\u0648\u0646\u062f\" width=\"197\" height=\"27\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0627\u0633\u062a\u0642\u0628\u0627\u0644 \u0648 \u0645\u062d\u0628\u062a \u062f\u0648\u0633\u062a\u0627\u0646 \u0645\u062e\u062a\u0644\u0641 \u0628\u0627\u0639\u062b \u0634\u062f \u062a\u0627 \u0628\u0631\u0627\u06cc \u06cc\u06a9 \u062f\u0648\u0631\u0647 \u0622\u0645\u0648\u0632\u0634\u06cc SQL Server \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0631\u06cc\u0632\u06cc \u06a9\u0646\u0645. \u0628\u0639\u062f \u0627\u0632 SQL Server 2000 \u062f\u0648\u0631\u0647\u200c\u0647\u0627\u06cc 2005, 2008, 2012, 2014, 2016 \u0631\u0627 \u0628\u0647 \u062f\u0648 \u0635\u0648\u0631\u062a \u06a9\u0647 \u06cc\u06a9\u06cc \u0645\u0631\u06a9\u0628 \u0627\u0632 Develop+Admin \u0648 \u062f\u06cc\u06af\u0631\u06cc SSIS+SSAS \u0628\u0648\u062f\u0647 \u0627\u0633\u062a \u062a\u062f\u0631\u06cc\u0633 \u06a9\u0631\u062f\u0647\u200c\u0627\u0645 (\u0627\u0644\u0628\u062a\u0647 \u0628\u0647\u200c\u062c\u0632 \u06a9\u0627\u0631\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062a\u062e\u0635\u0635\u06cc Tuning \u0648 Recovery). \u0648\u0644\u06cc \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a &#8230; <a title=\"\u062f\u0648\u0631\u0647 \u0622\u0645\u0648\u0632\u0634\u06cc SQL Server\" class=\"read-more\" href=\"https:\/\/mesbahi.net\/fa\/blog\/1396\/02\/23\/%d8%af%d9%88%d8%b1%d9%87-%d8%a2%d9%85%d9%88%d8%b2%d8%b4%db%8c-sql-server\/\" aria-label=\"\u062f\u0631\u0628\u0627\u0631\u06c0 \u062f\u0648\u0631\u0647 \u0622\u0645\u0648\u0632\u0634\u06cc SQL Server \u0628\u06cc\u0634\u062a\u0631 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f\">\u0627\u062f\u0627\u0645\u0647<\/a><\/p>\n","protected":false},"author":1,"featured_media":824,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[5],"tags":[34,45],"class_list":["post-819","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","tag-r","tag-sqlserver"],"uagb_featured_image_src":{"full":["https:\/\/mesbahi.net\/fa\/wp-content\/uploads\/sites\/3\/2017\/05\/SQLServer-R-Training-Course.png",700,250,false],"thumbnail":["https:\/\/mesbahi.net\/fa\/wp-content\/uploads\/sites\/3\/2017\/05\/SQLServer-R-Training-Course-150x150.png",150,150,true],"medium":["https:\/\/mesbahi.net\/fa\/wp-content\/uploads\/sites\/3\/2017\/05\/SQLServer-R-Training-Course-300x107.png",300,107,true],"medium_large":["https:\/\/mesbahi.net\/fa\/wp-content\/uploads\/sites\/3\/2017\/05\/SQLServer-R-Training-Course.png",700,250,false],"large":["https:\/\/mesbahi.net\/fa\/wp-content\/uploads\/sites\/3\/2017\/05\/SQLServer-R-Training-Course.png",700,250,false],"1536x1536":["https:\/\/mesbahi.net\/fa\/wp-content\/uploads\/sites\/3\/2017\/05\/SQLServer-R-Training-Course.png",700,250,false],"2048x2048":["https:\/\/mesbahi.net\/fa\/wp-content\/uploads\/sites\/3\/2017\/05\/SQLServer-R-Training-Course.png",700,250,false]},"uagb_author_info":{"display_name":"\u0627\u0645\u06cc\u0646 \u0645\u0635\u0628\u0627\u062d\u06cc","author_link":"https:\/\/mesbahi.net\/fa\/blog\/author\/amin\/"},"uagb_comment_info":1,"uagb_excerpt":"\u0627\u0633\u062a\u0642\u0628\u0627\u0644 \u0648 \u0645\u062d\u0628\u062a \u062f\u0648\u0633\u062a\u0627\u0646 \u0645\u062e\u062a\u0644\u0641 \u0628\u0627\u0639\u062b \u0634\u062f \u062a\u0627 \u0628\u0631\u0627\u06cc \u06cc\u06a9 \u062f\u0648\u0631\u0647 \u0622\u0645\u0648\u0632\u0634\u06cc SQL Server \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0631\u06cc\u0632\u06cc \u06a9\u0646\u0645. \u0628\u0639\u062f \u0627\u0632 SQL Server 2000 \u062f\u0648\u0631\u0647\u200c\u0647\u0627\u06cc 2005, 2008, 2012, 2014, 2016 \u0631\u0627 \u0628\u0647 \u062f\u0648 \u0635\u0648\u0631\u062a \u06a9\u0647 \u06cc\u06a9\u06cc \u0645\u0631\u06a9\u0628 \u0627\u0632 Develop+Admin \u0648 \u062f\u06cc\u06af\u0631\u06cc SSIS+SSAS \u0628\u0648\u062f\u0647 \u0627\u0633\u062a \u062a\u062f\u0631\u06cc\u0633 \u06a9\u0631\u062f\u0647\u200c\u0627\u0645 (\u0627\u0644\u0628\u062a\u0647 \u0628\u0647\u200c\u062c\u0632 \u06a9\u0627\u0631\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062a\u062e\u0635\u0635\u06cc Tuning \u0648 Recovery). \u0648\u0644\u06cc \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a&hellip;","_links":{"self":[{"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/posts\/819","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/comments?post=819"}],"version-history":[{"count":1,"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/posts\/819\/revisions"}],"predecessor-version":[{"id":910,"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/posts\/819\/revisions\/910"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/media\/824"}],"wp:attachment":[{"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/media?parent=819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/categories?post=819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mesbahi.net\/fa\/wp-json\/wp\/v2\/tags?post=819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}