Oracle SQL, PLSQL in the cloud DB by practical examples

Oracle SQL, PL/SQL in the cloud DB by practical examples, available at $89.99, has an average rating of 4.05, with 60 lectures, 8 quizzes, based on 54 reviews, and has 301 subscribers.

You will learn about Create and Work with Autonomous Database in the Oracle Cloud Learn structured query language (SQL) to an intermediate/advanced level Be able to write SQL statements that create different database objects. Working with Composite Data Types Handling Exceptions Creating Procedures and Functions Writing executable statements Using explicit cursors This course is ideal for individuals who are Students, Beginner Developers or IT professionals or Students who wants to be expert in PL/SQL programming or Junior programmers who need to find better jobs or Students who want to be expert in PL/SQL programming or Database Administrators It is particularly useful for Students, Beginner Developers or IT professionals or Students who wants to be expert in PL/SQL programming or Junior programmers who need to find better jobs or Students who want to be expert in PL/SQL programming or Database Administrators.

Enroll now: Oracle SQL, PL/SQL in the cloud DB by practical examples

Summary

Title: Oracle SQL, PL/SQL in the cloud DB by practical examples

Price: $89.99

Average Rating: 4.05

Number of Lectures: 60

Number of Quizzes: 8

Number of Published Lectures: 60

Number of Published Quizzes: 8

Number of Curriculum Items: 68

Number of Published Curriculum Objects: 68

Original Price: $49.99

Quality Status: approved

Status: Live

What You Will Learn

Create and Work with Autonomous Database in the Oracle Cloud

Learn structured query language (SQL) to an intermediate/advanced level

Be able to write SQL statements that create different database objects.

Working with Composite Data Types

Handling Exceptions

Creating Procedures and Functions

Writing executable statements

Using explicit cursors

Who Should Attend

Students, Beginner Developers or IT professionals

Students who wants to be expert in PL/SQL programming

Junior programmers who need to find better jobs

Students who want to be expert in PL/SQL programming

Database Administrators

Target Audiences

Students, Beginner Developers or IT professionals

Students who wants to be expert in PL/SQL programming

Junior programmers who need to find better jobs

Students who want to be expert in PL/SQL programming

Database Administrators

You don’t have to be a know-it-all to dive into coding for real-life projects. This course throws you right into the action, tackling problems from the very start. Before you know it, you’ll be crafting solutions for real-world projects with confidence and speed.

No boring theory!  The course is designed with an emphasis on hands-on experience.  Every topic has a detailed explanation video and tasks you have to perform by yourself.

At first, we will learn some general SQL and Database topics:

Create an Autonomous Transaction Processing Database in the Oracle Cloud and configure a connection.

Learn how to create ERD diagrams.

Learn about different types of Database Objects, Data Types, etc.

Learn how to perform DML operations: SELECT/INSERT/UPDATE/DELETE

Learn DDL operations: CREATE TABLE/INDEX/SEQUENCE/TRIGGER

Create additional schemas and load data.

Learn Built-in Functions, JOIN operations, Subqueries, etc.

With these basics mastered, the course will take you through program flow control by teaching you PL/SQL topics:

How to use for loops, while loops, and conditional if-else statements to add complexity and functionality to your programs.

Working with Composite Data Types.

Working with explicit cursors.

Handling Exceptions.

Creating Procedures and Functions.

Complete with working files and code samples, you’ll be able to work alongside the author as you work through each concept.

Finally, we will develop several solutions for real-world projects. With this experience under your belt, you’ll be infused with the confidence to seize any opportunity that comes your way, no matter how challenging it may seem.

Students completing the course will have the knowledge and skills required for a DBA and Oracle PL/SQL developer positions.

Get ready to thrive!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: What is a Database?

Lecture 1: What is a Database?

Chapter 3: Create ATP database in the Cloud

Lecture 1: Create an Always Free Cloud Account

Lecture 2: Create ATP database

Lecture 3: Install SQL Developer

Lecture 4: Connect to ATP ( SQL Developer )

Lecture 5: Open ATP if it was stopped

Chapter 4: Create ERD

Lecture 1: Create ERD

Chapter 5: What is SQL?

Lecture 1: What is SQL?

Chapter 6: DML

Lecture 1: SELECT statement

Lecture 2: INSERT statement

Lecture 3: UPDATE AND DELETE

Lecture 4: MERGE statement

Chapter 7: Database Objects

Lecture 1: Database Objects

Chapter 8: Data Types

Lecture 1: Data Types

Chapter 9: Normalization

Lecture 1: Database Normalization

Chapter 10: DDL

Lecture 1: CREATE TABLE

Lecture 2: CREATE INDEX

Lecture 3: CREATE SEQUENCE

Lecture 4: Practice Exercise: Create table, sequence and index

Lecture 5: CREATE TRIGGER

Lecture 6: ALTER TABLE

Lecture 7: DROP TABLE

Lecture 8: Advance topic: A real life example

Chapter 11: Load Sample Schemas to ATP database

Lecture 1: Load HR schema to ATP

Lecture 2: Load more schemas

Chapter 12: Built-in Functions

Lecture 1: Single-Row Functions

Lecture 2: NULL Functions

Lecture 3: Conversion Functions

Lecture 4: IF-ELSE Functions

Lecture 5: Aggregated Data and Group Functions

Chapter 13: JOIN Tables

Lecture 1: JOINs

Lecture 2: Intro to JOINs

Chapter 14: Subqueries

Lecture 1: Subqueries

Lecture 2: WITH clause

Chapter 15: SQL Interview Example

Lecture 1: Prepare to the Interview

Chapter 16: BONUS: 1Z0-082 Exam Examples

Lecture 1: 1Z0-082 topics

Chapter 17: What is a PL/SQL?

Lecture 1: Introduction

Chapter 18: OCI Cloud Shell

Lecture 1: Login to ATP via Cloud Shell

Chapter 19: Load Data to DB

Lecture 1: Load Data from a CSV file by using Linux commands

Lecture 2: Load Data from a CSV file by using External Tables (part 1)

Lecture 3: Load Data from a CSV file by using External Tables (part 2)

Lecture 4: Load Data from a CSV file by using SQL Loader

Chapter 20: PL/SQL variables

Lecture 1: variables

Chapter 21: PL/SQL executable statements

Lecture 1: executable statements

Chapter 22: PL/SQL control structures

Lecture 1: control structures

Lecture 2: Practical Examples

Lecture 3: Create User Task

Chapter 23: PL/SQL composite data types

Lecture 1: PL/SQL records

Lecture 2: PL/SQL associative arrays (INDEX BY tables)

Lecture 3: PL/SQL nested tables

Lecture 4: PL/SQL VARRAYS

Chapter 24: PL/SQL Explicit Cursors

Lecture 1: explicit cursors

Chapter 25: PL/SQL Exceptions

Lecture 1: Handling an exception

Chapter 26: PL/SQL Procedures & Functions

Lecture 1: Introduction

Chapter 27: Self Education

Lecture 1: Procedures and Functions

Chapter 28: Projects

Lecture 1: DWH files

Lecture 2: Library Management App

Lecture 3: Quiz App

Chapter 29: Bonus: Performance

Lecture 1: Performance tuning recommendations

Instructors

Oleksiy Gusarov
Database expert at Oracle

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 7 votes

4 stars: 5 votes

5 stars: 41 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!