We may earn an affiliate commission when you visit our partners.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/fik371/introducao
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
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
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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.
Review SQL basics
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
Reforce sua compreensão dos conceitos de manipulação de dados praticando exercícios que envolvam consultas SQL.
Browse courses on
SQL
Show steps
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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.
For more career information including salaries, visit:
OpenCourser.com/course/fik371/introducao
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 prático orienta os alunos do curso através do processo de design de banco de dados relacional, desde a coleta de requisitos até a implementação. É um recurso valioso para iniciantes e profissionais experientes.
Save
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.
Embora não seja específico para bancos de dados relacionais, este livro fornece princípios e práticas pragmáticas para desenvolvimento de software que podem ser aplicados ao desenvolvimento de banco de dados. É uma leitura valiosa para alunos do curso.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/fik371/introducao
Share
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
OpenCourser.com/course/iie3a0/bancos
Bancos de dados e SQL para Ciência de Dados
Most relevant
Desenvolvimento Web Completo - 20 cursos + 20 projetos
OpenCourser.com/course/ttb7tc/desenvolvimento
Desenvolvimento Web Completo - 20 cursos + 20 projetos
Most relevant
Domine Administração de Bancos de Dados com DB2 IBM
OpenCourser.com/course/icfkqr/domine
Domine Administração de Bancos de Dados com DB2 IBM
Most relevant
Trabalho de conclusão de Ciência de Dados Aplicada
OpenCourser.com/course/vgj50b/trabalho
Trabalho de conclusão de Ciência de Dados Aplicada
Most relevant
Introdução a Machine Learning em uma Competição do Kaggle
OpenCourser.com/course/fk7wc2/introducao
Introdução a Machine Learning em uma Competição do Kaggle
Most relevant
Python para a Ciência de Dados e IA
OpenCourser.com/course/qdc30p/python
Python para a Ciência de Dados e IA
Most relevant
Uso de bancos de dados com Python
OpenCourser.com/course/c8qke7/uso
Uso de bancos de dados com Python
Most relevant
Introdução ao Big Data
OpenCourser.com/course/8o5n5j/introducao
Introdução ao Big Data
Most relevant
Hospedando Website Estático (HTML/CSS/Javascript) no AWS S3
OpenCourser.com/course/iynadi/hospedando
Hospedando Website Estático (HTML/CSS/Javascript) no AWS...
Most relevant
Effort
1 Hour
Level
Introductory
Via
Coursera
Institution
Coursera Project Network
Instructor
Jardel Sliumba
Language
Português
Good to know
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
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