Oracle SQL, PL/SQL in the cloud DB by practical examples
Complete SQL and PL/SQL courses by practical examples in the Oracle Cloud DB (ATP)
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
Why take this course?
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!