Course material
created by nikos dimitrakas and others
LecturesThis page contains lecture slides from some of the lectures I have given during the past years. Only the latest version of each lecture is available here. Some of the lecture slides are in Swedish, but due to the technical nature of the content, this may not be so important. Introduction to Databases, the Relational Model, NormalisationThis lecture introduces the fundamentals of databases and database management, as well as the relational model and the process of normalisation (up to 3NF). Database Management SystemsThis lecture covers security and concurrency/transaction management issues within database management systems. Conceptual ModelingThis lecture covers the basics in conceptual modeling, with special focus on data modeling that should eventually lead to a database. Relational Database DesignThis lecture focuses on the transformation process of a conceptual model into a relational database model. Relational AlgebraThis lecture covers the operations of the basic relational algebra. SQLThis lecture covers SQL, with the main focus on the DDL and DML from the SQL92 standard. This is an alternative version with some extra slides on other query languages. Embedded QLThis lecture looks at SQL and OQL and how they can by embedded programming languages. The main focus is on JDBC, SQLJ and Jasmine ODQL in Java. Embedded SQL in JavaThis lecture focuses on embedded SQL in Java (JDBC). Latest Swedish version: Slides powerpoint XML Query LanguagesThis lecture covers some of the query languages used for working with XML and also for transforming relational data to XML and vice versa. A big part of the lecture focuses on XPath and XQuery, as well as on SQL/XML (SQL2003c). This lecture is a Swedish version of the previous one, with an introduction to XML, but without the SQL/XML parts. Semi-structured data and XML, DTD, XML SchemaThis lecture covers the basics of semi-structured data and XML, including DTD and XML Schema. It also covers the different representation models for XML. Latest Swedish version: Slides powerpoint Semi-structured data and XMLThis lecture covers the basics of semi-structured data and XML including the different representation models for XML. Latest English version: Slides powerpoint DTD and XML SchemaThis lecture covers DTD and XML Schema. Latest English version: Slides powerpoint Query languages for semi-structured data and XMLThis lecture covers languages for traversing and querying semi-structured data and XML data. The main focus is on XPath and XQuery, with a short introduction to Lorel. Latest Swedish version: Slides powerpoint Latest English version: Slides powerpoint SQL/XMLA lecture about the XML features of relational databases according to the SQL 2003 and SQL 2006 standards. Latest Swedish version: Slides powerpoint Latest English version: Slides powerpoint XSLTA lecture about XSLT. XSLT 1, XSLT 2 and XSLT 3 are covered Latest Swedish version: Slides powerpoint Latest English version: Slides powerpoint XML in Oracle 19c, IBM DB2 11.5 & Microsoft SQL Server 2019This lecture focuses on the non-standard XML facilities of three major DBMSs and also discusses the degree of support of features included in the SQL standard. Latest Swedish version: Slides powerpoint XML in IBM DB2 11.5This lecture focuses on the non-standard XML facilities of IBM DB2 and also discusses the degree of support of features included in the SQL standard. Latest English version: Slides powerpoint XML in Oracle Database 21cThis lecture focuses on the non-standard XML facilities of Oracle Database and also discusses the degree of support of features included in the SQL standard. Latest English version: Slides powerpoint XML in Microsoft SQL Server 2022This lecture focuses on the non-standard XML facilities of Microsoft SQL Server and also discusses the degree of support of features included in the SQL standard. Latest English version: Slides powerpoint XML-based languages & RDF/RDFSThis lecture discusses several XML-based languages like MathML, CML and SVG and also covers RDF and RDFS both in graph notation and XML notation. Latest Swedish version: Slides powerpoint XML-based languages and usages of XML and SSDThis lecture discusses several XML-based languages and common areas where SSD and XML are used. Latest English version: Slides powerpoint JSON & JSON SchemaLatest English version: Slides powerpoint Temporal Databases & Multimedia DatabasesThis lecture covers two separate subjects. The first part discusses different.pattern of modeling time into a database, while the second part discusses multimedia in databases with focus on meta data and performance issues. System ArchitecturesThis lecture discusses the different technologies and architectures used in information systems. |
This site has been created and is maintained by nikos dimitrakas. Powered by Windows and Jboss Any questions about the site as well as errors and omissions can be sent to nikos@dsv.su.se |