About Course

This Specialization is designed for individuals who wish to build or improve proficiency in SQL query development.

Through four progressively challenging SQL projects focused on data analytics applications, learners will explore topics such as SQL fundamentals, data wrangling, analytical queries, A/B testing, filtering, and more.

These topics aim to equip you with the skills to apply SQL creatively for data exploration and analysis, write efficient queries, construct datasets for analysis, perform feature engineering, integrate SQL with other data analysis and machine learning tools, and work with data.

What Will You Learn?

  • Identify a subset of data needed from a column or set of columns and write a SQL query to limit to those results.
  • Use SQL commands to filter, sort, and summarize data.
  • Create an analysis table from multiple queries using the UNION operator.
  • Manipulate strings, dates, & numeric data using functions to integrate data from different sources into fields with the correct format for analysis.

Course Content

Module 1 – Data Analytics Intro
In this module, you will learn about the different types of data analysis and the key steps in a data analysis process.

  • Course Introduction
    02:43
  • Modern Data Ecosystem
  • Key Players in the Data Ecosystem
  • Defining Data Analysis
  • Data Analytics vs. Data Analysis
  • Summary and Highlights
  • Quiz 1
  • Quiz 2
  • Responsibilities of a Data Analyst
  • A Day in the Life of a Data Analyst
  • Summary and Highlights 2
  • Quiz 3
  • Quiz 4

Module 2 – Data Ecosystem
In this module, you will learn about the different types of data structures, file formats, data sources, and the languages ​​used.

Modulo 3 – Recopilacion y Manejo de Datos
En este módulo, conocerá el proceso y los pasos necesarios para identificar, recopilar e importar datos de fuentes dispares

Modulo 4 – Extraccion y Visualizacion de Datos
En este módulo, conocerá el papel del análisis estadístico en la extracción y visualización de datos

Modulo 5 – Oportunidades Profesionales para Analistas de Datos
En este módulo, conocerá las diferentes salidas profesionales en el campo del Análisis de Datos

Related Courses

COU645
 (5.00/3)

Analisis de Datos – AD7800

AdminAdmin
46 Lessons
$ 1.000
HEL1114
 (5.00/1)

Analisis de Datos con Python – APY730

AdminAdmin
46 Lessons
$ 1.000
HELWP0
 (5.00/1)

SQL para Analisis de Datos – SQL720

AdminAdmin
41 Lessons
$ 1.000