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.

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

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

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: 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…)

PL/SQL Tutorial: Chapter 3

PL/SQL Tutorial Chapter 3: Conditions and Loops

In this chapter, you’ll learn about:

Conditions (If, Then, Else)
Loops
Commenting Code

These are common features of other programming languages, and PL/SQL lets you use these features as well.

(more…)

PL/SQL Tutorial: Chapter 1

PL/SQL Tutorial Chapter 1: Introduction and Your First PL/SQL Program

In this chapter, you’ll learn:

What PL/SQL is and what it stands for
The basic structure and syntax of a PL/SQL program
Write and run your first PL/SQL program

Let’s get right into it!

(more…)

PL/SQL Tutorial: Chapter 2

PL/SQL Tutorial Chapter 2: Variables and Operators

In this chapter, you’ll learn:

What variables are and how to use them in PL/SQL
Different data types of these variables
Operators and how PL/SQL handles them

(more…)

PL/SQL Tutorial

Are you interested in learning PL/SQL?

You’ve come to the right place.

PL/SQL is not a hard language to learn, and with this tutorial, you’ll be up and running quickly with writing your first PL/SQL program and moving on to more features of this language.

So, why should you read this tutorial when there’s a lot of other tutorials, books, and videos out there?

It’s easy to follow.
You’ll start writing your first PL/SQL program very early, before reading a ton of pages on theory.
It includes quiz questions and answers.
It includes code samples which you can run yourself.
It looks great.
There are no ads.

(more…)