We may earn an affiliate commission when you visit our partners.
Course image
Jardel Sliumba

Neste projeto orientado, você obterá experiência prática trabalhando com um banco de dados relacional usando o MySQL Workbench da Oracle. O conhecimento básico obtido permitirá que você trabalhe com qualquer outro banco de dados relacional. Ao final deste projeto, você irá criar um relatório de cobrança e uma lista dos sócios do clube.

Enroll now

What's inside

Syllabus

Visão Geral do Projeto
Neste projeto orientado, você obterá experiência prática trabalhando com um banco de dados relacional usando o MySQL Workbench da Oracle. O conhecimento básico obtido permitirá que você trabalhe com qualquer outro banco de dados relacional. Ao final deste projeto, você irá criar um relatório de cobrança e uma lista dos sócios do clube.

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Ensina as competências básicas que são necessárias para trabalhar com qualquer banco de dados relacional
Desenvolve competências práticas relevantes para o mercado de trabalho
Oferece uma visão geral do MySQL Workbench da Oracle, o que auxilia na familiarização com o software
É ministrado no idioma português do Brasil, o que favorece a compreensão para alunos brasileiros
Exige conhecimento básico em banco de dados relacional para um melhor aproveitamento do conteúdo

Save this course

Save Introdução à base de dados relacionais e SQL to your list so you can find it easily later:
Save

Reviews summary

Beginner friendly sql

Introdução à base de dados relacionais e SQL is particularly well received for beginners. One review notes that the course is "bom demais" or "very good." It is particularly well received for beginners, with one reviewer calling it "Bom para iniciante" or "Good for beginners."
Course is well received for beginners.
"Bom para iniciante. "
Course needs updates.
"O curso precisa ser atualizado"

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 Introdução à base de dados relacionais e SQL with these activities:
Review SQL basics
Reviewing SQL basics will strengthen your foundation and make it easier to grasp the concepts covered in this course.
Browse courses on SQL
Show steps
  • Go over your notes from a previous SQL course or tutorial.
  • Complete a few practice problems to refresh your memory.
Follow a MySQL Workbench tutorial
Following a MySQL Workbench tutorial will give you hands-on experience with the software and help you become more comfortable using it.
Browse courses on MySQL Workbench
Show steps
  • Find a tutorial that covers the basics of MySQL Workbench.
  • Follow the steps in the tutorial to create a new database and table.
  • Insert some data into the table and run some queries.
Resolver exercícios de manipulação de dados
Reforce sua compreensão dos conceitos de manipulação de dados praticando exercícios que envolvam consultas SQL.
Browse courses on SQL
Show steps
  • Escolha um conjunto de dados de amostra ou use o fornecido no projeto
  • Crie uma série de consultas SQL para recuperar, inserir, atualizar e excluir dados
  • Execute as consultas e analise os resultados
  • Identifique e corrija quaisquer erros nas consultas
Two other activities
Expand to see all activities and additional details
Show all five activities
Complete MySQL Workbench exercises
Completing MySQL Workbench exercises will help you solidify your understanding of the concepts covered in this course and improve your proficiency in using the software.
Browse courses on MySQL Workbench
Show steps
  • Find a set of MySQL Workbench exercises online or in a textbook.
  • Work through the exercises, making sure to understand the concepts behind each one.
  • Check your answers against the provided solutions.
Create a database schema for a real-world application
Creating a database schema for a real-world application will give you valuable experience in applying the concepts covered in this course to a practical scenario.
Browse courses on Database Design
Show steps
  • Identify a real-world application that you would like to design a database for.
  • Draw a diagram of the database schema.
  • Create the database schema in MySQL Workbench.
  • Write some SQL queries to interact with the database.

Career center

