Unit DATABASE LABORATORY
- Course
- Programming and management of computer systems
- Study-unit Code
- 55483706
- Curriculum
- In all curricula
- Teacher
- Ivan Mercanti
- Teachers
-
- Ivan Mercanti
- Hours
- 36 ore - Ivan Mercanti
- CFU
- 3
- Course Regulation
- Coorte 2023
- Offered
- 2023/24
- Learning activities
- Altro
- Area
- Tirocini formativi e di orientamento
- Academic discipline
- NN
- Type of study-unit
- Type of learning activities
- Attività formativa monodisciplinare
- Language of instruction
- Italian.
- Contents
- Data and tables: organizing the data. SELECT: retrieve data. DELETE and UPDATE: modify data. Intelligent table design and multi-table databases. Advanced SELECT: ORDER BY, GROUP BY and COUNT. JOIN: operations between multiple tables. Subqueries, Outer Joins, Self Joins and Unions. Constraints and Views.
- Reference texts
- Head First SQL. Lynn Beighley, O’Reilly Media, Inc.
- Educational objectives
- The purpose of the course is to acquire operational skills and abilities with respect to the design, installation and use of databases and DBMS.
- Prerequisites
- No prerequisites.
- Teaching methods
- Lectures and guided lab exercises.
- Other information
- Recommended frequency.
- Learning verification modality
- The examination consists of both a theoretical and practical test.
- Extended program
- - Data and tables: organizing the data.
- SELECT: retrieve data
- DELETE and UPDATE: modify data.
- Intelligent table design and multi-table databases.
- Advanced SELECT: ORDER BY, GROUP BY and COUNT.
- JOIN: operations between multiple tables.
- Subqueries, Outer Joins, Self Joins and Unions.
- Constraints and Views.