INFORMATICA PER LA GESTIONE DEI DATI
Academic Year 2023/2024 - Teacher: Gaetano STELLAExpected Learning Outcomes
Provide the knowledge and tools to collect, organize, analyze, and visualize data from multiple sources.
The course allows you to learn the basics of two types of tools: spreadsheets and relational database management systems (RDBMS).
The student will acquire the basic knowledge for the management of spreadsheets with Microsoft Excel 365, the design and implementation of a database through the use of Microsoft Access and the use of the SQL language.
Course Structure
Lectures in which the topics will be introduced.
Demonstrations in which the teacher will show the practical use of software applications.
Exercises to be carried out with the assistance of the teacher to verify learning.
Required Prerequisites
Attendance of Lessons
Detailed Course Content
Module A: Fundamentals of Data Management
- Data and Information
- Importance of Data Management
- Digital Data Preservation
- Types of data
- Data management tools
Module B: Microsoft Excel
- Introduction to Spreadsheets
- Folder and Worksheets
- Cells and data type
- Perform calculations on data
- Absolute and Relative Addressing
- Working with Formulas
- Sorting the data
- Graphs
- Pivot Tables
- Page Layout
- Macros
Module C: Elements of Statistics and Probability
- Introduction to Statistics
- Position Indices
- Average
- Weighted Average
- Dispersion indices
- Range
- Variance
- Standard deviation
- Covariance of two statistical variables
- Introduction to Probability
- Probability of an event
- Certain events
- Adverse events
- Compound events (dependent and independent)
- Intersection of events
- Merging Events
- Introduction to Bayes' theorem
Module D: Database
- Introduction to databases
- Relational Database Management System (RDBMS)
- Design a database
- Relationship Entity Schema
- Tables and Reports
- Microsoft Access (RDBMS)
- Create a database
- Tables and Records
- Primary Keys and Foreign Keys
- Views
- Forms
- QBE
- Structured Query Language (SQL)
- Data Manipulation Language (DML)
- Insert, Update, Delete
- Data Definition Language (DDL)
- Create, Drop, Alter
- Data Query Language (DQL)
- Select
- Databases using SQL (with reference to Microsoft SQL Server)
- Searching for Data (Queries)
- Inserting, Editing, and Deleting Records
- Sorting the Result of a Query
- Joined queries
- Grouping data
Textbook Information
- Microsoft Access 2002 Step by Step, Microsoft Press.
- Microsoft SQL Server 2012 Step by Step, Patrick Leblanc, Microsoft Press.