Session

Relational Databases

2 Sep 2014, 13:30

Description

Throughout the course, the students will implement a full database application with safe and efficient methods, based on the concepts learned. Additionally, where necessary, pointers to the NoSQL/non-relational database sessions with MongoDB and Hadoop are given.

Basic understanding of Linux and programming (at least C or Python) is required for this session.

The agenda is as follows:

Part 1: The basics

  • Database management systems - What/How/Why

  • The relational data model - Modeling languages

  • Structured Query Language (SQL) - The basics


Part 2: Safe use of databases

  • ACID - Making sure your data stays safe

  • Transactions, race conditions, deadlocks

  • SQL Injection - Malicious user requests


Part 3: Efficient use of databases

  • Query plans

  • Indexing

  • Partitioning


Part 4: Finishing up

  • Application development with a database backend

  • Questions/Answers

Presentation Materials

There are no materials yet.
Building timetable...
Your browser is out of date!

Update your browser to view this website correctly. Update my browser now

×