• Duración:
    16 semanas
  • Dedicación:
    8–10 horas por semana
  • Precio:

    GRATIS
    Agregar un Certificado Verificado por $498 USD

  • Institución
  • Tema:
  • Nivel:
    Introductory
  • Idioma:
    English
  • Transcripción de video:
    English
  • Tipo de curso:
    A tu ritmo

Programas asociados:

Prerrequisitos

This is the second course in the introductory, undergraduate-level offering that makes up the larger Data Management with Python and SQL MicroBachelors program. We recommend taking them in order, unless you have a background in these areas already and feel comfortable skipping ahead.

  1. Scripting with Python - starting February 2021

  2. Structured Database Environments with SQL - starting February 2021

Sobre este curso

Omitir Sobre este curso

Develop the skills necessary to create structured database environments using a relational database management system (RDBMS), such as MySQL, that incorporates basic processing functionality and allows for data management, data manipulation and data analysis. Learn about types of data and types of databases to store data, as well as design for scalability. You’ll also learn to prepare digital data storage using the relational model, including resolving integrity constraints, and proper assignments of primary and foreign keys. In addition, you’ll construct and analyze queries to address data requirements.

By completing this course and the final exam, you will:

  • Demonstrate knowledge of the relational model

  • Build skills in SQL

  • Construct SQL queries

  • Read and develop database schemas

  • Apply the concept of normalization to a dataset or database

  • Understand how to add/export data to existing schemas and SQL joins

  • Learn how to troubleshoot SQL code

If you’re looking to advance your career, you should take this course if you’re interested in data analytics, data engineering, database design or business intelligence. Structured query language (SQL) is the fundamental cornerstone to extract, transact and load data necessary for analysis using a relational database.

This is the second course in the introductory, undergraduate-level offering that makes up the larger Data Management with Python and SQL MicroBachelors program. We recommend taking them in order, unless you have a background in these areas already and feel comfortable skipping ahead.

  1. Scripting with Python - starting February 2021

  2. Structured Database Environments with SQL - starting February 2021

NOTE : While this is generally a non-credit-bearing course, you may be able to use this class with proper completion for 3 credits (1 course) toward a bachelor's degree at Southern New Hampshire University.

Lo que aprenderás

Omitir Lo que aprenderás
  • Understanding what SQL is

  • How to use SQL statements such as:

    • Select

    • From

    • Where

    • Having

    • Group by

    • Order by

    • Max

    • Min

    • Count

    • Count distinct

    • Joins

    • Import/export

  • Reading schemas

  • Creating database schemas

  • Importing/exporting data

  • Troubleshooting queries

  • Modifying tables and data structures

  • Analyzing SQL outputs

Conoce a tus instructores

Scott Overmyer
Associate Dean of Information Technology
Southern New Hampshire University
Ben Tasker
Technical Program Facilitator – Data Science and Data Analytics
Southern New Hampshire University

Obtén un Certificado Verificado para destacar los conocimientos y las habilidades que adquieras
$498 USD

Ver un modelo de certificado de edX en PDF
  • Oficial y verificado

    Obtén un certificado con la firma del instructor y el logotipo de la institución para demostrar tus logros y aumentar las posibilidades de conseguir trabajo

  • Fácil de compartir

    Agrega el certificado a tu currículum o publícalo directamente en LinkedIn

  • Incentivo comprobado

    El certificado te da un motivo más para completar el curso

  • Apoya nuestra labor

    edX, una organización sin fines de lucro, se sustenta con los certificados verificados para financiar la educación gratuita para todo el mundo