Basi di dati from edX

I sistemi di database sono diventati fondamentali nei sistemi di gestione delle informazioni, contribuendo allo sviluppo di una società sempre più basata sulla conoscenza. Tutte le moderne applicazioni IT sfruttano un database per la memorizzazione, l'elaborazione e il recupero delle informazioni. Viene quindi presentato il linguaggio SQL per l'interazione con un database relazionale e vengono introdotti i problemi di progettazione dei sistemi che interagiscono con i database. Infine, le tecnologie dei moderni sistemi di database sono descritte utilizzando il DBMS Oracle.

Database Systems have become fundamental in information management systems, contributing to the development of an increasingly knowledge-based society. All modern IT applications now exploit a database for storing, processing and retrieving information. The course illustrates the basic concepts for understanding not only database models and their evolution, but also the principles of their conceptual, logical and physical design within so-called information systems. The SQL language for interaction with a relational database is then presented and the problems of designing systems that interact with databases are introduced. Finally, the technologies of modern database systems are described by using the Oracle DBMS.

What's inside

Learning objectives

Alla comprensione della teoria relazionale dei dati
All’analisi, progetto, implementazione di sistemi di basi di dati relazionali a supporto di applicazioni reali
All’uso del linguaggio di programmazione sql per quanto attiene la definizione e la manipolazione di data base.
Gli allievi del corso saranno introdotti :

In this course, the students will be introduced to:
• the relational data theory;
• the analysis, design and implementation of relational databases in real applications;
• the use of sql programming language for databases definition and manipulation.

Alla comprensione della teoria relazionale dei dati
All’analisi, progetto, implementazione di sistemi di basi di dati relazionali a supporto di applicazioni reali
All’uso del linguaggio di programmazione sql per quanto attiene la definizione e la manipolazione di data base.
Gli allievi del corso saranno introdotti :
In this course, the students will be introduced to:
• the relational data theory;
• the analysis, design and implementation of relational databases in real applications;
• the use of sql programming language for databases definition and manipulation.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Gli studenti sono introdotti alla teoria relazionale a supporto di applicazioni reali

Il linguaggio del corso è italiano

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Basi di dati with these activities:

Esercizi sul linguaggio SQL

Show steps

Esercitarsi con il linguaggio SQL ti aiuterà a padroneggiare la sintassi e a migliorare le tue capacità di scrittura di query.

Browse courses on SQL

Show steps

Completa gli esercizi di pratica di SQL sul sito web di W3Schools.
Scarica e installa un database locale, come MySQL o PostgreSQL.
Crea un database di esempio e completa le query su di esso.

Discussioni sul forum di discussione del corso

Show steps

Migliora la comprensione e condividi le conoscenze interagendo con i compagni e discutendo di argomenti del corso

Show steps

Partecipa attivamente alle discussioni del forum
Poni domande per chiarire i concetti
Rispondi alle domande dei tuoi compagni di classe
Condividi risorse e spunti pertinenti

Esercizi SQL

Show steps

Rafforza le tue competenze SQL e assicurati una solida comprensione dei concetti fondamentali praticando frequentemente

Show steps

Esegui esercizi SQL online su siti web come W3Schools o SQLZoo
Iscriviti a piattaforme di pratica come LeetCode o HackerRank e risolvi problemi SQL
Crea il tuo database campione e scrivi query per manipolarlo e recuperare i dati

Two other activities

Expand to see all activities and additional details

Show all five activities

Progettazione di un database relazionale

Show steps

Metti alla prova le tue capacità di progettazione di database progettando e creando un modello di dati relazionale per un caso d'uso specifico

Show steps

Definisci lo scopo e i requisiti del database
Modella i dati utilizzando diagrammi Entità-Relazione (ERD)
Normalizza i dati per eliminare ridondanze e anomalie di inserimento
Crea un database utilizzando un DBMS come Oracle o MySQL
Carica i dati di esempio e testa le query per verificare la correttezza del progetto

Progetta e implementa un database relazionale

Show steps

Progettare e implementare un database relazionale ti aiuterà ad applicare le tue conoscenze di teoria dei database, SQL e progettazione di database a un progetto pratico.

Show steps

Scegli un caso d'uso per il tuo database.
Progetta un modello di dati per il tuo database utilizzando ERD o UML.
Crea un database utilizzando un DBMS come Oracle o MySQL.
Implementa le tabelle, i campi e i vincoli nel tuo database.
Popola il tuo database con dati di esempio.

Career center

Learners who complete Basi di dati will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator is responsible for the day-to-day operations of a database system, including installing, configuring, maintaining, and optimizing the database. This course can be a valuable resource for Database Administrators, as it provides a solid foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for Database Administrators who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for Database Administrator

Data Scientist

A Data Scientist is responsible for developing and applying statistical and machine learning models to data in order to extract meaningful insights and trends. This course can be a valuable resource for Data Scientists, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for Data Scientists who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for Data Scientist

Data Analyst

A Data Analyst is responsible for collecting, cleaning, and analyzing data in order to extract meaningful insights and trends. This course can be a valuable resource for Data Analysts, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for Data Analysts who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for Data Analyst

Software Engineer

A Software Engineer is responsible for designing, developing, and maintaining software applications. This course can be a valuable resource for Software Engineers, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for Software Engineers who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for Software Engineer

Business Analyst

A Business Analyst is responsible for analyzing business needs and developing solutions to meet those needs. This course can be a valuable resource for Business Analysts, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for Business Analysts who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for Business Analyst

Information Architect

An Information Architect is responsible for designing and organizing the structure and content of a website or other information system. This course can be a valuable resource for Information Architects, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for Information Architects who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for Information Architect

Database Designer

A Database Designer is responsible for designing and implementing database systems. This course can be a valuable resource for Database Designers, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for Database Designers who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for Database Designer

Data Engineer

A Data Engineer is responsible for building and maintaining the infrastructure that supports data storage and processing. This course can be a valuable resource for Data Engineers, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for Data Engineers who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for Data Engineer

Web Developer

A Web Developer is responsible for designing and developing websites and web applications. This course may be a valuable resource for Web Developers, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for Web Developers who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for Web Developer

Project Manager

A Project Manager is responsible for planning, executing, and closing projects. This course may be a valuable resource for Project Managers, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for Project Managers who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for Project Manager

Technical Writer

A Technical Writer is responsible for writing and editing technical documentation. This course may be a valuable resource for Technical Writers, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for Technical Writers who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for Technical Writer

IT Manager

An IT Manager is responsible for planning, implementing, and managing the IT infrastructure of an organization. This course may be a valuable resource for IT Managers, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for IT Managers who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for IT Manager

Systems Analyst

A Systems Analyst is responsible for analyzing and designing computer systems. This course may be a valuable resource for Systems Analysts, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for Systems Analysts who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for Systems Analyst

IT Consultant

An IT Consultant is responsible for providing advice and guidance to organizations on the use of IT. This course may be a valuable resource for IT Consultants, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for IT Consultants who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for IT Consultant

Software Tester

A Software Tester is responsible for testing software applications for errors. This course may be a valuable resource for Software Testers, as it provides a strong foundation in the relational data theory and the use of SQL programming language for database definition and manipulation. Additionally, the course covers the analysis, design, and implementation of relational databases in real applications, which is essential for Software Testers who need to be able to design and implement database systems that meet the needs of their users.

See salaries and explore the career path for Software Tester