Class notes
SQL BASICS
- Course
- Institution
In this notes, we cover the basics of using SQL to retrieve data stored in relational databases.
[Show more]
Seller
Follow
akshayazone
Content preview
SQL BASICSBasic SQL :
In this video, we cover the basics of using SQL to retrieve data
stored in relational databases. The first thing you need to know
is how to get all the data from one table. To do this in SQL, you
use the SELECT * statement. For example, SELECT * FROM
customers; will retrieve all the data from
the customers table.
Note that there are different data types in SQL, such as strings
and integers. You can also perform aggregation functions like
getting averages or maximum/minimum values.
Filtering Data with the WHERE Clause
If you want to filter the results by a specific condition, you can
use the WHERE clause. For example, SELECT * FROM
customers WHERE customer_name='Alfred\'s
Futterkist'; will retrieve all the columns for the customer
with the name 'Alfred's Futterkist'.
You can use the % sign as a wildcard to match patterns. For
example, SELECT * FROM customers WHERE customer_name
LIKE 'Alf%'; will match any customer whose name starts
with 'Alf'.
Pattern Matching and Aggregations in SQL
SQL offers a variety of operations, including pattern matching
and aggregations, to data scientists. Pattern matching is not
case sensitive and can be used with other types of data, but is
often used with dates. For example,
selecting start from orders where order date is between
"1996" and "1997" will return all of the data from 1997 but not
from 1996. Aggregations, such as avg , count , min ,
and max , are used to compute numerical values from data.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller akshayazone. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79223 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now