Ir al contenido principal

DavidsonX: Introduction to SQL

4.8 stars
9 ratings

In this introduction to SQL Online Course you will gain strong underdstanding and utilize SQL to aggregate, manipulate, and analyze data in your field.

Introduction to SQL
4 semanas
3–5 horas por semana
A tu ritmo
Avanza a tu ritmo
Gratis
Verificación opcional disponible

Hay una sesión disponible:

¡Ya se inscribieron 21,325! Una vez finalizada la sesión del curso, será archivadoAbre en una pestaña nueva.
Comienza el 25 abr
Inscríbete
Introduction to SQL

Sobre este curso

Omitir Sobre este curso

SQL (Structured Query Language) is the most commonly used language to communicate with databases and extract data for application development, reporting and analytics. It is ubiquitous for industries across the world and a vital skill for aspiring data professions to have. This course will introduce you to the SQL language and give you the skills you need to query and analyze data from complex relational databases. Join this course if you are seeking to learn data skills to advance in your current field or pivot to a different field where you will interact with data.

In this SQL tutorial you will learn how to interact with the SQL server with the proper syntax, begin to use SQL commands and SQL databases, perform SQL queries, work with data types and database tables, and use

De un vistazo

  • Language English
  • Video Transcript English
  • Associated skillsShiny (R Package), Data Storage Technologies, Research, Syntax, Application Development, Relational Databases, Financial Analysis, Web Applications, Data Analysis, R (Programming Language), SQL (Programming Language), Market Research, RStudio, Google Sheets, Cascading Style Sheets (CSS), User Interface

Lo que aprenderás

Omitir Lo que aprenderás
  • How to use a relational database
  • How to query data and shape results
  • How to write advanced queries and analytic functions
  • How to create and modify data in tables

Plan de estudios

Omitir Plan de estudios

SQL (Structured Query Language) is the most commonly used language to communicate with databases and extract data for application development, reporting, and analytics. It is ubiquitous for industries across the world and a vital skill for aspiring data professionals to have. This course will introduce you to the SQL language and give you the skills you need to query and analyze data from complex relational databases. Join this course if you are a student or professional hoping to learn data skills to advance in your current field or pivot to a different career that is more data focused. _ ****_

Week 1

  • Introduction and History of SQL
  • Installing PostgreSQL
  • Basic SQL
  • Comments & SQL Styles

Week 2

  • SQL Joins
  • Aggregations & Subqueries
  • Data Inspeciton and Converting Data
  • String Manipulation

Week 3

  • Analytic Functions
  • Variables and Temporary Sets
  • Recursive Operations Using CTEs
  • Pivoting Data

Week 4

  • Sample Database Installation
  • 3 Final Exercises
  • Putting It All Together!

Preguntas frecuentes

Omitir Preguntas frecuentes

I have never worked with SQL or any programming language before. Should I take a beginner course prior to starting Intro to SQL?

You've come to the right place. This course is built for beginners with no prior experience and serves as a refresher for those who have used SQL in the past.

What is the value of the verified track?

Beyond the certificate which you can post on LinkedIn and other social media channels to show off your accomplishment to others, you will also gain valuable supplementary matertials to dive deeper and take the next step beyond the audit track content to learn deeper within SQL.

Este curso es parte del programa From Database to Dashboard using SQL and Power BI Professional Certificate

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

Formas de realizar este curso

Elige tu camino al inscribirte.

Verified Track

Audit Track

Costo

249 US$

Free

Acceso a los materiales del curso

Ilimitado

Limitado

Caduca el 23 may

World class institutions and universities

Asistencia de edX

Certificado para compartir al finalizar

Tareas con calificación y exámenes

Visita la sección de Preguntas frecuentesen una pestaña nueva con preguntas frecuentes sobre estas modalidades.

¿Te interesa este curso para tu negocio o equipo?

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