{"id":2285,"date":"2022-06-27T14:36:16","date_gmt":"2022-06-27T12:36:16","guid":{"rendered":"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/?p=2285"},"modified":"2022-06-27T14:37:15","modified_gmt":"2022-06-27T12:37:15","slug":"base-de-donnees-et-langage-sql","status":"publish","type":"post","link":"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/2022\/06\/27\/base-de-donnees-et-langage-sql\/","title":{"rendered":"Base de donn\u00e9es et langage SQL"},"content":{"rendered":"\n<p><strong><em>Aborder le fonctionnement des bases de donn\u00e9es gr\u00e2ce \u00e0 un sujet du baccalaur\u00e9at de la sp\u00e9cialit\u00e9 \u00ab\u00a0num\u00e9rique et sciences informatiques\u00a0\u00bb (NSI). <\/em><\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-content\/uploads\/sites\/6\/2022\/06\/Formation_eleves_SQL.jpg\" alt=\"\" class=\"wp-image-2286\" width=\"222\" height=\"137\" srcset=\"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-content\/uploads\/sites\/6\/2022\/06\/Formation_eleves_SQL.jpg 420w, https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-content\/uploads\/sites\/6\/2022\/06\/Formation_eleves_SQL-300x186.jpg 300w\" sizes=\"auto, (max-width: 222px) 100vw, 222px\" \/><\/figure><\/div>\n\n\n<p>Sch\u00e9ma relationnel, clefs primaires ou \u00e9trang\u00e8res, requ\u00eates&#8230; <strong>Jean-Alain Roddier, <\/strong>IA-IPR de math\u00e9matiques vous propose, \u00e0 partir d&rsquo;un sujet de baccalaur\u00e9at, de travailler les bases de donn\u00e9es et leur langage sp\u00e9cifique SQL (<em>Structured Query Language<\/em>) qui permet de cr\u00e9er des relations, de d\u00e9finir les liens, d\u2019alimenter et de g\u00e9rer les donn\u00e9es avant d\u2019effectuer des requ\u00eates.<\/p>\n\n\n<p class=\"has-background\" style=\"background-color:#e1f1f1\">\u2592 <a href=\"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-content\/uploads\/sites\/6\/2022\/06\/Formation-au-numerique-des-eleves-_-Le-langage-SQL.pdf\"><strong>Base de donn\u00e9es : le langage SQL.pdf<\/strong><\/a><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Aborder le fonctionnement des bases de donn\u00e9es gr\u00e2ce un sujet du baccalaur\u00e9at de la sp\u00e9cialit\u00e9 \u00ab\u00a0num\u00e9rique et sciences informatiques\u00a0\u00bb (NSI). <\/p>\n","protected":false},"author":5,"featured_media":2286,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_EventAllDay":false,"_EventTimezone":"","_EventStartDate":"","_EventEndDate":"","_EventStartDateUTC":"","_EventEndDateUTC":"","_EventShowMap":false,"_EventShowMapLink":false,"_EventURL":"","_EventCost":"","_EventCostDescription":"","_EventCurrencySymbol":"","_EventCurrencyCode":"","_EventCurrencyPosition":"","_EventDateTimeSeparator":"","_EventTimeRangeSeparator":"","_EventOrganizerID":[],"_EventVenueID":[],"_OrganizerEmail":"","_OrganizerPhone":"","_OrganizerWebsite":"","_VenueAddress":"","_VenueCity":"","_VenueCountry":"","_VenueProvince":"","_VenueState":"","_VenueZip":"","_VenuePhone":"","_VenueURL":"","_VenueStateProvince":"","_VenueLat":"","_VenueLng":"","_VenueShowMap":false,"_VenueShowMapLink":false,"footnotes":""},"categories":[32,4],"tags":[],"class_list":{"0":"post-2285","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-formation-au-numerique-des-eleves","8":"category-une","9":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-json\/wp\/v2\/posts\/2285","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-json\/wp\/v2\/comments?post=2285"}],"version-history":[{"count":2,"href":"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-json\/wp\/v2\/posts\/2285\/revisions"}],"predecessor-version":[{"id":2290,"href":"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-json\/wp\/v2\/posts\/2285\/revisions\/2290"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-json\/wp\/v2\/media\/2286"}],"wp:attachment":[{"href":"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-json\/wp\/v2\/media?parent=2285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-json\/wp\/v2\/categories?post=2285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pedagogie.ac-clermont.fr\/numerique-educatif\/wp-json\/wp\/v2\/tags?post=2285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}