Data analytics with SQL (2235.YR.015704.1)
General information
Type: |
OPT |
Curs: |
2 |
Period: |
S semester |
ECTS Credits: |
4 ECTS |
Teaching Staff:
| Group |
Teacher |
Department |
Language |
| Year 2 |
Jordi Tarda Valls |
Operaciones, Innovación y Data Sciences |
ENG |
Prerequisites
There are no prerequisites to take this course.
Previous Knowledge
No prior knowledge is required to take this course.
Course Learning Objectives
By the time the students finish the course, they should be able to
- Understand key concepts of relational database management systems;
- Understand the importance of database design through Entity- Relationship Diagrams and models;
- Design and understand queries using Structured Query Language (SQL);
- Perform a real-world database design and implementation in MySQL.
Methodology
The course requires students to be active participants in their own learning. Students are required to do some autonomous work to prepare each session. This preparatory work involves reading the content of the next session, reviewing the prior session, and doing and submitting exercises. The details of the preparatory work can be found in the website of the course. The session will build upon and leverage the preparatory work of students. Sessions will combine some lectures to review content and solve doubts, resolution of exercises, individual quizzes, team activities and challenges. This course requires that all students bring their own laptop computer to the sessions to carry out different activities.
The course consists of on-campus (face-to-face) sessions. Class attendance is compulsory. In several sessions, students will do individual quizzes and team challenges. Those individual quizzes and team challenges will be announced in the course website before the session.
Assessment criteria
Individual (in-class) quizzes 15%
Teamwork - challenges 15%
Teamwork - final project 20%
Final exam) 50%
In order to pass the course students must obtain a minimum grade of 5 (out of 10) in the Final Exam
Bibliography
Title: "SQL Cookbook"
Author: Anthony Molinaro
ISBN: 978-0596009762
Publisher: O'Reilly Media
Edition: 1st edition (2014)
Title: "Practical SQL: A Beginner's Guide to Storytelling with Data"
Author: Anthony DeBarros
ISBN: 978-1593278274
Publisher: No Starch Press
Edition: 1st edition (2018)
Title: "SQL for Data Analysis: Beginner's Guide"
Author: Galvanize Inc
ISBN: 978-1098079843
Publisher: Independently published
Edition: 1st edition (2021)
Title: "SQL in 10 Minutes a Day"
Author: Ben Forta
ISBN: 978-0672336072
Publisher: Sams Publishing
Edition: 4th edition (2019)
Title: "Head First SQL: Your Brain on SQL"
Author: Lynn Beighley
ISBN: 978-1491946945
Publisher: O'Reilly Media
Edition: 1st edition (2007)
Timetable and sections
| Group |
Teacher |
Department |
| Year 2 |
Jordi Tarda Valls |
Operaciones, Innovación y Data Sciences |
Timetable Year 2
From 2023/9/7 to 2023/10/5:
Each Thursday from 8:00 to 10:30. (Except: 2023/9/28)
From 2023/11/2 to 2023/12/7:
Each Thursday from 8:00 to 10:30.
Tuesday 2024/1/30 from 8:00 to 8:15.
