logo-mooc
search-iconsearch-icon
menu-whitemenu-blue
GRATIS
Inicio / Buscador / Programación / Bases de Datos Relacionales
Politecnico di Milano vía Coursera
GRATIS

Retrieve Data with Multiple-Table SQL Queries

  • money

    Cursos gratis (Auditar)

    question-mark
  • earth

    Inglés

  • folder

    Siempre Abierto

  • certificate

    Guía de Registro en Coursera

    arrow
VER CURSO arrow
Acerca de este curso

  • Multiple-Table SQL Queries
    • In this course you will be introduced to two methods of writing an SQL query that retrieves data from two or more tables. Since one of the functions of a database is to store data in an organized format, many databases are made up of more than one table. Often, output from the database requires data from more than one table. For example, the output that populates a student transcript might come from the Student, Course, and Section tables. While the Student table may provide the student’s name, the name and number of the course might come from the Course table and the specific grade for that course may come from yet another table.

      Just as the entities (student, course, section) in a school are related, databases are very carefully designed so that the tables are all related through the use of common columns. As a query writer you will need to develop an understanding of table relationships and how they are represented in an SQL query. The SQLiteStudio platform will be used to provide you with hands-on experience writing queries that access rows and columns of data from two or more tables. In addition, you’ll be practicing many of the skills introduced in the Single-Table SQL Queries course.