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

Manipulating Data with SQL

  • 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

  • Manipulating Data with SQL
    • In this course you will learn to write the SQL code to manipulate the data in a relational database table. You’ll begin by populating the table with data. Since a database and its tables are designed and built to be repositories of data, getting the data into the tables is a critical activity in the building of a working database. When building a new home, the real test of your design comes when the furniture and family move in. It’s much the same with designing and building database tables—the real test comes when you load data into the tables and begin to use it. As you work through and complete hands-on tasks, you’ll become familiar with SQLiteStudio, the database management system used in the course. You’ll experience first-hand the impact data types and constraints have on manipulating table data. For example, as you enter new data into a table, you’ll appreciate the extra protection provided by the primary key constraint. It will not let you insert two rows into a table that are exactly alike. In addition to adding data to the tables, you’ll write the SQL code used to modify existing data values and to delete rows of data. Managing and manipulating data are SQL’s primary purposes, and SQL coding is a powerful tool to have in your tool set.