What is an alias in SQL?
It’s a name you give to a column or a table in your SQL query to make it easier to display the results or to write your query.
SQL aliases are a useful feature and are available in all major database vendors, including Oracle, SQL Server, MySQL, PostgreSQL.
There are two types of aliases in SQL: column aliases and table aliases.
In this article, you’ll learn what the WHERE clause is in SQL, how to use it, and see some examples.
A Common Table Expression (or CTE) is a feature in several SQL versions to improve the maintainability and readability of an SQL query.
It goes by a few names:
- Common Table Expression
- Subquery Factoring
- SQL WITH Clause
In this article, you’ll learn all about the Common Table Expression, what it’s good for, and how to use it.
Starting a Computer Science course can be daunting to new students.
There are a lot of new concepts to learn. A new environment to settle in to. And depending on your college, there can be a lot of services offered to students.
I contacted 132 different Computer Science professors and lecturers and asked them for an answer to one question:
If you could offer one piece of advice to new Computer Science students, what would it be?
Let me tell you, the insights I received from these professors and lecturers were nothing short of amazing. I’ve listed all of them below.
I’ve also extracted the most common pieces of advice into a summary for you.
This post will show you how to set up the sample user and sample data for my Introduction to Oracle SQL course.
PL/SQL Tutorial Chapter 7: Nested Blocks and Packages
In this section, you’ll learn:
- What nested blocks are and how to create them
- What packages are, why you should use them, and how to create them
PL/SQL Tutorial Chapter 6: Record Types and Bulk Collect
In this chapter, we’ll learn about:
- Using data types based on tables and columns
- Understanding what collections are
- Using the BULK COLLECT keyword to fetch data in bulk
These are all great features of the PL/SQL language and will take your code to the next level.
PL/SQL Tutorial Chapter 5: Cursors, Arrays, and Bulk Collect
In this chapter, we’ll learn about some pretty useful concepts in PL/SQL:
- What a cursor is
- The two types of cursors
- Inserting, updating, and deleting data in tables using PL/SQL
- Selecting data from a table into PL/SQL
- What an array is and how to use one
PL/SQL Chapter 4: Procedures, Functions, and Exceptions
In this chapter, you’ll learn:
- What procedures and functions are
- How to create a procedure
- How to create a function
- What an exception is and how to handle one
Let’s get started!
PL/SQL Tutorial Chapter 3: Conditions and Loops
In this chapter, you’ll learn about:
- Conditions (If, Then, Else)
- Commenting Code
These are common features of other programming languages, and PL/SQL lets you use these features as well.