If you have more data than you can easily process with standard office software, it’s a good idea to consider specialised solutions such as databases. In this course, you will learn the basics of how to develop and use these tools, from the well-established relational databases, SQL, to modern systems for processing very large amounts of data. Key points are illustrated with practical examples.
Content
- relational databases,
- NoSQL databases,
- tools for working with databases,
- the SQL language,
- data processing,
- queries and optimisation,
- the SQL language,
- The ORM abstraction,
- comparing the features of open source databases (mysql, postgresql, sqlite),
- Security (SQL Injections).
Learning objectives
- know how to store data and use databases,
- know the different (paid and free) databases and the tools to work with them,
- be familiar with the complexity and power of the SQL programming language.
Target group
- service designers,
- R&D experts,
- technical support experts and consultants.