Bancos de dados e SQL para Ciência de Dados from Coursera

Grande parte dos dados do mundo reside em bancos de dados. SQL (ou Structured Query Language) é uma linguagem poderosa usada para se comunicar e extrair dados de bancos de dados. Um conhecimento prático de bancos de dados e SQL é essencial se você deseja se tornar um cientista de dados. O objetivo deste curso é apresentar os conceitos de banco de dados relacional e ajudá-lo a aprender e aplicar o conhecimento básico da linguagem SQL. Também se destina a ajudá-lo a começar a executar o acesso SQL em um ambiente de ciência de dados. A ênfase neste curso está no aprendizado prático e participativo. Como tal, você trabalhará com bancos de dados reais, ferramentas de ciência de dados reais e conjuntos de dados do mundo real. Você criará uma instância de banco de dados na nuvem. Por meio de uma série de laboratórios práticos, você praticará a construção e a execução de consultas SQL. Você também aprenderá como acessar bancos de dados do notebook Jupyter usando SQL e Python. Não é necessário conhecimento prévio de bancos de dados, SQL, Python ou programação. Qualquer pessoa pode assistir a este curso gratuitamente. Se você optar por fazer este curso e obter o certificado do Coursera, também poderá obter um selo digital da IBM após a conclusão do curso. OFERTA POR TEMPO LIMITADO: a assinatura custa apenas US$ 39 por mês para obter acesso a materiais avaliados e um certificado.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Aimed at learners with no background in relational database or SQL, this course acclimatizes beginners to this field

Provides balanced practical and theoretical exposure to SQL

Apt for Data Science career-seekers seeking a foundation in SQL and relational databases

Emphasizes hands-on learning through practical assignments and Jupyter notebook-based exercises

Instructors have an established reputation in the realm of Data Science and SQL

Optional certificate and digital badge available from IBM upon completion

Reviews summary

Practical sql mastery for data science

This course on 'Databases and SQL for Data Science' has middling reviews at 68/100. Though many enjoyed the course, a common gripe is trouble with registration, IBM cloud account creation issues, and issues with old instructions that don't work with newer versions of the platform. Despite these issues, reviews note that this course is fairly well-produced, with engaging lessons and teachers. Many students appreciated the hands-on approach and were able to learn more about the creation and implementation of databases. If you're looking to improve your SQL skills for data science, you may find this course helpful despite the technical issues some reviewers encountered.

Engaging, interactive learning

"A ênfase neste curso está no aprendizado prático e participativo."

"Como tal, você trabalhará com bancos de dados reais, ferramentas de ciência de dados reais e conjuntos de dados do mundo real."

Solid base in SQL for data science

"Curso abrange conceitos praticos e teoricos nas aulas, possuindo ambientes para desenvolver as habilidades necessarias para o final do curso."

"Excelente curso para dar inicio ao aprendizado de SQL, com um bom complemento de banco de dados e primeiros passos em acesso por python"

Instructions not up-to-date with platform changes

"O curso tinha tudo para ser excelente, porém vários estudantes do curso estão passando por problemas no momento de cadastrar o IBM cloud lite, erro no cadastro do cartão de crédito."

"Isso impossibilita o prosseguimento do curso, já que a parte prática fica comprometida."

Difficulties with IBM Cloud account setup

"Não consigo dar continuidade no curso pq não consigo criar minha conta gratuita no site da ibm cloud, já tentei por várias vezes o suporte da ibm e o suporte da coursera e não consigo contato com nada que não seja um robô."

"Não consegui fazer uma conta gratuita na IBM, o site fica pedindo cartão de crédito e mesmo colocando as informações dá erro e não consegui acessar o Cloud para a realização dos exercícios práticos."

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 Bancos de dados e SQL para Ciência de Dados with these activities:

Read 'SQL for Data Analysis' by Allen Downey

Show steps

This book provides a comprehensive overview of SQL and its applications in data analysis, which will supplement and reinforce the concepts covered in the course.

View Think Bayes on Amazon

Show steps

Read the book's chapters and work through the exercises.
Take notes and highlight important concepts.

Join a Study Group

Show steps

Engage with peers to clarify concepts, share insights, and enhance your learning through collaborative discussions.

