Welcome to Oracle SQL tutorial for beginners. This is the very first step in any of Oracle professional journey. This course is a must for everyone who wants to understand, work in an Oracle database.
The cool thing you do not need any major programming background to complete this course. We will start from scratch and keep on building up our concepts. As this is a beginner course, you might feel bored if you already know SQL Basics. If you have worked with any other SQL based languages then it will be easy to grasp. However, it is absolutely fine for the newcomers.
We will start with the brief introduction of the SQL language. We will understand its basic structure. After that, we will understand RDBMS concepts, databases, tables, datatypes. Then we will understand the tool we will use in this course.
After understanding the basic things, we will work with different examples, operations, and real-life issues.
This page contains (Skip to topic)..
- Try On Prerequisites
- Getting started with SQL (Oracle Tutorial Basics)
- Getting ready for SQL lab practice at home
- SQL Developer Basics
- Select Query
- Where Clause
- Sorting DATA
- String Functions
- Number Functions
- Date Functions
- Joining Table Data
- Modifying Data
- Modifying Database Objects
- Working with Groups
- Beyond the basics
This SQL Basics in Oracle 12c does not require any major prior knowledge. As I have stated have said above, any experience in other SQL based languages will definitely make things easier.
Try On Prerequisites
There are a couple of ways you can set up your local environment with Oracle 12c running.
- Oracle demo developer VM ( Oracle VirtualBox required )
- Oracle 12c + SQL Developer ( JDK required )
All the above software are free and available for download at oracle.com.
Here are the topics we will cover in this course.
Getting started with SQL (Oracle Tutorial Basics)
Getting ready for SQL lab practice at home
SQL Developer Basics
- What is Oracle SQL Developer?
- Create Connection to a database
- Update existing connection
- Delete a connection
- Finding Database Objects
- Filtering Database Objects
- Refresh in SQL Developer
- Query output section
- SQL Execution Logs
- What is the SELECT Query?
- Selecting all columns data
- Selecting specific columns data
- Selecting Anything From DUAL
- Calculation as new columns
- Column aliases
- Filter some rows with WHERE clause
- Filter rows based on string patterns with WHERE clause
- Filter based on Numeric values or ranges with WHERE clause
- Filter based on dates
- What is a function in Oracle?
- SUBSTR for extraction substring in Oracle
- Length to calculate string length in Oracle
- CONCAT to append string in Oracle
- LOWER, UPPER to transform strings
- INSTR to find a letter or string position
- RPAD usages
- TO_CHAR with number
- TO_CHAR with character
- TO_CHAR with date
Joining Table Data
- What is SQL Join?
- Joining mechanism
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL OUTER JOIN
- Table Aliasing
- Oracle syntax vs ANSI Syntax for JOINS
- Introduction to DML, DDL
- CREATE TABLE in Oracle
- Insert data to a table in Oracle
- Deleting rows from a table in Oracle
- Updating values in Oracle
- Truncate table
Modifying Database Objects
Working with Groups
- Aggregate functions
- How to use GROUP BY
- GROUP BY with MAX, MIN, AVG, COUNT, SUM
- GROUP BY with HAVING clause
Beyond the basics
Constraints Primary key Foreign Key NOT NULL constraints Check constraints Sub-queries