لغات البرمجة (SQL) - Collepedia

هذه اللغة والتي هي اختصار ل Structured Query Language – لغة الاستعلام المهيكلة – أيضا لا تصنف كلغة برمجة بالشكل الصريح الذي نعرفه في اللغات الأخرى مثل C++ و Python، فهي تصنف كلغة استعلام قواعد البيانات – Database Query Language – وهي تستخدم بشكل أساسي في التعامل مع قواعد البيانات والتلاعب بها بطرق مختلفة، فنجد أنها تستخدم في تحديث البيانات، ادراج سجلات جديدة في قواعد البيانات، حذف التسجيلات والبيانات، استخلاص البيانات والبحث عنها، انشاء جداول لتخزين البيانات، وتأمين قواعد البيانات وانشاء نسخ احتياطية منها. ميزة هذه اللغة الأساسية مثل بايثون (نتكلم عنها في النقطة التالية)، وهي أنها شديدة السهولة في التعلم والكتابة، حيث إن أوامرها تشبه اللغة الإنجليزية: Select, Add, Create، الخ. تم تطوير هذه اللغة من قبل باحثين في شركة IBM العالمية. للدخول في عالم SQL، ننصح بقراءة هذا الكتاب عن تصميم قواعد البيانات.

Post a Comment

قواعد نشر التعليقات:

1- لا إساءة أو مشاجرات
2- التعليقات الإيجابية والإقتراحات والآراء فقط

Join the conversation

Join the conversation

