Oracle SQL

Oracle SQL is a programming language used to manage relational databases and is commonly used with oracle database.

The oracle SQL course includes hands-on exercises to help students apply their knowledge and gain practical experience using oracle SQL. It is designed for beginners who want to learn SQL and work with Oracle databases. After completing the oracle SQL course, students should have a good understanding of SQL concepts, be able to write basic and advanced SQL queries, and have the skills needed to work with oracle databases. Additionally, students may be prepared to take the oracle SQL certification exam.

Intended audience

SQL Developer, Database Adminstrator

Prerequisites

Prior knowledge of Oracle SQL Fundamentals

Assessment & certification

Assessment fee: Included — no extra fee
Assessment mode: Online
Assessment type: MCQ
Assessment provider: GUVI
Certificate provider: SQL Developer, Database Adminstrator

Syllabus

Week 1: Introduction to Oracle SQL, including its features and benefits.
Week 2: Basic SQL concepts, such as the SELECT statement, filtering data, and sorting data.
Week 3: Advanced SQL concepts, such as joining tables, using subqueries, and working with functions.
Week 4: Data manipulation language (DML) statements, such as INSERT, UPDATE, and DELETE.
Week 5: Data definition language (DDL) statements, such as CREATE, ALTER, and DROP.