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.
read more…
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
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.
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
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!
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.
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!
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
PL/SQL Tutorial
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.
SQL Limit: The Complete Guide to SQL Row Limiting and Top-N Queries
Do you need to get the top rows in an SQL query?
Do you need to perform pagination, or find the top 5 or 10 results from a query?
You can do that in SQL using a “row limiting” feature.
Learn how to use this SQL limit feature in this article.
Ben Brumm
DatabaseStar
Popular Posts
