Este curso forma parte de Programa especializado: Python, Bash and SQL Essentials for Data Engineering

4.5
estrellas
30 calificaciones

Alfredo Deza +2 instructores más

2985 ya inscrito

ofrecido por

Programa especializado: Python, Bash and SQL Essentials for Data EngineeringUniversidad Duke

Acerca de este Curso

21.701 vistas recientes

In this third course of the Python, Bash and SQL Essentials for Data Engineering Specialization, you will explore techniques to work effectively with Python and SQL. We will go through useful data structures in Python scripting and connect to databases like MySQL. Additionally, you will learn how to use a modern text editor to connect and run SQL queries against a real database, performing operations to load and extract data. Finally, you will use extracted data from websites using scraping techniques. These skills will allow you to work effectively when data is not readily available, or when spatial queries are required to extract useful information from databases.

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 3 de 4 en

Programa especializado: Python, Bash and SQL Essentials for Data Engineering

Nivel intermedio

Some experience with Python programming (<1 year)

Aprox. 19 horas para completar

Inglés (English)

Subtítulos: Inglés (English)

Qué aprenderás

Extract data from different sources and map it to Python data structures.
Design Scripts to connect and query a SQL database from within Python.
Apply scraping techniques to read and extract data from a website.

Habilidades que obtendrás

Database (DBMS)
Python Programming
Web Scraping
MySQL
SQL

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 3 de 4 en

Programa especializado: Python, Bash and SQL Essentials for Data Engineering

Nivel intermedio

Some experience with Python programming (<1 year)

Aprox. 19 horas para completar

Inglés (English)

Subtítulos: Inglés (English)

Instructores

ofrecido por

Universidad Duke

Duke University has about 13,000 undergraduate and graduate students and a world-class faculty helping to expand the frontiers of knowledge. The university has a strong commitment to applying knowledge in service to society, both near its North Carolina campus and around the world.

Programa - Qué aprenderás en este curso

Semana

Semana 1

5 horas para completar

Working with Data in Python

This week, you will learn how to effectively use Python’s data structures to load, persist, and iterate over data. You will apply these data structures to solve different problems when working with popular data formats like JSON.

5 horas para completar

19 videos (Total 62 minutos), 4 lecturas, 2 cuestionarios

19 videos

Welcome to Scripting with Python and SQL for Data Engineering45s

Meet your Course Instructor: Alfredo Deza29s

Overview of Key Concepts4m

Introduction to Working with Data in Python29s

Introduction to Python Data Structures46s

Using Lists to Save and Retrieve Data in Python5m

Using Dictionaries to Save and Retrieve Data in Python7m

Overview of Lesson Common Data Structures in Python4m

Recap of Data Structures in Python1m

Introduction to Choosing Data Structures in Python1m

Iterating Over Lists and Dictionaries in Python7m

Iterating Over Other Data Structures in Python2m

Storing Data Between Data Structures in Python6m

Recap of Mapping Data Structures in Python1m

Introduction to Data Sources and Formats in Python53s

Loading Data from Files and File Paths in Python6m

Working with JSON in Python6m

Saving Data from Python to Disk4m

Recap of Persisting and Loading Data in Python47s

4 lecturas

Meet your Supporting Instructors: Kennedy Behrman and Noah Gift10m

Course Structure and Discussion Etiquette10m

Python Lists and Dictionaries10m

Build a notebook that reformats data into JSON10m

2 ejercicios de práctica

Using Data Structures in Python30m

Working with Data in Python30m

Semana

Semana 2

5 horas para completar

Python Scripting and SQL

This week, you will learn how to use Python scripting techniques to work with SQL. You will create a database, store data, and query that data with SQL from Python.

5 horas para completar

15 videos (Total 56 minutos), 2 lecturas, 1 cuestionario

15 videos

Introduction to Python Scripting and SQL31s

Introduction to Scripting in Python40s

Creating a Script as a Module in Python5m

Traversing the File System with a Script in Python7m

Recap of Python Scripting Basics43s

Introduction to Embedded Databases48s

What is SQLite?2m

Creating and Connecting to a SQLite Database in Python5m

Saving and Querying from a SQLite Database in Python10m

Recap of SQLite and Python1m

Introduction to Querying with SQL in Python1m

Basic SQL Commands in Python6m

Extracting Distinct Data using SQL in Python7m

Searching with SQL in Python5m

Recap of Querying with SQL in Python1m

2 lecturas

Minimal Python, Chapter 2: Learn to Store Data10m

Create a Reporting Script for File Sizes10m

1 ejercicio de práctica

Python Scripting and SQL30m

Semana

Semana 3

5 horas para completar

Web Scraping using Python

This week, you will learn how to efficiently extract data from the web. You will learn how to use a scraping library to read data from websites and identify and extract specific values from it.

5 horas para completar

15 videos (Total 65 minutos), 3 lecturas, 1 cuestionario

15 videos

Introduction to Web Scraping using Python30s

Introduction to Extracting Data from Unstructured HTML1m

Challenges with Web Data3m

Parsing HTML with HTMLParser in Python5m

Recap of Web Scraping Techniques in Python40s

Introduction to Scrapy and XPath in Python1m

Creating a Web Scraping Project with Scrapy in Python6m

Parsing Data with XPath and Scrapy Shell11m

Using Scrapy Spider for Web Scraping5m

Recap of Scrapy and XPath in Python43s

Overview of Challenges with Web Scraping2m

Scraping Locally8m

Persisting Data in CSV and JSON Formats9m

Persisting Data to a SQLite Database6m

Recap of Persistence and Efficacy with Web Scraping1m

3 lecturas

