Relational Databases

Not scheduled
20m
Big Data and Storage Systems

Speaker

Mario Lassnig (CERN)

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.
Your browser is out of date!

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

×