Show steps

Find or create a study group with fellow learners.
Meet regularly to review course materials, discuss exercises, and prepare for assessments.
Share knowledge, perspectives, and resources with the group.

Build a database structure

Show steps

Get hands-on practice building a database structure to reinforce and apply your understanding of database concepts.

Show steps

Choose a project scope and define the data requirements.
Create tables and define columns with appropriate data types and constraints.
Establish relationships between tables using foreign keys.
Insert sample data to populate the database.

Nine other activities

Expand to see all activities and additional details

Show all 12 activities

Use SQL to Query Data

Show steps

Strengthen your SQL skills by following guided tutorials on data querying and manipulation.

Browse courses on SQL Queries

Show steps

Identify the tutorials that align with your learning goals.
Follow the instructions to create queries and extract data.
Practice writing different types of queries, such as SELECT, WHERE, and JOIN.

Practice SQL queries on sample databases

Show steps

This activity will help you solidify your understanding of SQL syntax and data retrieval.

Browse courses on SQL

Show steps

Choose a sample database that is relevant to your interests.
Write SQL queries to retrieve specific data from the database.
Test your queries and refine them as needed.

Follow online tutorials on SQL from reputable sources

Show steps

These tutorials will provide additional practice and guidance on specific SQL concepts and techniques.

Browse courses on SQL

Show steps

Identify and select reputable tutorials from online platforms or documentation.
Follow the tutorials step-by-step and complete any exercises.
Take notes or summarize the key takeaways.

Join a study group or participate in online forums

Show steps

Engaging with peers can provide valuable insights, foster collaboration, and clarify concepts.

Browse courses on SQL

Show steps

Join online discussion forums or study groups related to SQL.
Participate in discussions, ask questions, and share knowledge.

Attend workshops or online events focused on SQL

Show steps

Workshops and events provide opportunities for in-depth learning, networking, and exposure to industry experts.

Browse courses on SQL

Show steps

Identify relevant workshops or online events.
Register and attend the events.
Engage with speakers, ask questions, and learn from others.

Create a SQL cheat sheet or reference guide

Show steps

This activity will help you consolidate your knowledge of SQL commands and syntax, making them easily accessible for quick reference.

Browse courses on SQL

Show steps

Compile a list of essential SQL commands and their usage.
Organize the commands into a logical structure.
Format the cheat sheet visually for easy readability.

Develop a Data Analysis Project

Show steps

Apply your SQL and data analysis skills to a practical project, solidifying your understanding and showcasing your abilities.

Browse courses on Data Analysis

Show steps

Define the project scope and objectives.
Collect and prepare the required data.
Perform data analysis using SQL queries and visualizations.
Create a report or presentation to summarize your findings.

Solve coding challenges involving SQL queries

Show steps

These challenges will test your problem-solving skills and ability to apply SQL concepts in practical scenarios.

Browse courses on SQL

Show steps

Find coding challenges on platforms such as LeetCode or HackerRank.
Analyze the problem and identify the data retrieval requirements.
Write efficient and optimized SQL queries to solve the challenges.

Build a data analysis project using SQL

Show steps

This project will provide you with hands-on experience in applying SQL skills to real-world data analysis tasks.

Browse courses on SQL

Show steps

Identify a dataset and define a problem statement.
Explore the data using SQL queries and visualizations.
Develop insights and draw conclusions from the data analysis.

Career center

Learners who complete Bancos de dados e SQL para Ciência de Dados will develop knowledge and skills that may be useful to these careers:

Data Analyst

A Data Analyst collects, processes, and analyzes data to extract meaningful insights. They use their findings to help businesses make better decisions. SQL is a key tool for Data Analysts, as it allows them to query and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as a Data Analyst by teaching you how to create and execute queries, build data models, and analyze data.

See salaries and explore the career path for Data Analyst

Database Administrator

A Database Administrator (DBA) is responsible for the maintenance and performance of databases. They ensure that databases are available, secure, and performant. SQL is a key tool for DBAs, as it allows them to manage and troubleshoot databases. This course can help you develop the SQL skills you need to succeed as a DBA by teaching you how to create and manage databases, optimize performance, and secure data.

