Database Star: Home

SQL Concatenate: A How-To Guide with Examples

Jul 24, 2019 · 3 min read · sql ·

String concatenation is the process of joining two string values together. Let's see how to do it in several different databases.

SQL Wildcards

Jul 22, 2019 · 5 min read · sql ·

Share on:

Wildcards are a useful technique when working with strings in SQL. Learn all about them and see some examples in this article.

SQL Transactions and Isolation Levels: The Ultimate Guide

Jul 18, 2019 · 20 min read ·

Share on:

Transactions are an important part of SQL and the databases they run on. Learn all about SQL transactions in this guide.

What is a Database Schema?

Jul 14, 2019 · 4 min read ·

Share on:

The term "database schema" has a few different meanings. Let's look further into these definitions.

Oracle 1Z0-071 Exam Guide and FAQ (OCA Certification)

May 28, 2019 · 9 min read · sql ·

Share on:

Learn all about the 1Z0-071 exam.

SQL Alias: A Guide to the SQL Aliases and the SQL AS Keyword

Apr 23, 2019 · 9 min read · sql ·

Share on:

Learn what an SQL alias is in this guide.

SQL WHERE Clause: Guide and Examples

Apr 10, 2019 · 8 min read · sql ·

Share on:

In this article, you'll learn what the WHERE clause is in SQL, how to use it, and see some examples.

SQL CTE (WITH Clause): The Ultimate Guide

Apr 1, 2019 · 20 min read · sql ·

Share on:

In this article, you'll learn all about the Common Table Expression, what it's good for, and how to use it.

132 Computer Science Faculty Share Their Advice for New CS Students

Mar 5, 2019 · 35 min read · career-plan ·

Share on:

I contacted 132 different Computer Science professors and lecturers and asked them for an answer to one question.

How to Create a Connection and Set Up Data for the Introduction to Oracle SQL Course

Jan 9, 2019 · 7 min read ·

Share on:

This post will show you how to set up the sample user and sample data for my Introduction to Oracle SQL course.