{"id":28655,"date":"2024-07-11T19:28:01","date_gmt":"2024-07-11T16:28:01","guid":{"rendered":"https:\/\/codeicator.com\/?post_type=lp_course&#038;p=28655"},"modified":"2024-07-14T16:35:00","modified_gmt":"2024-07-14T13:35:00","slug":"mysql-database-management","status":"publish","type":"lp_course","link":"https:\/\/codeicator.com\/ar\/courses\/mysql-database-management\/","title":{"rendered":"\u062a\u0635\u0645\u064a\u0645 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 MySQL"},"content":{"rendered":"<p><strong>\u0627\u0644\u0648\u0635\u0641:<\/strong><\/p>\n<p>\u0633\u064a\u062a\u0639\u0644\u0645 \u0627\u0644\u0637\u0627\u0644\u0628 \u0623\u0633\u0627\u0633\u064a\u0627\u062a \u0646\u0638\u0645 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0639\u0644\u0627\u0626\u0642\u064a\u0629 (MySQL)\u060c \u0648 \u0646\u0645\u0648\u0630\u062c \u0627\u0644\u0646\u0645\u0630\u062c\u0629 \u0627\u0644\u0639\u0644\u0627\u0626\u0642\u064a ERD Model. \u0643\u0645\u0627 \u0633\u064a\u062a\u0639\u0644\u0645 \u062a\u062d\u0648\u064a\u0644 ERD  \u0627\u0644\u0649 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0641\u0647\u0645 \u0623\u0646\u0648\u0627\u0639 \u0627\u0644\u0643\u064a\u0627\u0646\u0627\u062a \u0648\u0627\u0644\u0639\u0644\u0627\u0642\u0627\u062a \u0628\u064a\u0646\u0647\u0627.<\/p>\n<p><strong>\u0633\u0648\u0641 \u062a\u062a\u0639\u0644\u0645:<\/strong><\/p>\n<ul>\n<li>\u0646\u0645\u0648\u0630\u062c  ERD<\/li>\n<li>\u0623\u0633\u0627\u0633\u064a\u0627\u062a MySQL \u0648\u0643\u064a\u0641\u064a\u0629 \u0625\u0639\u062f\u0627\u062f \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0627\u0644\u0628\u062f\u0627\u064a\u0629.<\/li>\n<li>\u062a\u0635\u0645\u064a\u0645 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/li>\n<li>\u062a\u0637\u0628\u064a\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/li>\n<li>\u0623\u0646\u0648\u0627\u0639 \u0623\u0648\u0627\u0645\u0631 \u0627\u0644 (DDL, DML, DCL,TCL, DQL )<\/li>\n<li>\u0643\u062a\u0627\u0628\u0629 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a SQL \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629 \u0648\u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629.<\/li>\n<li>\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0641\u0647\u0627\u0631\u0633 \u0644\u062a\u062d\u0633\u064a\u0646 \u0627\u0644\u0623\u062f\u0627\u0621.<\/li>\n<li>\u0627\u0644\u0625\u062c\u0631\u0627\u0621\u0627\u062a \u0627\u0644\u0645\u062e\u0632\u0646\u0629 (Stored Procedures) \u0648\u0627\u0644\u062f\u0648\u0627\u0644 (Functions) \u0648\u0627\u0644\u0645\u0634\u063a\u0644\u0627\u062a (Triggers).<\/li>\n<li>\u0625\u062f\u0627\u0631\u0629 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646 \u0648\u062a\u0646\u0641\u064a\u0630 \u0627\u0644\u0623\u0630\u0648\u0646\u0627\u062a \u0648\u0627\u0644\u0623\u0645\u0627\u0646.<\/li>\n<\/ul>\n<h3><strong>\u0627\u0644\u0645\u062a\u0637\u0644\u0628\u0627\u062a \u0627\u0644\u0645\u0633\u0628\u0642\u0629:<br \/>\n<\/strong><\/h3>\n<ul>\n<li>\u0628\u0639\u0636 \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0627\u0644\u0645\u0633\u0628\u0642\u0629<\/li>\n<\/ul>\n<h3><\/h3>","protected":false},"excerpt":{"rendered":"<p>Description: The student will learn the basics of relational database systems (MySQL) and the relational modeling model (ERD Model). They will also learn to convert the ERD into a database and understand the types of entities and the relationships between &hellip; <\/p>","protected":false},"author":2,"featured_media":28694,"comment_status":"open","ping_status":"closed","template":"","course_category":[109,77,80],"course_tag":[],"class_list":["post-28655","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-back-end-web-development-diploma","course_category-programs","course_category-software-engineering-and-development","course"],"_links":{"self":[{"href":"https:\/\/codeicator.com\/ar\/wp-json\/wp\/v2\/lp_course\/28655","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codeicator.com\/ar\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/codeicator.com\/ar\/wp-json\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/codeicator.com\/ar\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/codeicator.com\/ar\/wp-json\/wp\/v2\/comments?post=28655"}],"version-history":[{"count":2,"href":"https:\/\/codeicator.com\/ar\/wp-json\/wp\/v2\/lp_course\/28655\/revisions"}],"predecessor-version":[{"id":28657,"href":"https:\/\/codeicator.com\/ar\/wp-json\/wp\/v2\/lp_course\/28655\/revisions\/28657"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/codeicator.com\/ar\/wp-json\/wp\/v2\/media\/28694"}],"wp:attachment":[{"href":"https:\/\/codeicator.com\/ar\/wp-json\/wp\/v2\/media?parent=28655"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/codeicator.com\/ar\/wp-json\/wp\/v2\/course_category?post=28655"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/codeicator.com\/ar\/wp-json\/wp\/v2\/course_tag?post=28655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}