PRESENTACIÓN ADMINISTRACIÓN BASES DE DATOS

Empezar

Luis Saurina, Adrian Martí, Luis Aragón, Daniel Samblás

bddd relacionales

Modelo Entidad-Relación

ModeloRelacional

SQL (Structured Query Language) is a language used to manage and manipulate relational databases, allowing operations such as querying, inserting, updating, and deleting data.En SQL los principales sublenguajes son:-DML (Data Manipulation Language)-DCL (Data Control Language)-DDL (Data Definition Language)

Código SQL

DDL (Data Definition Language) is used to define and modify the structure of databases and tables. This is the first language used when creating your database.

DdL

versus

Puedes explicar algunos pros visualmente

Presentación WOW

Y compararlos con los contras

Presentación aburrida

SQL (Structured Query Language) queries are commands used to interact with relational databases. Queries allow you to extract, insert, update or delete data from a database. SQL is the language that allows us to communicate with these databases.Types of SQL QueriesSELECT: Used to query (extract) data.INSERT: Used to insert new data into the database.UPDATE: Used to update existing data.DELETE: Delete data from the database.

SQL QUERY

Extrae información de una tabla.

SELECT:

SQL QUERY

Gracias por vuestra atención