Bancos de dados e SQL para Ciência de Dados (Coursera)

Offered by IBM,
Bancos de dados e SQL para Ciência de Dados (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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

What You Will Learn

  • Crie e acesse uma instância de banco de dados na nuvem
  • Escreva instruções básicas de SQL: Create, Drop, Select, Insert, Update, Delete
  • Filtre, classifique, agrupe resultados, use funções integradas, acesse várias tabelas
  • Acesse bancos de dados do Jupyter usando Python e trabalhe com conjuntos de dados do mundo real

Syllabus

WEEK 1
Introdução a bancos de dados e SQL básico
Na semana 1, você será apresentado aos bancos de dados. Você criará uma instância de banco de dados na nuvem. Você aprenderá algumas das instruções SQL básicas. Você também escreverá e praticará SQL básico em um banco de dados ativo.

WEEK 2
SQL avançado
Ao final deste módulo, você aprenderá o seguinte: (1) Aprenderá a usar padrões e intervalos de string para pesquisar dados e como classificar e agrupar dados em conjuntos de resultados. (2) Aprenderá a trabalhar com várias tabelas em um banco de dados relacional usando operações de junção.

WEEK 3
Como acessar bancos de dados usando Python
Depois de concluir as lições desta semana, você aprenderá como explicar os conceitos básicos relacionados ao uso de Python para se conectar a bancos de dados e, em seguida, criar tabelas, carregar dados, consultar dados usando SQL e analisar dados usando Python

WEEK 4
Tarefa do curso
Como uma tarefa prática de Ciência de Dados, você trabalhará com vários conjuntos de dados do mundo real para a cidade de Chicago. Serão feitas perguntas que o ajudarão a entender os dados da mesma forma que um cientista de dados faria. Você será avaliado quanto à exatidão de suas consultas SQL e resultados.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Introduction to MongoDB (Coursera) Coursera
MongoDB University

Introduction to MongoDB (Coursera)

"Introduction to MongoDB" guides you through the foundational skills and knowledge you need to get started with MongoDB. Get an introduction to MongoDB Atlas, the developer data platform, and how to create and deploy an Atlas cluster. Discover how MongoDB structures data in documents similar to JSON objects, making it flexible and developer friendly.

Aug 17th 2026
4 Weeks
Introduction to Open Source Application Development (Coursera) Coursera
Illinois Tech

Introduction to Open Source Application Development (Coursera)

This course introduces basic concepts of systems programming using a modern open source language. You will learn to apply basic programming concepts toward solving problems, writing pseudocode, working with and effectively using basic data types, abstract data types, control structures, code modularization and arrays. You will learn to detect errors, work with variables and loops, and discover how functions, methods, and operators work with different data types. You will also be introduced to the object paradigm including classes, inheritance, and polymorphism.

Aug 17th 2026
5-12 Weeks
Understanding and Applying Text Embeddings (Coursera) Coursera
DeepLearning.AI

Understanding and Applying Text Embeddings (Coursera)

The Vertex AI Text-Embeddings API enhances the process of generating text embeddings. These text embeddings, which are numerical representations of text, play a pivotal role in many tasks involving the identification of similar items, like Google searches, online shopping recommendations, and personalized music suggestions.

Aug 17th 2026
1 Week
Experimentation for Improvement (Coursera) Coursera
McMaster University

Experimentation for Improvement (Coursera)

We are always using experiments to improve our lives, our community, and our work. Are you doing it efficiently? Or are you (incorrectly) changing one thing at a time and hoping for the best? In this course, you will learn how to plan efficient experiments - testing with many variables. Our goal is to find the best results using only a few experiments. A key part of the course is how to optimize a system.

Aug 17th 2026
5-12 Weeks
Programming and Application Foundations (Coursera) Coursera
Illinois Tech

Programming and Application Foundations (Coursera)

This course introduces the students to the creation and deployment of modern, standards-compliant web pages written in HTML, CSS, and JavaScript in the context of the client-server architecture of the web. The course also covers the fundamentals of programming in a modern programming language, basic data modeling, database design, implementation, and administration of single-user and shared multi-user database applications using a contemporary relational database management system.

Aug 17th 2026
5-12 Weeks
Getting Started with Apache Cassandra (Coursera) Coursera
Whizlabs

Getting Started with Apache Cassandra (Coursera)

The “Getting Started with Cassandra” course is designed to help you gain knowledge of the Cassandra database system. You will learn architecture as well as how to design, build and use Cassandra databases. This training course helps you develop your skills and knowledge in Cassandra. Cassandra is a NoSQL database that has the traits of a distributed, open-source, and decentralized database or storage system. It can support the management of excessively massive amounts of structured data without a single point of failure, thereby resulting in the provision of highly available services.

Aug 17th 2026
3 Weeks
Introduction to Software, Programming, and Databases (Coursera) Coursera
IBM

Introduction to Software, Programming, and Databases (Coursera)

There are many types of software and understanding software can be overwhelming. This course aims to help you understand more about the types of software and how to manage software from an information technology (IT) perspective. This course will help you understand the basics of software, cloud computing, web browsers, development and concepts of software, programming languages, and database basics.

Aug 17th 2026
5-12 Weeks
Snowflake - SnowPro Core Certification Preparation (Coursera) Coursera
Board Infinity

Snowflake - SnowPro Core Certification Preparation (Coursera)

"Snowflake - SnowPro Core Certification Preparation" is a comprehensive course meticulously crafted to guide learners through the essentials of Snowflake, preparing them for the SnowPro Core Certification. Spanning three modules, the course begins with the fundamentals of Snowflake, exploring its architecture, data loading, and modeling. The second module delves into operational and management aspects, including account management, performance optimization, and security.

Aug 17th 2026
3 Weeks
Big Data Analysis with Scala and Spark (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Big Data Analysis with Scala and Spark (Coursera)

Manipulating big data distributed over a cluster using functional concepts is rampant in industry, and is arguably one of the first widespread industrial uses of functional ideas. This is evidenced by the popularity of MapReduce and Hadoop, and most recently Apache Spark, a fast, in-memory distributed collections framework written in Scala. In this course, we'll see how the data parallel paradigm can be extended to the distributed case, using Spark throughout.

Aug 17th 2026
4 Weeks