Scribd
Upload
91 views1 page

SQL in Action: Basics and Queries

This document provides an introduction to Structured Query Language (SQL) and how it allows users to query and extract information from databases. It explains that SQL follows a unique syntax that queries must adhere to in order to be properly executed. The reading defines a query as a request for data or information from a database, and notes that the foundation of every SQL query uses SELECT to choose which fields to return and FROM to choose the tables where those fields are located.

Uploaded by

Nhi Le
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
91 views1 page

SQL in Action: Basics and Queries

This document provides an introduction to Structured Query Language (SQL) and how it allows users to query and extract information from databases. It explains that SQL follows a unique syntax that queries must adhere to in order to be properly executed. The reading defines a query as a request for data or information from a database, and notes that the foundation of every SQL query uses SELECT to choose which fields to return and FROM to choose the tables where those fields are located.

Uploaded by

Nhi Le
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

More about SQL in action | Coursera 3/15/21, 10)44 AM

Introducing more about


core data tools

Video: The ins and outs of


core data tools
2 min
More about SQL in actio
Mastering spreadsheet
Just as humans use different languages to communicate
basics
others, so do computers. Structured Query Language (o
Video: Columns and rows sometimes pronounced as “sequel”) lets data analysts ta
and cells, oh my! databases. SQL is one of the most useful data analyst to
9 min especially when you are working with large datasets in t
can help you investigate huge databases, track down str
Discussion Prompt: numbers, and filter for the exact kind of data you need—
Spreadsheets in daily life
faster than a spreadsheet can. In this reading, we will go
10 min
basics of using SQL and explore an example query to
demonstrate how SQL works in action.
Practice Quiz: Hands-On
Activity: Generating a chart
from a spreadsheet
1 question Basic syntax for SQL
Reading: More spreadsheet Every programming language, including SQL, has to follo
resources unique set of guidelines known as syntax. As soon as yo
10 min your search criteria using the correct syntax, the query s
start working to pull the information you have requeste
Discussion Prompt: Share
the target database.
your chart
10 min

Practice Quiz: Test your


What is a query?
knowledge on spreadsheet
A query is basically a request for data or information fro
basics
database. For example, ''Tell me how many comedy mo
3 questions
made in 1985” or ''How many people live in Puerto Rico?
Learn about Structured we query databases, we use SQL to communicate our q
Query Language (SQL) request. Both the user and the database can always exc
information as long as you “speak” the same language.
Video: SQL in action
3 min

The foundation of every SQL query is the same:


Reading: More about SQL in
action Use SELECT to choose the fields you want to return
10 min
Use FROM to choose the tables where the fields yo

[Link] Page 1 of 1

You might also like