Oracle SQL, PL/SQL, ATP by practical examples (21C)
Learn SQL and PL/SQL programming with hands-on experience. Create and work with Autonomous Database in Oracle Cloud. Master DML and DDL operations, ERD diagrams, and database objects. Develop skills in program flow control, composite data types, explicit cursors, and exception handling. Suitable for students, beginner developers, IT professionals, and database administrators. Start today and enhance your career prospects.
What you’ll 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
No boring theory! You will learn in the natural way by solving problems. 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 (Home Assignment)
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.
Students completing the course will have the knowledge and skills required for a DBA and Oracle PL/SQL developer positions.
Do it today! You won’t regret it tomorrow!
Who this course is for:
- 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
User Reviews
Be the first to review “Oracle SQL, PL/SQL, ATP by practical examples (21C)”
You must be logged in to post a review.
There are no reviews yet.