Intro to SQL & Non-SQL Databases (18PBA40101)
General information
Type: |
OB |
Curs: |
1 |
Period: |
S semester |
ECTS Credits: |
0 ECTS |
Teaching Staff:
| Group |
Teacher |
Department |
Language |
| Sec: A |
Albert Armisen Morell |
Operaciones, Innovación y Data Sciences |
ENG |
| Group |
Teacher |
Department |
Language |
| Sec: B |
Albert Armisen Morell |
Operaciones, Innovación y Data Sciences |
ENG |
Prerequisites
MySQL should be installed
MongoDB should be installed
COURSE CONTRIBUTION TO PROGRAM
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.
Course Learning Objectives
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.
CONTENT
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 |
Methodology
Assessment criteria
Attendance, participation and contributions to class 20%
Exercises 80%
Bibliography
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.
Timetable and sections
| Group |
Teacher |
Department |
| Sec: A |
Albert Armisen Morell |
Operaciones, Innovación y Data Sciences |
Timetable Sec: A
From 2018/9/10 to 2018/9/14:
Monday and Friday from 9:30 to 12:30.
Each Thursday from 14:00 to 17:00.
| Group |
Teacher |
Department |
| Sec: B |
Albert Armisen Morell |
Operaciones, Innovación y Data Sciences |
Timetable Sec: B
From 2018/9/10 to 2018/9/14:
Monday, Wednesday and Friday from 14:00 to 17:00.