Learners who complete Introdução à base de dados relacionais e SQL will develop knowledge and skills that may be useful to these careers:
Database Administrator
Database Administrators ensure that databases are running smoothly and efficiently. They also manage user access and security. This course provides a solid foundation in relational databases, which is essential for Database Administrators. You'll learn how to create and manage databases, as well as write SQL queries to retrieve and manipulate data.
Data Warehouse Architect
Data Warehouse Architects design and build data warehouses. They often work with relational databases to store and manipulate data. This course introduces you to relational databases and SQL, which are essential technologies for Data Warehouse Architects. You'll learn how to use SQL to create and manage databases, as well as write queries to retrieve and manipulate data.
Database Architect
Database Architects design and build databases. They often work with relational databases to store and manipulate data. This course introduces you to relational databases and SQL, which are essential technologies for Database Architects. You'll learn how to use SQL to create and manage databases, as well as write queries to retrieve and manipulate data.
ETL Developer
ETL Developers extract, transform, and load data from various sources into data warehouses. They often work with relational databases to store and manipulate data. This course introduces you to relational databases and SQL, which are essential technologies for ETL Developers. You'll learn how to use SQL to create and manage databases, as well as write queries to retrieve and manipulate data.
Data Analyst
Data Analysts examine data to draw meaningful conclusions, helping businesses make decisions. This course introduces you to relational databases, which are commonly used to store and manipulate data. By learning SQL, you'll gain skills that are highly sought after in the field of Data Analysis. With this foundation, you'll be well-equipped to pursue a career as a Data Analyst.
Data Quality Analyst
Data Quality Analysts ensure that data is accurate, complete, and consistent. They often work with relational databases to store and retrieve data. This course introduces you to relational databases and SQL, which are essential technologies for Data Quality Analysts. You'll learn how to use SQL to create and manage databases, as well as write queries to retrieve and manipulate data.
Data Engineer
Data Engineers build and maintain data pipelines that move data from source systems to data warehouses and other storage systems. They often work with relational databases to store and manipulate data. This course introduces you to relational databases and SQL, which are essential technologies for Data Engineers. You'll learn how to use SQL to create and manage databases, as well as write queries to retrieve and manipulate data.
Data Scientist
Data Scientists use data to solve problems and make predictions. They often work with databases to store and manipulate data. This course introduces you to relational databases and SQL, which are essential technologies for Data Scientists. You'll learn how to use SQL to create and manage databases, as well as write queries to retrieve and manipulate data.
Business Analyst
Business Analysts help businesses understand their data and make informed decisions. They often work with databases to extract and analyze data. This course introduces you to relational databases and SQL, which are essential technologies for Business Analysts. You'll learn how to use SQL to create and manage databases, as well as write queries to retrieve and manipulate data.
Mobile Application Developer
Mobile Application Developers design and develop mobile applications. They often work with databases to store and retrieve data. This course introduces you to relational databases and SQL, which are essential technologies for Mobile Application Developers. You'll learn how to use SQL to create and manage databases, as well as write queries to retrieve and manipulate data.
Web Developer
Web Developers design and develop websites and web applications. They often work with databases to store and retrieve data. This course introduces you to relational databases and SQL, which are essential technologies for Web Developers. You'll learn how to use SQL to create and manage databases, as well as write queries to retrieve and manipulate data.
Software Engineer
Software Engineers design, develop, and maintain software applications. They often work with databases to store and retrieve data. This course introduces you to relational databases and SQL, which are essential technologies for Software Engineers. You'll learn how to use SQL to create and manage databases, as well as write queries to retrieve and manipulate data.
Information Security Analyst
Information Security Analysts protect computer systems from unauthorized access and use. They often work with databases to store and retrieve security-related data. This course introduces you to relational databases and SQL, which are essential technologies for Information Security Analysts. You'll learn how to use SQL to create and manage databases, as well as write queries to retrieve and manipulate data.
Network Administrator
Network Administrators manage and maintain computer networks. They often work with databases to store and retrieve network-related data. This course introduces you to relational databases and SQL, which are essential technologies for Network Administrators. You'll learn how to use SQL to create and manage databases, as well as write queries to retrieve and manipulate data.
Systems Administrator
Systems Administrators manage and maintain computer systems. They often work with databases to store and retrieve data. This course introduces you to relational databases and SQL, which are essential technologies for Systems Administrators. You'll learn how to use SQL to create and manage databases, as well as write queries to retrieve and manipulate data.

Reading list

We've selected eight 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 Introdução à base de dados relacionais e SQL.
Este livro compacto fornece uma referência rápida e abrangente para a linguagem SQL. É um recurso útil para alunos do curso que precisam de uma referência fácil ao consultar ou escrever consultas SQL.
Este livro aborda técnicas e melhores práticas de modelagem de dados para bancos de dados relacionais. É útil para alunos do curso que desejam projetar e implementar bancos de dados eficazes.
Este livro identifica e discute práticas antipadrões comuns em programação SQL. Ele fornece insights valiosos sobre como evitar erros comuns e escrever consultas SQL eficientes e eficazes, o que é esencial para o curso.
Embora este livro se concentre no SQL Server, ele fornece insights valiosos sobre princípios de design de banco de dados relacional, normalização e otimização de desempenho. Esses conceitos são aplicávequalquer banco de dados relacional, incluindo o MySQL usado no curso.
Este livro desmistifica a linguagem SQL e a torna acessível para usuários não técnicos. É útil para alunos do curso que desejam melhorar suas habilidades de consulta SQL e entender como recuperar dados de bancos de dados.
Este livro discute técnicas e padrões para refatoração de bancos de dados, o que é essencial para manter e melhorar o desempenho e a manutenibilidade dos bancos de dados ao longo do tempo.

Share

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

Similar courses

Here are nine courses similar to Introdução à base de dados relacionais e SQL.
Bancos de dados e SQL para Ciência de Dados
Most relevant
Desenvolvimento Web Completo - 20 cursos + 20 projetos
Most relevant
Domine Administração de Bancos de Dados com DB2 IBM
Most relevant
Trabalho de conclusão de Ciência de Dados Aplicada
Most relevant
Introdução a Machine Learning em uma Competição do Kaggle
Most relevant
Python para a Ciência de Dados e IA
Most relevant
Uso de bancos de dados com Python
Most relevant
Introdução ao Big Data
Most relevant
Hospedando Website Estático (HTML/CSS/Javascript) no AWS...
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