Warning: Declaration of TCB_Menu_Walker::walk($elements, $max_depth) should be compatible with Walker::walk($elements, $max_depth, ...$args) in /home/databas6/public_html/databasestar/wp-content/plugins/thrive-visual-editor/inc/classes/class-tcb-menu-walker.php on line 0
Database Star - Database Star
Oracle 1Z0-071 Exam Guide and FAQ (OCA Certification)

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

Are you interested in getting the Oracle Certified SQL Associate certification, and passing the 1Z0-071 exam?

If so, then this is the guide for you.

I recently achieved this certification, so in this guide, I’ll explain all there is to know about it.

Keep reading to learn all about this certification and exam.

read more…

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

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

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.

read more…

SQL CTE (WITH Clause): The Ultimate Guide

SQL CTE (WITH Clause): The Ultimate Guide

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.

read more…

132 Computer Science Faculty Share Their Advice for New CS Students

132 Computer Science Faculty Share Their Advice for New CS Students

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.

read more…

PL/SQL Tutorial: Chapter 7

PL/SQL Tutorial: Chapter 7

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

(more…)

PL/SQL Tutorial: Chapter 6

PL/SQL Tutorial: Chapter 6

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.

(more…)

PL/SQL Tutorial: Chapter 5

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

(more…)

PL/SQL Tutorial: Chapter 4

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!

(more…)

Get Your SQL Cheat Sheets Now: