Introduction to Databases (2235.YR.005558.1)

General information

Type:	OBL	Curs:	1	Period:	S semester
ECTS Credits:	null ECTS

Teaching Staff:

MySQL should be installed

None

Nowadays, we live in a world of data that is increasingly important for companies and organizations. This data is found in different forms such as numbers, words, measurements, observations, images ... Organizations usually store relevant information to them in databases, which can mainly be relational or non-relational. For example, data can be stored in tables and rows (that is, relational databases such as MySQL) or in files (that is, non-relational databases such as MongoDB).

This course is an introduction to relational and non-relational databases for business analysis. You will learn how these databases work, how to use diagrams to show relationships in a relational database and how to check them. Finally, you will learn the different types of non-relational database and what is the best in what situation.

At the end of this course, you will have different tools to obtain data stored in these databases, as well as how this data is stored which will give you the first step to become a successful data scientist.

1. SQL: The basics

2. SQL: Using a database

3. SQL: Querries

4. Non-SQL: The basics

5. Non-SQL: Using a database

6. Final Exercise

Chodorow, K. (2013). MongoDB: The Definitive Guide: Powerful and Scalable Data Storage. " O'Reilly Media, Inc.".
Stonebraker, M. (2010). SQL databases v. NoSQL databases. Communications of the ACM, 53(4), 10-11.
Suehring, S. (2002). MySQL bible. John Wiley & Sons, Inc.