80 likes | 96 Views
Learn about HTTP, HTML, JavaScript, SQL, XML, ER modeling, and XML vocabularies. Understand their uses in web development and data management.
E N D
what is HTTP? - the underlying communication protocol used by the www - common HTTP headers?
what is HTML? - a mark-up vocabulary how is HTML used? - to format documents used on the www
what is JavaScript? - a scripting language implemented in browsers what is JavaScript used for? - to implement browser side logic (ajax, localStorage(html5)) - to manipulate the DOM
what is a database? - a repository of data - schema, api, ++ - types of DB – relational, xml, key/value pairs what is SQL - a query language implemented by all RDBMS - two parts – DDL & DML - know basic SQL syntax (select, join, group by, order by etc.)
what is ER modeling? • to diagrammatically model data entities & relationships • conceptual (high-level) models (m<->m allowed) • logical (low-level) models (m<->m resolved) • identify PK’s and FK’s • use case tools -> generate code (qsee, xml-modeller)
what is xml? - a grammar -> generates -> vocabularies - well-formed (<-machine-processable) + valid (<-schema) - deductive chains <-> RDF(<-FOAF(<-Ontologies(owl)) example xml vocabularies? - RSS, KML, ATOM, RDF(<-FOAF<-Ontologies(owl)) + 1000's of domain-specific others why is xml useful? - rich data -> data + schema -> semantics
what is xml used for? - messaging over HTTP - localised inter-process messaging - rich-data repositories (post-relational dbs) - mapping other reposotories (rdbms, $key/$value stores, RDF triples) - browser-side data stores (html5 localStorage)
Understand & apply conceptual / logical modelling from a given scenario • Understand and explain how the following technologies are used -> RSS, SQL, HTML, XML, XSLT, JavaScript, PHP • Show appreciation of the business environment and possible constraints – costs, skills, applying business rules, security, accessibility, integration, use of services etc. etc.