Parsing Techniques with HTMLParser10m

Efficient Scraping Techniques10m

Build a Web Scraping Tool10m

1 ejercicio de práctica

Web Scraping using Python30m

Semana

Semana 4

4 horas para completar

Working with MySQL

This week, you will learn how to use a modern development environment and editor to connect to a MySQL database server, execute queries and perform database operations.

4 horas para completar

11 videos (Total 37 minutos), 2 lecturas, 1 cuestionario

11 videos

Introduction to Working with MySQL30s

Introduction to VSCode with MySQL1m

Connecting to a MySQL Server8m

Recap of VSCode with MySQL1m

Challenges of Running MySQL Queries1m

Using VSCode to Execute MySQL Queries6m

Recap of Running MySQL Queries1m

Challenges with Importing to Databases1m

Importing CSV Data into MySQL6m

Exporting Data from MySQL6m

Recap of Importing and Exporting Data in MySQL1m

2 lecturas

Working with VSCode and MySQL10m

Loading and Exporting Data using MySQL10m

1 ejercicio de práctica

Working with MySQL30m

Reseñas

4.5

5 reseña

5 stars
79,41 %
4 stars
11,76 %
1 star
8,82 %

Principales reseñas sobre SCRIPTING WITH PYTHON AND SQL FOR DATA ENGINEERING

por BM28 de ago. de 2022

This provides the essentials of data engineering and analysis.

Ver todas las reseñas

Acerca de Programa especializado: Python, Bash and SQL Essentials for Data Engineering

If you are interested in developing the skills needed to be a data engineer, the Python, Bash and SQL Essentials for Data Engineering Specialization is a great place to start. We live in a world that is driven by big data - from what we search online to the route we take to our favorite restaurant, and everything in between. Businesses and organizations use this data to make decisions that impact the ways in which we navigate our lives. How do engineers collect this data? How can this data be organized so that it can be appropriately analyzed? A data engineer is specialized in this initial step of accessing, cleaning and managing big data.

Data engineers today need a solid foundation in a few essential areas: Python, Bash and SQL. In Python, Bash and SQL Essentials for Data Engineering, we provide a nuts and bolts overview of these fundamental skills needed for entering the world of data engineering. Led by three professional data engineers, this Specialization will provide quick and accessible ways to learn data engineering strategies, give you a chance to practice what you’ve learned in integrated lab exercises, and then immediately apply these techniques in your professional or academic life.

Preguntas Frecuentes

¿Cuándo podré acceder a las lecciones y tareas?
El acceso a las clases y las asignaciones depende del tipo de inscripción que tengas. Si tomas un curso en modo de oyente, verás la mayoría de los materiales del curso en forma gratuita. Para acceder a asignaciones calificadas y obtener un certificado, deberás comprar la experiencia de Certificado, ya sea durante o después de participar como oyente. Si no ves la opción de oyente:
es posible que el curso no ofrezca la opción de participar como oyente. En cambio, puedes intentar con una Prueba gratis o postularte para recibir ayuda económica.
Es posible que el curso ofrezca la opción 'Curso completo, sin certificado'. Esta opción te permite ver todos los materiales del curso, enviar las evaluaciones requeridas y obtener una calificación final. También significa que no podrás comprar una experiencia de Certificado.
¿Qué recibiré si me suscribo a este Programa especializado?
Cuando te inscribes en un curso, obtienes acceso a todos los cursos que forman parte del Programa especializado y te darán un Certificado cuando completes el trabajo. Se añadirá tu Certificado electrónico a la página Logros. Desde allí, puedes imprimir tu Certificado o añadirlo a tu perfil de LinkedIn. Si solo quieres leer y visualizar el contenido del curso, puedes auditar el curso sin costo.
¿Hay ayuda económica disponible?
Sí. En ciertos programas de aprendizaje, puedes postularte para recibir ayuda económica o una beca en caso de no poder costear los gastos de la tarifa de inscripción. Si hay ayuda económica o becas disponibles para tu selección de programa de aprendizaje, verás un enlace para postularte en la página de descripción.

¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.

Scripting with Python and SQL for Data Engineering

Acerca de este Curso

Qué aprenderás

Habilidades que obtendrás

Instructores

Alfredo Deza

Kennedy Behrman

Noah Gift

ofrecido por

Universidad Duke

Programa - Qué aprenderás en este curso

Working with Data in Python

Python Scripting and SQL

Web Scraping using Python

Working with MySQL

Reseñas

Principales reseñas sobre SCRIPTING WITH PYTHON AND SQL FOR DATA ENGINEERING

Acerca de Programa especializado: Python, Bash and SQL Essentials for Data Engineering

Preguntas Frecuentes

Comienza o impulsa tu carrera profesional

Buscar temas populares

Cursos y artículos populares

Obtén un título de grado o un certificado en línea

Coursera

Comunidad

Más

Scripting with Python and SQL for Data Engineering

Acerca de este Curso

Qué aprenderás

Habilidades que obtendrás

Instructores

Alfredo Deza

Kennedy Behrman

Noah Gift

ofrecido por

Universidad Duke

Programa - Qué aprenderás en este curso

Working with Data in Python

Python Scripting and SQL

Web Scraping using Python

Working with MySQL

Reseñas

Principales reseñas sobre SCRIPTING WITH PYTHON AND SQL FOR DATA ENGINEERING

Acerca de Programa especializado: Python, Bash and SQL Essentials for Data Engineering

Preguntas Frecuentes

Coursera Footer

Comienza o impulsa tu carrera profesional

Buscar temas populares

Cursos y artículos populares

Obtén un título de grado o un certificado en línea

Coursera

Comunidad

Más