We may earn an affiliate commission when you visit our partners.
Course image
Charles Russell Severance

Este curso apresentará aos alunos os conceitos básicos da Linguagem de Consulta Estruturada (SQL), bem como o design básico do banco de dados para armazenar dados como parte de um esforço de coleta, análise e processamento de dados em várias etapas. O curso usará o SQLite3 como banco de dados. Também criaremos rastreadores da Web e processos de coleta e visualização de dados em várias etapas. Usaremos a biblioteca D3.js para fazer a visualização básica de dados. Este curso abordará os capítulos 14 e 15 do livro “Python para Todos”. Para ter êxito neste curso, você deve estar familiarizado com o material abordado nos capítulos 1 a 13 do livro e os três primeiros cursos desta especialização. Este curso aborda o Python 3.

Enroll now

What's inside

Syllabus

Python Orientado a Objetos
Para começar essa aula, abordaremos os conceitos básicos de Python Orientado a Objetos. Não escreveremos nossos próprios objetos, mas como muitos dos recursos que usamos, como o BeautifulSoup, cadeias de caracteres, dicionários e conexões de banco de dados, utilizam padrões Orientados a Objetos (OO), devemos pelo menos entender alguns de seus padrões e terminologia.
Read more
Linguagem de consulta estruturada básica
Aprendemos as quatro principais operações CRUD (Criar, Ler, Atualizar e Excluir) para gerenciar dados armazenados em um banco de dados.
Modelos de dados e SQL relacional
Nesta seção, aprendemos como os dados são armazenados em várias tabelas em um banco de dados e como as linhas são vinculadas (ou seja, como estabelecemos relações) no banco de dados.
Relacionamentos muitos para muitos no SQL
Nesta seção, exploraremos como modelar situações como a matrícula de alunos em cursos em que cada um deles tem muitos alunos e cada aluno está matriculado em muitos cursos.
Bancos de dados e visualização
Nesta seção, reuniremos tudo, recuperaremos e processaremos alguns dados e, então, usaremos a API do Google Maps para visualizar nossos dados.

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Explora conceitos básicos de programação orientada a objetos (POO) Python, que são padrão na indústria
Ensina operações CRUD (Criar, Ler, Atualizar e Excluir) essenciais para gerenciar dados em bancos de dados
Aborda modelos de dados e SQL relacional, fundamentais para o armazenamento e gerenciamento de dados
Examina relacionamentos muitos para muitos em SQL, uma habilidade importante para modelar cenários complexos
Conecta os aprendizados teóricos à prática, recuperando e processando dados, e utilizando a API do Google Maps para visualização
Este curso requer familiaridade com os capítulos 1 a 13 do livro 'Python para Todos', indicando que é projetado para alunos com algum conhecimento prévio de Python

Save this course

Save Uso de bancos de dados com Python to your list so you can find it easily later:
Save

Reviews summary

Mixed reviews for python database course

This course covers the basics of SQL and database design as well as data collection, analysis, and processing. Overall, students find the content of the course to be good. However, some students report delays in obtaining certificates due to instructor approval requirements.

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Uso de bancos de dados com Python with these activities:
Review Basic Python Syntax
Reinforces the Python programming topics which are fundamental to this course
Browse courses on Python Basics
Show steps
  • Read through chapters 1-3 of the textbook "Python for Everyone"
  • Complete the practice exercises at the end of each chapter
  • Create a small Python program that demonstrates basic syntax and data types
Gather a Collection of SQL Resources
Provides easy access to a variety of SQL learning materials
Show steps
  • Search for reputable websites, tutorials, and documentation on SQL
  • Bookmark or download the resources for future reference
  • Periodically review the resources to reinforce learning and stay updated
Exercícios de CRUD
Realizar exercícios práticos de operações CRUD (Criar, Ler, Atualizar e Excluir) fortalecerá sua compreensão das funcionalidades básicas do SQL.
Browse courses on SQL
Show steps
  • Baixar e instalar o SQLite3
  • Criar um banco de dados usando o SQLite3
  • Executar consultas CRUD em seu banco de dados
Five other activities
Expand to see all activities and additional details
Show all eight activities
Solve SQL Practice Problems
Provides hands-on experience in writing and executing SQL queries to solidify understanding
Browse courses on SQL Queries
Show steps
  • Visit websites like LeetCode or HackerRank for SQL practice problems
  • Select a set of problems of varying difficulty levels
  • Attempt to solve the problems, focusing on writing efficient and accurate queries
Explore Advanced SQL Techniques
Enhances understanding of more complex SQL techniques beyond the basics
Browse courses on SQL Joins
Show steps
  • Search for online tutorials or courses that cover advanced SQL concepts
  • Follow the tutorials, practicing the techniques on sample datasets
  • Apply the learned techniques in the course assignments and projects
Tutoriais de Visualização de Dados
Explorar tutoriais de visualização de dados aumentará sua proficiência em apresentar dados de forma significativa.
Browse courses on D3.js
Show steps
  • Identificar um site ou plataforma com tutoriais confiáveis de visualização de dados
  • Selecionar um tutorial que corresponda ao seu nível de habilidade
  • Seguir o tutorial e criar sua própria visualização de dados
Build a Simple Data Visualization Dashboard
Enhances comprehension of data visualization concepts and D3.js library
Browse courses on Data Visualization
Show steps
  • Gather a small dataset or use the provided sample dataset
  • Decide on the types of visualizations to include in the dashboard (e.g., bar chart, line chart)
  • Use D3.js to create the visualizations and incorporate them into a dashboard
