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.
Ce cours fait partie de la Spécialisation Python, Bash and SQL Essentials for Data Engineering
Offert par
À propos de ce cours
19 093 consultations récentes
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Cours 3 sur 4 dans le
Niveau intermédiaire
Some experience with Python programming (<1 year)
Approx. 19 heures pour terminer
Anglais
Sous-titres : Anglais
Ce que vous allez apprendre
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.
Compétences que vous acquerrez
- Database (DBMS)
- Python Programming
- Web Scraping
- MySQL
- SQL
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Cours 3 sur 4 dans le
Niveau intermédiaire
Some experience with Python programming (<1 year)
Approx. 19 heures pour terminer
Anglais
Sous-titres : Anglais
Offert par
Université 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.
Programme de cours : ce que vous apprendrez dans ce cours
5 heures pour terminer
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 heures pour terminer
19 vidéos (Total 62 min), 4 lectures, 2 quiz
5 heures pour terminer
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 heures pour terminer
15 vidéos (Total 56 min), 2 lectures, 1 quiz
5 heures pour terminer
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 heures pour terminer
15 vidéos (Total 65 min), 3 lectures, 1 quiz
4 heures pour terminer
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 heures pour terminer
11 vidéos (Total 37 min), 2 lectures, 1 quiz
À propos du Spécialisation 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.
Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
À quoi ai-je droit si je m'abonne à cette Spécialisation ?
Une aide financière est-elle possible ?
D'autres questions ? Visitez le Centre d'Aide pour les Étudiants.
