{"id":160,"date":"2012-03-23T16:33:53","date_gmt":"2012-03-23T16:33:53","guid":{"rendered":"http:\/\/www.aerian.fr\/?page_id=160"},"modified":"2018-02-17T17:40:19","modified_gmt":"2018-02-17T16:40:19","slug":"if4-bdc","status":"publish","type":"page","link":"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/","title":{"rendered":"IF4-BDC"},"content":{"rendered":"<p><\/p>\n<h2>Introduction<\/h2>\n<p>Fourth year unit in computer science at ESIEE Paris. This course cover an overall of database system in SQL language and relational language.<\/p>\n<p>Unit taught by Fr\u00e9d\u00e9ric MARCOMBES.<\/p>\n<p>This unit cover also a compilation project lead by Laurent Najman. All the materials given are in French (except for Standford course).<\/p>\n<p><a href=\"http:\/\/www.aerian.fr\/cours\/Esiee\/I4\/BDC\/IF4-BDC.html\">Unit summarize<\/a><\/p>\n<h2>Courses and Practicals<\/h2>\n<p>All the materials given are in French and printed on sheets of paper. In order to give alternative solution, we recommend the course given by Standford university on database system dispensed by Jennifer Widom.<\/p>\n<p><a href=\"https:\/\/online.stanford.edu\/course\/databases-self-paced\" class=\"broken_link\">Standford database course<\/a><\/p>\n<h2>Practicals<\/h2>\n<p><a href=\"http:\/\/www.aerian.fr\/cours\/Esiee\/I4\/BDC\/TP\/bdc-rapport.pdf\">Rapport TP1&amp;2<\/a><\/p>\n<p><a href=\"http:\/\/www.aerian.fr\/cours\/Esiee\/I4\/BDC\/TP\/scripts\/tp1.sql\">Script TP1<\/a><\/p>\n<p><a href=\"http:\/\/www.aerian.fr\/cours\/Esiee\/I4\/BDC\/TP\/scripts\/tp2.sql\">Script TP2<\/a><\/p>\n<h2>Subjects<\/h2>\n<p><a href=\"http:\/\/www.aerian.fr\/cours\/Esiee\/I4\/BDC\/IF4-BDC_sujet_2004_2009.zip\">Annales 2004-2009<\/a><\/p>\n<h2>Project<\/h2>\n<p><a href=\"http:\/\/www.aerian.fr\/cours\/Esiee\/I4\/BDC\/Projet\/sujet.pdf\">Sujet du projet 2011\/2012<\/a><\/p>\n<p><a href=\"http:\/\/www.aerian.fr\/cours\/Esiee\/I4\/BDC\/Projet\/LexAndYaccTutorial.pdf\">Tutoriel YACC et LEX<\/a><\/p>\n<p><a href=\"http:\/\/www.aerian.fr\/cours\/Esiee\/I4\/BDC\/Compilation\/bdc-marleix-jacquemin.tgz\">Source du projet<\/a><\/p>\n<h2>Sources<\/h2>\n<p>All the materials posted on this website belongs to the credit of their respective authors.<\/p>","protected":false},"excerpt":{"rendered":"<p>Introduction Fourth year unit in computer science at ESIEE Paris. This course cover an overall of database system in SQL language and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":35,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"class_list":["post-160","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>IF4-BDC - Aerian.fr<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IF4-BDC - Aerian.fr\" \/>\n<meta property=\"og:description\" content=\"Introduction Fourth year unit in computer science at ESIEE Paris. This course cover an overall of database system in SQL language and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/\" \/>\n<meta property=\"og:site_name\" content=\"Aerian.fr\" \/>\n<meta property=\"article:modified_time\" content=\"2018-02-17T16:40:19+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@LinceAerian\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/\",\"url\":\"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/\",\"name\":\"IF4-BDC - Aerian.fr\",\"isPartOf\":{\"@id\":\"https:\/\/www.aerian.fr\/en\/#website\"},\"datePublished\":\"2012-03-23T16:33:53+00:00\",\"dateModified\":\"2018-02-17T16:40:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[[\"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/\"]]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.aerian.fr\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ESIEE\",\"item\":\"https:\/\/www.aerian.fr\/en\/esiee\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"4\u00e8me Ann\u00e9e\",\"item\":\"https:\/\/www.aerian.fr\/en\/esiee\/i4\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"IF4-BDC\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.aerian.fr\/en\/#website\",\"url\":\"https:\/\/www.aerian.fr\/en\/\",\"name\":\"Aerian.fr\",\"description\":\"Welcome to Aerian.fr\",\"publisher\":{\"@id\":\"https:\/\/www.aerian.fr\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.aerian.fr\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.aerian.fr\/en\/#organization\",\"name\":\"Aerian.fr\",\"url\":\"https:\/\/www.aerian.fr\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.aerian.fr\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.aerian.fr\/wp-content\/uploads\/2012\/01\/logo.png\",\"contentUrl\":\"https:\/\/www.aerian.fr\/wp-content\/uploads\/2012\/01\/logo.png\",\"width\":667,\"height\":522,\"caption\":\"Aerian.fr\"},\"image\":{\"@id\":\"https:\/\/www.aerian.fr\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/LinceAerian\",\"https:\/\/www.linkedin.com\/in\/marleixmathieu\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"IF4-BDC - Aerian.fr","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/","og_locale":"en_US","og_type":"article","og_title":"IF4-BDC - Aerian.fr","og_description":"Introduction Fourth year unit in computer science at ESIEE Paris. This course cover an overall of database system in SQL language and [&hellip;]","og_url":"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/","og_site_name":"Aerian.fr","article_modified_time":"2018-02-17T16:40:19+00:00","twitter_card":"summary_large_image","twitter_site":"@LinceAerian","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/","url":"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/","name":"IF4-BDC - Aerian.fr","isPartOf":{"@id":"https:\/\/www.aerian.fr\/en\/#website"},"datePublished":"2012-03-23T16:33:53+00:00","dateModified":"2018-02-17T16:40:19+00:00","breadcrumb":{"@id":"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":[["https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/"]]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.aerian.fr\/en\/esiee\/i4\/if4-bdc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.aerian.fr\/en\/"},{"@type":"ListItem","position":2,"name":"ESIEE","item":"https:\/\/www.aerian.fr\/en\/esiee\/"},{"@type":"ListItem","position":3,"name":"4\u00e8me Ann\u00e9e","item":"https:\/\/www.aerian.fr\/en\/esiee\/i4\/"},{"@type":"ListItem","position":4,"name":"IF4-BDC"}]},{"@type":"WebSite","@id":"https:\/\/www.aerian.fr\/en\/#website","url":"https:\/\/www.aerian.fr\/en\/","name":"Aerian.fr","description":"Welcome to Aerian.fr","publisher":{"@id":"https:\/\/www.aerian.fr\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.aerian.fr\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.aerian.fr\/en\/#organization","name":"Aerian.fr","url":"https:\/\/www.aerian.fr\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.aerian.fr\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.aerian.fr\/wp-content\/uploads\/2012\/01\/logo.png","contentUrl":"https:\/\/www.aerian.fr\/wp-content\/uploads\/2012\/01\/logo.png","width":667,"height":522,"caption":"Aerian.fr"},"image":{"@id":"https:\/\/www.aerian.fr\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/LinceAerian","https:\/\/www.linkedin.com\/in\/marleixmathieu"]}]}},"_links":{"self":[{"href":"https:\/\/www.aerian.fr\/en\/wp-json\/wp\/v2\/pages\/160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aerian.fr\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.aerian.fr\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.aerian.fr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aerian.fr\/en\/wp-json\/wp\/v2\/comments?post=160"}],"version-history":[{"count":21,"href":"https:\/\/www.aerian.fr\/en\/wp-json\/wp\/v2\/pages\/160\/revisions"}],"predecessor-version":[{"id":2085,"href":"https:\/\/www.aerian.fr\/en\/wp-json\/wp\/v2\/pages\/160\/revisions\/2085"}],"up":[{"embeddable":true,"href":"https:\/\/www.aerian.fr\/en\/wp-json\/wp\/v2\/pages\/35"}],"wp:attachment":[{"href":"https:\/\/www.aerian.fr\/en\/wp-json\/wp\/v2\/media?parent=160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}