Infográfico de Conceitos SQL
Criar um infográfico sobre conceitos SQL básicos o ajudará a sintetizar e reter as informações aprendidas neste curso.
Browse courses on SQL
Show steps
  • Escolher um software ou ferramenta para criar o infográfico
  • Reunir informações sobre os conceitos SQL cobertos no curso
  • Projetar e organizar o infográfico de forma clara e concisa

Career center

Learners who complete Uso de bancos de dados com Python will develop knowledge and skills that may be useful to these careers:
Data Management Specialist
Data Management Specialists are responsible for planning, implementing, and managing data storage and retrieval systems. They often work with databases to ensure that data is accurate, consistent, and accessible. This course may be useful for aspiring Data Management Specialists who want to enhance their skills in data management and analysis.
Database Administrator
Database Administrators are responsible for maintaining and optimizing databases, ensuring their availability and performance. This course may be useful for aspiring Database Administrators because it provides a comprehensive overview of database design, management, and troubleshooting.
Data Engineer
Data Engineers are responsible for building and maintaining the infrastructure and pipelines for data storage, processing, and analysis. They work closely with Data Scientists and Data Analysts to ensure that data is available for analysis and insights.
Machine Learning Engineer
Machine Learning Engineers develop and deploy machine learning models to solve real-world problems. They often work with databases to store and manage data for training and testing machine learning models. This course may be useful for aspiring Machine Learning Engineers who want to enhance their skills in data management and analysis.
Data Visualization Specialist
Data Visualization Specialists use visual tools to communicate data insights to stakeholders. They often work with databases to extract and analyze data. This course may be useful for aspiring Data Visualization Specialists who want to enhance their skills in data management and analysis, as well as their ability to present data in a clear and compelling way.
Business Intelligence Analyst
Business Intelligence Analysts use data to help businesses make better decisions. They often work with databases to extract and analyze data, and to create reports and dashboards. This course may be useful for aspiring Business Intelligence Analysts who want to enhance their skills in data management and analysis.
Statistician
Statisticians use data to make informed decisions about the world. They often work with databases to manage and analyze data. This course may be useful for aspiring Statisticians who want to enhance their skills in data management and analysis.
Web Developer
Web Developers design and develop websites and web applications. They often work with databases to store and retrieve data for these applications. This course may be useful for Web Developers who want to improve their skills in working with databases, especially if they are working on data-driven web applications.
Software Engineer
Software Engineers apply engineering principles to design, develop, and maintain software applications. In many industries, they are responsible for data storage and management as part of their software solutions. This course may be useful for Software Engineers who want to specialize in data management or who need to enhance their skills in working with databases in their software applications.
Data Scientist
Data Scientists use programming, mathematics, and statistics to collect, clean, and analyze data in order to find patterns and insights. This course may be useful for an aspiring Data Scientist because it will provide a strong foundation in SQL and database management, topics which are crucial for anyone who wants to work with data.
Information Security Analyst
Information Security Analysts are responsible for protecting an organization's computer systems and data from cyberattacks. This course may be useful for Information Security Analysts who want to improve their skills in working with databases, as they often need to analyze data to detect and prevent security breaches.
Business Analyst
Business Analysts bridge the gap between business and technology, helping organizations understand how technology can improve their operations. They often work with databases to extract and analyze data to identify opportunities and solve problems. This course may be useful for aspiring Business Analysts who want to enhance their skills in data management and analysis.
Product Manager
Product Managers are responsible for the development and management of products. They often work with data to understand customer needs and trends, and to measure the success of their products. This course may be useful for Product Managers who want to improve their skills in data management and analysis.
Project Manager
Project Managers are responsible for planning, executing, and delivering projects. They often work with data to track progress and identify risks. This course may be useful for aspiring Project Managers who want to enhance their skills in data management and analysis.
Data Analyst
Data Analysts use their technical and analytical skills to store, clean, and make sense of data. They may present data in reports, tables, and visual charts. This course may be useful for an aspiring Data Analyst because it will help build a practical understanding of how to create and maintain a database, a key skill for anyone who wants to work with data.

Reading list

We've selected ten books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Uso de bancos de dados com Python.
Este livro é uma referência abrangente para a linguagem Python, cobrindo todos os aspectos da sintaxe e as bibliotecas padrão.
Este livro abrangente cobre técnicas populares de aprendizado de máquina e fornece exemplos e exercícios práticos usando Python.
Este livro cobre as técnicas essenciais usadas para análise de dados com Python, incluindo o uso de bibliotecas como NumPy, Pandas e Matplotlib, que são usadas na área.
Este livro ajuda a entender como o SQL funciona internamente e como escrever consultas otimizadas para desempenho, cobrindo tópicos como planos de execução e estatísticas de banco de dados.
Este livro abrange tópicos avançados de Python, incluindo programação orientada a objetos avançada, gerenciamento de memória e depuração.
Este manual abrangente é o guia definitivo para MySQL, fornecendo informações detalhadas sobre todas as funcionalidades do banco de dados.
Este livro oferece uma coleção de receitas e soluções práticas para problemas comuns de programação em Python, incluindo tarefas relacionadas a banco de dados.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Uso de bancos de dados com Python.
Marco de Sustentabilidade da Dívida para Países de Baixa...
Most relevant
Compartilhar os dados com a arte da visualização
Most relevant
Estruturas de dados Python
Most relevant
Bancos de dados e SQL para Ciência de Dados
Most relevant
Visualização de dados com o Python
Most relevant
Metodologia de Ciência de Dados
Most relevant
O sucesso por meio das avaliações: análise e medição de...
Most relevant
Análise de dados com programação em R
Most relevant
Creating BigQuery Datasets, Visualizing Insights -...
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser