Writing Simple SELECT Queries
SQL select statements are essential for retrieving data from databases. This tutorial covers five fundamental select queries in SQL, demonstrating how to select all columns, specific columns, distinct values, use aliases, and perform arithmetic operations.
Lets Go!

Writing Simple SELECT Queries
Lesson 8
Understand the purpose of the SELECT statement in SQL. Learn how to retrieve data from a table.
Get Started 🍁Introduction to SQL Queries
Welcome to the "Introduction to SQL Queries" course!
In this course, we will delve into the world of SQL queries to manipulate and extract data from databases effectively. SQL (Structured Query Language) is a powerful tool used by data professionals to interact with databases and retrieve specific information based on various criteria.
Have you ever wondered how data professionals extract specific information from a vast database? How can you filter out only the necessary data without overwhelming yourself with irrelevant details?
Throughout this course, we will cover essential SQL query concepts, starting with basic SELECT statements and gradually moving on to more advanced techniques. By the end of the course, you will have a solid foundation in SQL queries, enabling you to extract, analyze, and manipulate data efficiently.
No prior experience with SQL is required to enroll in this course. We will start from the basics and gradually progress to more complex queries. All you need is a curious mind and a willingness to learn!
Are you ready to dive into the world of SQL queries and unleash the power of data manipulation? Join us on this exciting journey, and let's explore the fascinating realm of SQL together!
Main Concepts of SQL
-
Select All Query: The
SELECT * FROM
query retrieves all columns from a specified table in a database. The*
symbol is used to indicate that all columns should be selected. -
Select Specific Columns: By specifying column names after the
SELECT
keyword, you can choose to retrieve only certain columns from a table, such asSELECT first name, last name FROM employees
. -
Distinct Values: The
DISTINCT
keyword retrieves unique values from a specified column in a table. For example,SELECT DISTINCT title of courtesy FROM employees
will display all unique titles of courtesy in the table. -
Aliases: Aliases can be used to rename column headers in SQL queries. For instance,
SELECT address AS Street, postal code AS Zip Code FROM employees
changes the column titles toStreet
andZip Code
. -
Arithmetic Operations: SQL allows for arithmetic operations to be performed within
SELECT
statements. For example,ship date - order date
calculates the difference between two dates. Parentheses can also be used to specify the order of operations, like(order date * 3)
.
Practical Applications of SQL Basics
Let's try out some basic SQL select queries using PG Admin 4 and the Northwind database. Follow these step-by-step instructions to perform different queries:
-
Select All Data from a Table
- Type the following query in the query tool:
SELECT * FROM employees;
- Click the play button or press F5 to execute the query.
- Explore all the information from the "employees" table.
- Type the following query in the query tool:
-
Select Specific Columns
- To select only specific columns like first name and last name, use this query:
SELECT first name, last name FROM employees;
- Execute the query to view the selected columns' data.
- To select only specific columns like first name and last name, use this query:
-
Retrieve Unique Values
- Use the
DISTINCT
command to fetch only unique values like titles of courtesy:SELECT DISTINCT title of courtesy FROM employees;
- View the distinct values in the specified column.
- Use the
-
Add Aliases to Columns
- Rename columns using aliases like "street" for "address" and "zip code" for "postal code":
SELECT address AS street, postal code AS zip code FROM employees;
- Execute the query and observe the renamed column titles.
- Rename columns using aliases like "street" for "address" and "zip code" for "postal code":
-
Perform Arithmetic Operations
-
Calculate the difference between dates or perform arithmetic operations in the select statement:
SELECT ship date - order date FROM orders;
-
Execute the query to see the calculated results.
Remember to utilize parentheses for correct order of operations in arithmetic expressions. As you try out these queries, explore and analyze different data sets to enhance your SQL skills. Start by executing these queries in PG Admin 4 with the Northwind database.
-
I encourage you to practice these queries with your preferred database and experiment with different modifications to deepen your understanding of SQL fundamentals. Have fun coding! 🚀
Test your Knowledge
What does the SELECT statement do in SQL?
What does the SELECT statement do in SQL?
Advanced Insights into SQL
In SQL, beyond the basic select statements covered in the video, there are several advanced aspects and deeper insights to explore.
1. Utilizing DISTINCT for Unique Results
When working with select statements, you can use the DISTINCT
keyword to retrieve unique values from a column. This can be valuable when you want to see distinct entries and avoid duplicates. Try using DISTINCT
in your queries to refine your data further.
Curiosity Question: How can you combine DISTINCT
with other SQL commands to enhance your data querying process?
2. Harnessing Aliases for Column Naming
Aliases allow you to rename columns in your SQL output, providing clarity and customization. By using aliases, you can make your results more intuitive and readable. Experiment with different alias names to see how they can enhance the presentation of your data.
Curiosity Question: What are some creative ways you can leverage aliases to improve the readability of your SQL query results?
3. Performing Arithmetic Operations in Select Statements
In SQL select statements, you can perform arithmetic operations on columns to derive new insights. Whether calculating date differences or applying mathematical operations, arithmetic in SQL enables in-depth analysis of your data. Remember to use parentheses to control the order of operations and ensure accurate results.
Curiosity Question: How can arithmetic operations in SQL select statements help you uncover trends or patterns in your datasets?
By delving into these advanced insights and exploring the nuances of SQL select statements, you can elevate your data querying skills and uncover valuable information from your databases. Happy querying!
Additional Resources for SQL Queries
- SQL Tutorial - A comprehensive guide to learning SQL from basic to advanced concepts.
- SQLZoo - Interactive SQL tutorials to practice and enhance your SQL query skills.
- SQL Query Examples - Explore a variety of SQL query examples from Microsoft's official documentation.
- Codecademy SQL Course - A hands-on course to learn SQL through interactive exercises.
- SQL For Beginners: How to Write Your First Query - An article providing a step-by-step guide to writing your first SQL query.
Dive deeper into SQL queries by exploring these resources. Enhance your understanding and practice your skills to become proficient in SQL querying!
Practice
Task: Create a table with sample data (e.g., a products table with columns like id, name, price).
Task: Write a query to select all columns and another to select specific columns from the table.