See salaries and explore the career path for Database Administrator

Data Scientist

A Data Scientist uses data to solve business problems. They use a variety of techniques, including statistics, machine learning, and data visualization. SQL is a key tool for Data Scientists, as it allows them to access and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as a Data Scientist by teaching you how to query and manipulate data, build data models, and analyze data.

See salaries and explore the career path for Data Scientist

Data Engineer

A Data Engineer builds and maintains data pipelines. They use a variety of tools and technologies, including SQL. SQL is a key tool for Data Engineers, as it allows them to access and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as a Data Engineer by teaching you how to create and execute queries, build data models, and analyze data.

See salaries and explore the career path for Data Engineer

Software Engineer

A Software Engineer designs, develops, and tests software applications. They use a variety of programming languages and technologies, including SQL. SQL is a key tool for Software Engineers, as it allows them to access and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as a Software Engineer by teaching you how to create and execute queries, build data models, and analyze data.

See salaries and explore the career path for Software Engineer

Risk Manager

A Risk Manager assesses risk and uncertainty. They use their findings to help businesses make better decisions. SQL is a key tool for Risk Managers, as it allows them to access and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as a Risk Manager by teaching you how to create and execute queries, build data models, and analyze data.

See salaries and explore the career path for Risk Manager

Epidemiologist

An Epidemiologist investigates the causes and distribution of diseases. They use their findings to help public health officials make better decisions. SQL is a key tool for Epidemiologists, as it allows them to access and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as an Epidemiologist by teaching you how to create and execute queries, build data models, and analyze data.

See salaries and explore the career path for Epidemiologist

Forensic Accountant

A Forensic Accountant investigates financial crimes. They use their findings to help law enforcement and businesses bring criminals to justice. SQL is a key tool for Forensic Accountants, as it allows them to access and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as a Forensic Accountant by teaching you how to create and execute queries, build data models, and analyze data.

See salaries and explore the career path for Forensic Accountant

Market Researcher

A Market Researcher studies the market to understand consumer behavior. They use their findings to help businesses make better decisions. SQL is a key tool for Market Researchers, as it allows them to access and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as a Market Researcher by teaching you how to create and execute queries, build data models, and analyze data.

See salaries and explore the career path for Market Researcher

Health Data Analyst

A Health Data Analyst analyzes health data to identify trends and patterns. They use their findings to help healthcare providers make better decisions. SQL is a key tool for Health Data Analysts, as it allows them to access and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as a Health Data Analyst by teaching you how to create and execute queries, build data models, and analyze data.

See salaries and explore the career path for Health Data Analyst

Data Journalist

A Data Journalist uses data to tell stories. They use their findings to help the public understand important issues. SQL is a key tool for Data Journalists, as it allows them to access and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as a Data Journalist by teaching you how to create and execute queries, build data models, and analyze data.

See salaries and explore the career path for Data Journalist

Business Analyst

A Business Analyst analyzes business data to identify trends and patterns. They use their findings to help businesses make better decisions. SQL is a key tool for Business Analysts, as it allows them to query and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as a Business Analyst by teaching you how to create and execute queries, build data models, and analyze data.

See salaries and explore the career path for Business Analyst

Statistician

A Statistician collects, analyzes, and interprets data. They use their findings to help businesses make better decisions. SQL is a key tool for Statisticians, as it allows them to access and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as a Statistician by teaching you how to create and execute queries, build data models, and analyze data.

See salaries and explore the career path for Statistician

Quantitative Analyst

A Quantitative Analyst (Quant) uses mathematical and statistical models to analyze financial data. They use their findings to help businesses make investment decisions. SQL is a key tool for Quants, as it allows them to access and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as a Quant by teaching you how to query and manipulate data, build data models, and analyze data.

See salaries and explore the career path for Quantitative Analyst

Actuary

An Actuary assesses risk and uncertainty. They use their findings to help businesses make better decisions. SQL is a key tool for Actuaries, as it allows them to access and manipulate data from databases. This course can help you develop the SQL skills you need to succeed as an Actuary by teaching you how to create and execute queries, build data models, and analyze data.

See salaries and explore the career path for Actuary