In this course you will learn all about the Structured Query Language ("SQL".) We will review the origins of the language and its conceptual foundations. But primarily, we will focus on learning all the standard SQL commands, their syntax, and how to use these commands to conduct analysis of the data within a relational database. Our scope includes not only the SELECT statement for retrieving data and creating analytical reports, but also includes the DDL ("Data Definition Language") and DML ("Data Manipulation Language") commands necessary to create and maintain database objects.
Este curso forma parte de Programa especializado: Databases for Data Scientists
14.712 ya inscrito
ofrecido por
Programa especializado: Databases for Data ScientistsUniversidad de Colorado en BoulderAcerca de este Curso
188.179 vistas recientes
Fechas lÃmite flexibles
Restablece las fechas lÃmite en función de tus horarios.
Certificado para compartir
Obtén un certificado al finalizar
100Â % en lÃnea
Comienza de inmediato y aprende a tu propio ritmo.
Curso 2 de 3 en
Nivel principiante
Successful completion of R​elational Database Design (Databases for Data Scientists, Course 1) recommended.
Aprox. 25 horas para completar
Inglés (English)
SubtÃtulos: Inglés (English)
¿PodrÃa tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?
Prueba Coursera para negociosQué aprenderás
The origins and historical basis for SQL
Standard SQL use and syntax
How to code SQL queries in order to analyze data stored in relational databases
Habilidades que obtendrás
- Data Science
- Database (DBMS)
- Database Application
- SQL (Structured Query Language)
- database administration
Fechas lÃmite flexibles
Restablece las fechas lÃmite en función de tus horarios.
Certificado para compartir
Obtén un certificado al finalizar
100Â % en lÃnea
Comienza de inmediato y aprende a tu propio ritmo.
Curso 2 de 3 en
Nivel principiante
Successful completion of R​elational Database Design (Databases for Data Scientists, Course 1) recommended.
Aprox. 25 horas para completar
Inglés (English)
SubtÃtulos: Inglés (English)
¿PodrÃa tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?
Prueba Coursera para negocios
ofrecido por
Universidad de Colorado en Boulder
CU-Boulder is a dynamic community of scholars and learners on one of the most spectacular college campuses in the country. As one of 34 U.S. public institutions in the prestigious Association of American Universities (AAU), we have a proud tradition of academic excellence, with five Nobel laureates and more than 50 members of prestigious academic academies.
Comienza a trabajar para obtener tu maestrÃa
Este curso es parte del Master of Science in Data Science completamente en lÃnea de Universidad de Colorado en Boulder.
Si te aceptan en el programa completo, tus cursos cuentan para tu tÃtulo de grado.
Programa - Qué aprenderás en este curso
2 horas para completar
Introduction to SQL - Structured Query Language
The origins of SQL, what it is and how it works.
2 horas para completar
5 videos (Total 64 minutos), 1 lectura, 3 cuestionarios
6 horas para completar
The Basic SELECT Statement
The SELECT statement - retrieving data from your database.
6 horas para completar
5 videos (Total 78 minutos), 7 lecturas, 5 cuestionarios
4 horas para completar
Group Functions, SubTotals, and Subqueries
The five GROUP functions.
4 horas para completar
3 videos (Total 49 minutos), 4 lecturas, 6 cuestionarios
4 horas para completar
Getting Data from Multiple Tables
Using the JOIN.
4 horas para completar
4 videos (Total 44 minutos), 4 lecturas, 5 cuestionarios
Reseñas
- 5 stars77,96Â %
- 4 stars16,52Â %
- 3 stars2,96Â %
- 2 stars0,84Â %
- 1 star1,69Â %
Principales reseñas sobre THE STRUCTURED QUERY LANGUAGE (SQL)
por AB15 de ago. de 2022
A very comprehensive course for the basic understanding course of SQL. Recommended
por NB15 de may. de 2022
A very good course going through all the basics for writing SQL commands. A great refresher for me as I have not done any SQL in about 2 years.
por AC17 de abr. de 2022
Very informative and easy to follow. Thank you for the knowledge.
por AB12 de may. de 2022
Great to begin with and good for students trying to learn SQL Basics
Acerca de Programa especializado: Databases for Data Scientists
Whether you are a beginning programmer with an interest in Data Science, a data scientist working closely with content experts, or a software developer seeking to learn about the database layer of the stack this specialization is for you! We focus on the relational database which is the most widely used type of database. Relational databases have dominated the database software marketplace for nearly four decades and form a core, foundational part of software development. In this specialization you will learn about database design, database software fundamentals, and how to use the Structured Query Language (SQL) to work with databases. The specialization, will conclude with an overview of future trends in databases, including non-relational databases (NoSQL) and Big Data. Upon completion of this specialization you will be well prepared to design and create efficient and effective relational databases, fill them with data, and work with them using SQL.
Preguntas Frecuentes
¿Cuándo podré acceder a las lecciones y tareas?
¿Qué recibiré si me suscribo a este Programa especializado?
¿Cuál es la polÃtica de reembolsos?
¿Hay ayuda económica disponible?
¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.
