HEC Paris
Drive innovation in your organization
Earn a high-quality career credential and credit towards a Master’s Degree
HEC Paris
Webinar: It’s Time to Reinvent Your Business Model
Join us April 14 to learn about reinventing business models from an MSIE professor.

Explore todo o Coursera

Navegar
Os melhores cursos
Entrar
Inscreva-se gratuitamente

SELECT Statement

Loading...

Databases and SQL for Data Science

4.7 (9,162 classificações) | 96K alunos inscritos

Curso 5 de 9 no Ciência de dados da IBM Programa de cursos integrados

Cadastre-se gratuitamente

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.

Visualizar o programa do curso

Habilidades que você aprenderá

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

Avaliações

4.7 (9,162 classificações)

5 stars
75%
4 stars
19%
3 stars
4%
2 stars
1%
1 star
1%

SG

Dec 25, 2019

One of the best course I completed on Coursera. All the learning material is well organised and easy to understand. Also the non-graded sections regarding relational databases are interesting.

YM

Mar 22, 2020

Great introduction to basic manipulation of SQL tables and working with the IBM DB2 databases by connecting to them with iPython. Very straightforward explanations and very enjoyable tasks.

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
AI and Data Science Program Director

Experimente o curso Gratuito

Transcrição

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.

Coursera

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

Comunidade

Aprendizes
Parceiros
Desenvolvedores
Testadores beta
Tradutores
Blog
Tech Blog

Mais

Termos
Privacidade
Ajuda
Acessibilidade
Imprensa
Contato
Diretório
Afiliados

Aplicativo móvel

© 2020 Coursera Inc. Todos os direitos reservados.