<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/984859869-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY79zrDV9PFy6pQo0qV1n1muaKHYtw:1732346130571';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d1222315998077983710','//colle-pedia.blogspot.com/p/sql-collepedia.html?hl\x3den','1222315998077983710');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '1222315998077983710', 'title': 'Collepedia', 'url': 'https://colle-pedia.blogspot.com/p/sql-collepedia.html?hl\x3den', 'canonicalUrl': 'https://colle-pedia.blogspot.com/p/sql-collepedia.html', 'homepageUrl': 'https://colle-pedia.blogspot.com/?hl\x3den', 'searchUrl': 'https://colle-pedia.blogspot.com/search', 'canonicalHomepageUrl': 'https://colle-pedia.blogspot.com/', 'blogspotFaviconUrl': 'https://colle-pedia.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'G-MS2QWX8KST', 'analytics4': true, 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Collepedia - Atom\x22 href\x3d\x22https://colle-pedia.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Collepedia - RSS\x22 href\x3d\x22https://colle-pedia.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Collepedia - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/1222315998077983710/posts/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-5736594999626764', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/d78375fb222d99b3', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': '\u0642\u0631\u0627\u0621\u0629 \u0627\u0644\u0645\u0632\u064a\u062f', 'pageType': 'static_page', 'pageId': '7183733728330037887', 'pageName': '\u0644\u063a\u0627\u062a \u0627\u0644\u0628\u0631\u0645\u062c\u0629 (SQL) - Collepedia', 'pageTitle': 'Collepedia: \u0644\u063a\u0627\u062a \u0627\u0644\u0628\u0631\u0645\u062c\u0629 (SQL) - Collepedia', 'metaDescription': ''}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': '\u0644\u063a\u0627\u062a \u0627\u0644\u0628\u0631\u0645\u062c\u0629 (SQL) - Collepedia', 'description': '\u0643\u0648\u0644\u064a\u0628\u064a\u062f\u064a\u0627 \u0623\u0648 Collepedia \u0647\u0648 \u0645\u0648\u0642\u0639 \u0625\u0639\u0644\u0627\u0645\u064a \u064a\u0642\u062f\u0645 \u0645\u062d\u062a\u0648\u0649 \u062a\u0639\u0644\u064a\u0645\u064a \u0648\u062b\u0642\u0627\u0641\u064a \u0641\u064a \u0645\u062c\u0627\u0644\u0627\u062a \u0645\u062a\u0639\u062f\u062f\u0629.', 'url': 'https://colle-pedia.blogspot.com/p/sql-collepedia.html?hl\x3den', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': true, 'isPost': false, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'pageId': 7183733728330037887}}, {'name': 'widgets', 'data': [{'title': 'Collepedia (Header)', 'type': 'Header', 'sectionId': 'sec_Header_Title', 'id': 'Header01'}, {'title': '\u062c\u0631\u0628 \x27\u062a\u0643\u0646\u0648\u0644\u0648\u062c\u064a\u0627\x27', 'type': 'BlogSearch', 'sectionId': 'sec_Header_Search', 'id': 'BlogSearch01'}, {'title': 'Header Icon', 'type': 'TextList', 'sectionId': 'sec_Header_Icon', 'id': 'TextList01'}, {'title': 'Contributors', 'type': 'Profile', 'sectionId': 'sec_Header_Icon', 'id': 'Profile01'}, {'title': 'Navigation Menu', 'type': 'HTML', 'sectionId': 'sec_Nav_Widgets_1', 'id': 'HTML01'}, {'title': 'Additional Menu', 'type': 'PageList', 'sectionId': 'sec_Nav_Widgets_2', 'id': 'PageList02'}, {'title': '', 'type': 'HTML', 'sectionId': 'sec_Horizontal-Ad', 'id': 'HTML1'}, {'title': 'Under Header Ad', 'type': 'LinkList', 'sectionId': 'sec_Horizontal-Ad', 'id': 'LinkList91'}, {'title': '\u0645\u0642\u0627\u0644 \u0645\u062b\u0628\u062a', 'type': 'FeaturedPost', 'sectionId': 'sec_Top_Widgets', 'id': 'FeaturedPost01', 'postId': '9086625493009997649'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'sec_Main_Widgets', 'id': 'Blog01', 'posts': [{'id': '7183733728330037887', 'title': '\u0644\u063a\u0627\u062a \u0627\u0644\u0628\u0631\u0645\u062c\u0629 (SQL) - Collepedia', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': '\u062a\u0645 \u0627\u0644\u0646\u0634\u0631 \u0628\u0648\u0627\u0633\u0637\u0629'}, {'name': 'timestamp', 'label': '\u0641\u064a '}, {'name': 'comments', 'label': '\u062a\u0639\u0644\u064a\u0642(\u0627\u062a)'}, {'name': 'icons', 'label': ''}, {'name': 'share', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': '\u0641\u064a \u0642\u0633\u0645'}]}, {'regionName': 'footer3', 'items': [{'name': 'location', 'label': '\u0627\u0644\u0645\u0648\u0642\u0639'}]}], 'allBylineItems': [{'name': 'author', 'label': '\u062a\u0645 \u0627\u0644\u0646\u0634\u0631 \u0628\u0648\u0627\u0633\u0637\u0629'}, {'name': 'timestamp', 'label': '\u0641\u064a '}, {'name': 'comments', 'label': '\u062a\u0639\u0644\u064a\u0642(\u0627\u062a)'}, {'name': 'icons', 'label': ''}, {'name': 'share', 'label': ''}, {'name': 'labels', 'label': '\u0641\u064a \u0642\u0633\u0645'}, {'name': 'location', 'label': '\u0627\u0644\u0645\u0648\u0642\u0639'}]}, {'title': '\u0627\u0644\u0645\u0642\u0627\u0644\u0627\u062a \u0627\u0644\u0631\u0627\u0626\u062c\u0629', 'type': 'PopularPosts', 'sectionId': 'sec_Side_Widgets', 'id': 'PopularPosts00', 'posts': [{'title': '\u0634\u0631\u0643\u0629 Realme \u0648\u0645\u0646\u062a\u062c\u0627\u062a\u0647\u0627', 'id': 1212998083457424289}, {'title': '20 \u062e\u0637\u0648\u0629 \u0644\u062a\u0639\u0644\u0645 \u0627\u0644\u0628\u0631\u0645\u062c\u0629 \u0645\u0646 \u0627\u0644\u0628\u062f\u0627\u064a\u0629 \u0625\u0644\u0649 \u0627\u0644\u0627\u062d\u062a\u0631\u0627\u0641', 'id': 9086625493009997649}, {'title': '\u0645\u0642\u062f\u0645\u0629 \u0639\u0646 \u0644\u063a\u0629 C++', 'id': 1840457507178168151}, {'title': '\u0628\u0631\u0645\u062c\u0629 C++: \u0627\u0644\u0645\u0641\u0627\u0647\u064a\u0645 \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0648\u0627\u0644\u0623\u0645\u062b\u0644\u0629 \u0627\u0644\u0639\u0645\u0644\u064a\u0629', 'id': 2336971412305513375}, {'title': '\u0643\u062a\u0627\u0628 \u0623\u0646\u062a \u0644\u0633\u062a \u0641\u0627\u0634\u0644\u0627\u064b.. \u0627\u0633\u062a\u064a\u0642\u0638 \u0648\u062d\u0642\u0642 \u062d\u0644\u0645\u0643 - \u062f/ \u0645\u062d\u0645\u062f \u0631\u0628\u064a\u0639 \u0623\u062d\u0645\u062f \u062d\u0633\u064a\u0646', 'id': 6226956125317117508}, {'title': '\u062a\u064a\u0633\u0644\u0627 - \u0631\u0648\u0627\u062f \u0627\u0644\u062a\u0643\u0646\u0648\u0644\u0648\u062c\u064a\u0627 \u0641\u064a \u0645\u062c\u0627\u0644 \u0627\u0644\u0633\u064a\u0627\u0631\u0627\u062a \u0627\u0644\u0643\u0647\u0631\u0628\u0627\u0626\u064a\u0629', 'id': 2167443423774290965}, {'title': '\u0641\u0648\u0627\u0626\u062f \u0628\u0631\u0627\u0639\u0645 \u0627\u0644\u062d\u0644\u0628\u0629', 'id': 2872342378290798505}, {'title': '\u0628\u0646\u0627\u0621 \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u062d\u0627\u062f\u062b\u0629 \u0628\u0633\u064a\u0637 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0628\u0627\u064a\u062b\u0648\u0646 - \u0645\u0634\u0627\u0631\u064a\u0639 \u0643\u0648\u0644\u064a\u0628\u064a\u062f\u064a\u0627', 'id': 3296594262926877742}, {'title': '\u0628\u0648\u0627\u0628\u0629 \u062c\u0647\u0646\u0645 \u0641\u064a \u062a\u0631\u0643\u0645\u0627\u0646\u0633\u062a\u0627\u0646', 'id': 3388718203394639507}, {'title': '\u0645\u0642\u062f\u0645\u0629 \u0639\u0646 \u0644\u063a\u0629 \u0628\u0631\u0645\u062c\u0629 Go', 'id': 4324374167655137315}]}, {'title': '\u0627\u0644\u0623\u0642\u0633\u0627\u0645', 'type': 'Label', 'sectionId': 'sec_Side_Widgets', 'id': 'Label00'}, {'title': '\u062c\u062f\u0648\u0644 \u0627\u0644\u0645\u062d\u062a\u0648\u064a\u0627\u062a', 'type': 'HTML', 'sectionId': 'sec_Side_Widgets', 'id': 'HTML11'}, {'title': 'Take me back', 'type': 'HTML', 'sectionId': 'sec_Error_404', 'id': 'HTML404'}, {'title': 'Organization Name [BlogTitle]', 'type': 'Image', 'sectionId': 'sec_Footer_Widgets_1', 'id': 'Image0000002'}, {'title': 'Credit', 'type': 'HTML', 'sectionId': 'sec_Footer_Credit', 'id': 'HTML88'}, {'title': 'Mobile Menu', 'type': 'TextList', 'sectionId': 'sec_Mobile_Menu', 'id': 'TextList99'}, {'title': '\u0627\u0644\u0623\u0642\u0633\u0627\u0645', 'type': 'Label', 'sectionId': 'sec_Theme_Hidden', 'id': 'Label0000001'}, {'title': 'Bi\u1ec3u m\u1eabu li\xean h\u1ec7', 'type': 'ContactForm', 'sectionId': 'sec_Theme_Hidden', 'id': 'ContactForm0000001'}, {'title': 'Firebase Configurations', 'type': 'LinkList', 'sectionId': 'sec_Addon_Widgets', 'id': 'LinkList0000002'}, {'title': 'Progressive Web App', 'type': 'LinkList', 'sectionId': 'sec_Addon_Widgets', 'id': 'LinkList11'}, {'title': 'Cookie Consent [NoTitle]', 'type': 'LinkList', 'sectionId': 'sec_Addon_Widgets', 'id': 'LinkList7'}, {'title': 'Oops!', 'type': 'HTML', 'sectionId': 'sec_Addon_Widgets', 'id': 'HTML22'}, {'title': 'AdBlock Detected!', 'type': 'HTML', 'sectionId': 'sec_Addon_Widgets', 'id': 'HTML23'}, {'title': 'Country Block', 'type': 'HTML', 'sectionId': 'sec_Addon_Widgets', 'id': 'HTML26'}, {'title': 'Image Uploader', 'type': 'Image', 'sectionId': 'sec_Addon_Widgets', 'id': 'Image5'}]}]);
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header01', 'sec_Header_Title', document.getElementById('Header01'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogSearchView', new _WidgetInfo('BlogSearch01', 'sec_Header_Search', document.getElementById('BlogSearch01'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_TextListView', new _WidgetInfo('TextList01', 'sec_Header_Icon', document.getElementById('TextList01'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ProfileView', new _WidgetInfo('Profile01', 'sec_Header_Icon', document.getElementById('Profile01'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML01', 'sec_Nav_Widgets_1', document.getElementById('HTML01'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList02', 'sec_Nav_Widgets_2', document.getElementById('PageList02'), {'title': 'Additional Menu', 'links': [{'isCurrentPage': false, 'href': '/p/sitemap.html', 'title': 'Sitemap'}, {'isCurrentPage': false, 'href': '/p/disclaimer.html', 'title': 'Disclaimer'}, {'isCurrentPage': false, 'href': '/p/privacy.html', 'title': 'Privacy'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'sec_Horizontal-Ad', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList91', 'sec_Horizontal-Ad', document.getElementById('LinkList91'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost01', 'sec_Top_Widgets', document.getElementById('FeaturedPost01'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog01', 'sec_Main_Widgets', document.getElementById('Blog01'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2646514562-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts00', 'sec_Side_Widgets', document.getElementById('PopularPosts00'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label00', 'sec_Side_Widgets', document.getElementById('Label00'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML11', 'sec_Side_Widgets', document.getElementById('HTML11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML404', 'sec_Error_404', document.getElementById('HTML404'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image0000002', 'sec_Footer_Widgets_1', document.getElementById('Image0000002'), {'resize': true}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML88', 'sec_Footer_Credit', document.getElementById('HTML88'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_TextListView', new _WidgetInfo('TextList99', 'sec_Mobile_Menu', document.getElementById('TextList99'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label0000001', 'sec_Theme_Hidden', document.getElementById('Label0000001'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm0000001', 'sec_Theme_Hidden', document.getElementById('ContactForm0000001'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'Bi\u1ec3u m\u1eabu li\xean h\u1ec7', 'blogId': '1222315998077983710', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AOuZoY444IgkqsBHCHGGehPEOh5u_YeO2w:1732346130572', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList0000002', 'sec_Addon_Widgets', document.getElementById('LinkList0000002'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList11', 'sec_Addon_Widgets', document.getElementById('LinkList11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList7', 'sec_Addon_Widgets', document.getElementById('LinkList7'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML22', 'sec_Addon_Widgets', document.getElementById('HTML22'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML23', 'sec_Addon_Widgets', document.getElementById('HTML23'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML26', 'sec_Addon_Widgets', document.getElementById('HTML26'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image5', 'sec_Addon_Widgets', document.getElementById('Image5'), {'resize': false}, 'displayModeFull'));
</script>
</body>