Ir al contenido principal

HarvardX: CS50's Introduction to Databases with SQL

An introduction to databases using a language called SQL.

CS50's Introduction to Databases with SQL
7 semanas
6–12 horas por semana
A tu ritmo
Avanza a tu ritmo
Gratis
Verificación opcional disponible

Hay una sesión disponible:

¡Ya se inscribieron 47,918! Una vez finalizada la sesión del curso, será archivadoAbre en una pestaña nueva.
Comienza el 1 may
Termina el 31 dic

Sobre este curso

Omitir Sobre este curso

This is CS50's introduction to databases using a language called SQL. Learn how to create, read, update, and delete data with relational databases, which store data in rows and columns. Learn how to model real-world entities and relationships among them using tables with appropriate types, triggers, and constraints. Learn how to normalize data to eliminate redundancies and reduce potential for errors. Learn how to join tables together using primary and foreign keys. Learn how to automate searches with views and expedite searches with indexes. Learn how to connect SQL with other languages like Python and Java. Course begins with SQLite for portability's sake and ends with introductions to PostgreSQL and MySQL for scalability's sake as well. Assignments inspired by real-world datasets.

De un vistazo

  • Language English
  • Video Transcript English
  • Associated programs
  • Associated skillsSQLite, Data Store, Java (Programming Language), PostgreSQL, Python (Programming Language), MySQL, Scalability, Relational Databases, SQL (Programming Language), Foreign Keys

Lo que aprenderás

Omitir Lo que aprenderás
  • CREATE TABLE
  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • DROP
  • CREATE INDEX
  • CREATE VIEW
  • SQLite, PostgreSQL, MySQL
  • connectors (Python, Java)
  • replication

Este curso es parte del programa Computer Science for Databases using SQL Professional Certificate

Más información 
Instrucción por expertos
2 cursos de capacitación
A tu ritmo
Avanza a tu ritmo
5 meses
6 - 16 horas semanales

¿Te interesa este curso para tu negocio o equipo?

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