Loading...

Follow Database Star on Feedspot

Continue with Google
Continue with Facebook
or

Valid

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 […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In this article, you’ll learn what the WHERE clause is in SQL, how to use it, and see some examples. Description The SQL WHERE clause allows you to filter the results used in your query. It lets you specify the rows that will be used. The WHERE clause can be used with several statements: SELECT […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 129 different Computer Science professors and lecturers and asked them for […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This post will show you how to set up the sample user and sample data for my Introduction to Oracle SQL course. If you’re enrolled in my Introduction to Oracle SQL course either on Udemy, on YouTube, or inside the Database Star Academy, you’ll find that one of the first steps is to set up […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Read Full Article

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview