Explore
For Enterprise
Join for Free
Log In

Artes e Humanas
Negócios
Ciência da Computação
Ciência de Dados
Tecnologia da informação
da saúdesaúde
Matemática e Lógica
Desenvolvimento Pessoal
Ciência e Engenharia Física
Ciências Sociais
Línguas
Diplomas e certificados

Explore todo o Coursera

Navegar
Pesquisar
For Enterprise
Entrar
Inscreva-se gratuitamente

SELECT Statement

Loading...

Databases and SQL for Data Science

4.7 (3,760 classificações) | 41K alunos inscritos

Curso 1 de 9 no Certificado profissional em ciência de dados da IBM Programa de cursos integrados

Visualizar o programa do curso

Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. A working knowledge of databases and SQL is a must if you want to become a data scientist. The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL language. It is also intended to get you started with performing SQL access in a data science environment. The emphasis in this course is on hands-on and practical learning . As such, you will work with real databases, real data science tools, and real-world datasets. You will create a database instance in the cloud. Through a series of hands-on labs you will practice building and running SQL queries. You will also learn how to access databases from Jupyter notebooks using SQL and Python. No prior knowledge of databases, SQL, Python, or programming is required. Anyone can audit this course at no-charge. If you choose to take this course and earn the Coursera course certificate, you can also earn an IBM digital badge upon successful completion of the course. LIMITED TIME OFFER: Subscription is only $39 USD per month for access to graded materials and a certificate.

Habilidades que você aprenderá

Cloud Databases, Python Programming, Ipython, Relational Database Management System (RDBMS), SQL

Avaliações

4.7 (3,760 classificações)

5 stars
2,836 ratings
4 stars
692 ratings
3 stars
158 ratings
2 stars
41 ratings
1 star
33 ratings

DT

Jun 17, 2019

This is a great review of an important topic. If I knew how much this mattered for the advanced capstone course I would have paid more attention. As it was, I came back here frequently.

LG

Mar 06, 2019

I really liked this course and it is worth it for learning basic SQL queries with Python. I wish we could have more practical exercises but on the whole this was an excellent course.

Na lição

Week 1 - Introduction to Databases and Basic SQL

In Week 1 you will be introduced to databases. You will create a database instance on the cloud. You will learn some of the basic SQL statements. You will also write and practice basic SQL hands-on on a live database.

CREATE Table Statement2:51

SELECT Statement3:36

COUNT, DISTINCT, LIMIT2:30

INSERT Statement2:36

UPDATE and DELETE Statements3:12

Ministrado por

Rav Ahuja
Data Science Program Manager

Hello and welcome to retrieving data with a SELECT statement.

In this video, we will learn about retrieving data from

a relational database table by selecting columns of a table.

At the end of this lesson,

you will be able to retrieve data from a relational database table,

to find the use of a predicate,

identify the syntax of the SELECT statement using the WHERE clause and

list the comparison operators supported by a relational database management system.

The main purpose of a database management system,

is not just to store the data but also facilitate retrieval of the data.

So, after creating a relational database table and inserting data into the table,

we want to see the data.

To see the data, we use the SELECT statement.

The SELECT statement is a data manipulation language statement.

Data Manipulation Language statements or DML statements are used to read and modify data.

The SELECT statement is called a query,

and the output we get from executing this query is called a result set or a result table.

In its simplest form, a SELECT statement is select star from table name.

Based on the book entity example,

we would create the table using

the entity name book and the entity attributes as the columns of the table.

The data would be added to the book table by adding

rows to the table using the insert statement.

In the book entity example select star from book gives the result set of four rows.

All the data rows for all columns in the table book are displayed.

In addition, you can also retrieve all the rows for all columns by

specifying the column names individually in the SELECT statement.

You don't always have to retrieve all the columns in a table.

You can retrieve just a subset of columns.

If you want, you can retrieve just two columns from the table book.

For example book_id and title.

In this case, the select statement is select book_id, title from book.

In this case, only the two columns display for each of the four rows.

Also notice that the order of the columns displayed

always matches the order in the SELECT statement.

However, what if we want to know the title of the book whose book_id is B1.

Relational operation helps us in restricting

the result set by allowing us to use the clause WHERE.

The WHERE clause always requires a predicate.

A predicate is conditioned evaluates to true, false or unknown.

Predicates are used in the search condition of the WHERE clause.

So, if we need to know the title of the book whose book_id is B1,

we use the WHERE clause with the predicate book_id equals B1.

Select book_id title from book where book_id equals B1.

Notice the result set is now restricted to

just one row whose condition evaluates to true.

The previous example used comparison operator equal to in the WHERE clause.

There are other comparison operators supported by

a relational database management system; equal to,

greater than, less than,

greater than or equal to,

less than or equal to and not equal to.

Now you can retrieve data and select columns from a relational database table,

define the use of a predicate,

identify the syntax of the SELECT statement using the WHERE clause and

list the comparison operators supported by a relational database management system.

Thanks for watching this video.

Explore nosso catálogo

Registre-se gratuitamente e obtenha recomendações, atualizações e ofertas personalizadas.

O Coursera proporciona acesso universal à melhor educação do mundo fazendo parcerias com as melhores universidades e organizações para oferecer cursos on-line.

© 2019 Coursera Inc. Todos os direitos reservados.

Baixar na App Store

Baixar no Google Play

Coursera
Sobre
Liderança
Carreiras
Lista de cursos
Certificados
Certificados MasterTrack™
Notas
For Enterprise
For Government

Comunidade
Learners
Partners
Developers
Beta Testers
Translators

Conectar
Blog
Facebook
LinkedIn
Twitter
Instagram
YouTube
Tech Blog

Mais
Termos
Privacidade
Ajuda
Acessibilidade
Imprensa
Contato
Diretório
Afiliados