Ir al contenido principal

UPValenciaX: Introduction to SQL and relational databases

Get to know relational databases and learn SQL, the standard language used in business software that will allow you to query them and extract the information you need.

Introduction to SQL and relational databases
5 semanas
4–5 horas por semana
A tu ritmo
Avanza a tu ritmo
Gratis
Verificación opcional disponible

Hay una sesión disponible:

Una vez finalizada la sesión del curso, será archivadoAbre en una pestaña nueva.
Comienza el 2 may
Termina el 16 dic
Inscríbete
Introduction to SQL and relational databases

Sobre este curso

Omitir Sobre este curso

The biggest asset of today's companies is their data, and data that is mostly stored in online relational databases.

Virtually all relational database management systems in use today use SQL as a tool for manipulating and querying the data they contain.

SQL language is an international standard that allows, in a simple way, powerful data extraction and summarization queries to be performed with very few commands.

If you want to make a career in business intelligence, web application programming or any other activity that requires querying or updating data, mastering SQL is a basic requirement.

In this course we will teach you the basic concepts needed to manage a database and we will introduce you gradually and practically to the use of SQL, starting with the simple query to get all the data stored in a table and ending with complex queries able to summarize the data contained in several related tables, queries that you will be able to replicate in a SQL emulator in the cloud during the course.

De un vistazo

  • Institution UPValenciaX
  • Subject Informática
  • Level Introductory
  • Prerequisites

    Knowledge of computer use at user level is enough to take this course.

  • Language English
  • Video Transcript English
  • Associated skillsSQL (Programming Language), Business Software, Relational Databases, Relational Database Management Systems, Data Extraction, Business Intelligence, Emulators, International Standards

Lo que aprenderás

Omitir Lo que aprenderás

Basic concepts of databases and relational databases such as table, record, field, relation, primary key or secondary key.

* Use of the SELECT command with the WHERE clause and various tools such as IN, BETWEEN or LIKE to query databases using string and range patterns.

* The SQL commands for creating, changing and deleting tables and databases: CREATE, ALTER and DROP

* The SQL commands for modifying the contents of database tables: INSERT, UPDATE and DELETE.

* How to group and sort the results of a SQL query with ORDER BY, GROUP BY and how to summarize them with functions such as SUM, AVG, MAX or MIN.

* How to perform complex queries that return the results of several tables with JOIN and UNION

Formas de realizar este curso

Elige tu camino al inscribirte.

Verified Track

Audit Track

Costo

39 US$

Free

Acceso a los materiales del curso

Ilimitado

Limitado

Caduca el 6 jun

World class institutions and universities

Asistencia de edX

Certificado para compartir al finalizar

Tareas con calificación y exámenes

Visita la sección de Preguntas frecuentesen una pestaña nueva con preguntas frecuentes sobre estas modalidades.

¿Te interesa este curso para tu negocio o equipo?

Capacita a tus empleados en los temas más solicitados con edX para Negocios.
ComprarSolicitar información